The Arcive of vBulletin Modifications Site.

Help - MySQL errors, my forums are dead! · **Released**: 08-16-2002

Hey!

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

Code:

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 · #2 08-16-2002, 04: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 · #3 08-16-2002, 04:42 PM

Actually, I fixed this earlier. Dodgy syntax in the Member of the Day hack.

sparky2 · #4 08-21-2002, 04: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)