I am running vBulletin 3b7 with no hacks. Right now, I have 400 users awaiting moderation. As I've said in the past, doing large moderations with vBulletin is not working.
This is the error that I get when doing moderations:
Database error in vBulletin 3.0.0 Beta 7:
Invalid SQL:
SELECT text FROM phrase
WHERE phrasetypeid = 3000
AND varname = 'moderation_deleted'
AND languageid IN(-1,0,)
ORDER BY languageid DESC
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 ')
ORDER BY languageid DESC' at line 4
mysql error number: 1064
Date: Friday 04th of June 2004 11:48:13 AM
Script: http://www.sohh.com/forums/addmen/user.php
Referer: http://www.sohh.com/forums/addmen/user.php?do=moderate
Username: ibeblunt
IP Address: 68.38.193.203
This is the error that I get when doing moderations:
Database error in vBulletin 3.0.0 Beta 7:
Invalid SQL:
SELECT text FROM phrase
WHERE phrasetypeid = 3000
AND varname = 'moderation_deleted'
AND languageid IN(-1,0,)
ORDER BY languageid DESC
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 ')
ORDER BY languageid DESC' at line 4
mysql error number: 1064
Date: Friday 04th of June 2004 11:48:13 AM
Script: http://www.sohh.com/forums/addmen/user.php
Referer: http://www.sohh.com/forums/addmen/user.php?do=moderate
Username: ibeblunt
IP Address: 68.38.193.203
Comment