[PIKenPIK]

same probs here on VB 3.07.
like the others same DB error:

Invalid SQL: SELECT userid FROM user ORDER BY userid DESC LIMIT -1000, 1000
mysql error: 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 '-1000, 1000' at line 1

mysql error number: 1064

Date: Friday 30th of December 2005 08:53:55 PM
Script: http://www.www.xxxxxxxx.xx/forums/ad...ge=1000&page=2
Referer: http://www.xxxxxxxx.xx/forums/adminc...do=threadcount
Username: PIKenPIK
IP Address: XXXXXXXXXXX

First page seems to go well, starting with the 2nd 1.000 threads doesn't work.

Changing in misc.php: $perpage = 1000 into $perpage = 250 gives the same ...

I'm sure it's no memory prob ..... I've done major hacks and 20.000 members on the forum (done lots of maintenance with +1.000 "things" without problems) ...

Can this be fixed?

Really need the hack for further (promotion)plans.

XXX
PnP

//edit: i don't have a table prefix. (so that's not the prob).