Installation Note
MySQL client and server versions 4.1.0 or higher and MyISAM table support are required for Roster.
You are running
• server version - 4.0.25-standard
• client version - 4.0.25
MySQL versions less than 4.1.0 may not work and are not supported.
Versions less than 4.1.0 may have unexpected issues, and we will not provide support for these installations.
My friend who runs my hosting in her business was thinking of changing hosting companies. In the mean time does this mean the hosting company needs to upgrade it's mysql for things to work? All I get is a bunch of errors using roster now. Is there any realistic possibility of saying, "Guys, upgrade your mysql," and they'll do it?
When I go to admin.php I get: note the bold text I changed for security.
1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup,
SQL:
SELECT IF(`note` LIKE '%'s alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC
File: menu.php
Line: 55
Backtrace (most recent call last):
File: "path"/roster/lib/commonfunctions.lib.php
line 248
function called: backtrace
File: "path"/roster/lib/menu.php
line 55
function called: die_quietly
args: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, , Database Error, menu.php, 55, SELECT IF(`note` LIKE '%'s alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC
File: "path"/roster/admin.php
line 288
function called: include_once
args: "path"/roster/lib/menu.php
I'm assuming that error is due to the old mysql version being run? This occurred after I updated the character lua. BTW, total noob at this. Was just looking up mysql on wikipedia
BTW, you guys rock! I used an older version of roster for awhile and recently upgraded with this new host. The fact you answer these support posts rocks!
