I upgraded to MySQL 5.0 and now I am getting the following error from mySQL when trying to go to the next page in the memberlog

I also checked some of the other sites listed as WoWRosterDF sites in the topic above and they do the same thing

Code: Select all

modules/WoWRosterDF/settings.php
Notice line 49: Constant ROSTER_STARTTIME already defined
Notice line 56: Constant DIR_SEP already defined
Notice line 67: Constant ROSTER_URL already defined
Notice line 73: Constant ROSTER_BASE already defined
Notice line 79: Constant ROSTER_LIB already defined
Notice line 85: Constant ROSTER_ADMIN already defined
Notice line 91: Constant ROSTER_ADDONS already defined
Notice line 97: Constant ROSTER_CONF_FILE already defined
modules/WoWRosterDF/memberlog.php
Notice line 150: Undefined variable: start
Notice line 155: Undefined variable: start
Notice line 158: Undefined variable: start
Notice line 158: Undefined variable: start
Notice line 159: Undefined variable: start
Notice line 167: Undefined variable: prev
Notice line 174: Undefined variable: start
includes/db/db.php
CMS Warning line 75: On /index.php?name=WoWRosterDF&file=memberlog&start=0&s=type&d=1 While executing query "SELECT *, DATE_FORMAT( `update_time`, '%a %b %D, %l:%i %p' ) AS 'date' FROM `cms_wowrosterdf_roster_memberlog` ORDER BY `type` DESC LIMIT , 30" the following error occured:
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 ' 30' at line 3 In: /home/content/x/y/z/xyzbaby/html/guild/modules/WoWRosterDF/lib/wowdb.php on line: 96


bump

I can't duplicate this so I don't know what's up

This should fix it.

robojerk wrote:This should fix it.

Had small bug in it, the previous (<<) button linked to non existing page for me.
Edited code, works for me now