PDA

View Full Version : Help - MySQL errors, my forums are dead!

NexDog
08-16-2002, 04:52 AM
Hey!

Anyone know how to troubleshoot mysql. I have this error:


Database error in vBulletin 2.2.6:

Invalid SQL: -1209600
AND (usergroupid=5
OR usergroupid=6
OR usergroupid=7
OR usergroupid=2)
ORDER BY RAND()
LIMIT 1
mysql error: You have an error in your SQL syntax near '-1209600
AND (usergroupid=5
' at line 1

mysql error number: 1064

Date: Friday 16th of August 2002 05:47:34 AM
Script: http://www.hostnexus.com/forum/forum/
Referer:


Please help!
Attrox
08-16-2002, 05:21 PM
Well, there is obviously something wrong with your usergroup table. Maybe you should restore that table only, with a previous DB back up you have?
NexDog
08-16-2002, 05:42 PM
Actually, I fixed this earlier. Dodgy syntax in the Member of the Day hack.
sparky2
08-21-2002, 05:55 PM
can you point me in the right direction ~~
how do you restore an individual MySQL table?

(using mysqladmin command, or whatever,
to pull the data out of BACKUP.SQL file)