Log in

View Full Version : [urgent] database error


geevest.com
11-15-2007, 11:05 AM
Database error in vBulletin 3.6.8:

Invalid SQL:
DELETE FROM strikes WHERE striketime < 1195128249;

MySQL Error : Incorrect key file for table 'strikes'; try to repair it
Error Number : 1034
Date : Thursday, November 15th 2007 @ 08:04:09 AM
Script : http://namedomain.com/forum/login.php?do=login
Referrer : http://namedomain.com/forum/admincp/options.php?dogroup=vbbux
IP Address : 61.247.2.96
Username : strider
Classname : vb_database

i dont know why..
anyone can help?

Marco van Herwaarden
11-16-2007, 06:14 AM
To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.