I downloaded the update today and since then Im getting the following SQL error:

Code: Select all

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 '10 AS levelgroup, COUNT(`level`) AS amount, SUM(`level`)  
SQL:
SELECT IF(`guild_title` LIKE '%Alt%',1,0) AS 'isalt, `level` DIV 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

I even tried installing the roster from scratch (after making a backup of the old one of course) but I still get this error. Anyone else got this problem? Any pointers on what's wrong?

Replace

Code: Select all

`level` DIV 10

by

Code: Select all

FLOOR(`level`/10)

Roster requires mysql 4.1.x or higher, just like it always has

We have just implemented core code that now absolutely requires at least 4.1.0

PleegWat wrote:Replace

Code: Select all

`level` DIV 10

by

Code: Select all

FLOOR(`level`/10)

Thanks, worked like a charm.

Re-download the file, it's fixed now