2007-04-05, 02:57 PM
Whenever I get to the second page in a thread and I try to get to it I get an error message that says:
mySQL error: 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 '-2, 10' at line 1
Query: SELECT s.*, s.username AS shoutusername, u.username, u.usergroup, u.displaygroup FROM purplehaze_shouts s LEFT JOIN purplehaze_users u ON (u.uid=s.uid) ORDER BY dateline LIMIT -2, 10
mySQL error: 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 '-2, 10' at line 1
Query: SELECT s.*, s.username AS shoutusername, u.username, u.usergroup, u.displaygroup FROM purplehaze_shouts s LEFT JOIN purplehaze_users u ON (u.uid=s.uid) ORDER BY dateline LIMIT -2, 10