PDA

View Full Version : Database error in vBulletin 3.6.0



moltar
Sat 12th Aug '06, 2:44pm
I upgraded the forum from 3.5 the other day, and today got the following error. What could have gone wrong?




Database error in vBulletin 3.6.0:
Invalid SQL:
REPLACE INTO useractivation
VALUES
(NULL , 148, 1155402251, 22010184, 0, 2);
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Saturday, August 12th 2006 @ 01:04:11 PM
Script : http://www.example.com/cron.php?rand=523614
Referrer : http://www.example.com/
IP Address : xx.xxx.xx.xxx
Username : Unregistered
Classname : vb_database

Steve Machol
Sat 12th Aug '06, 2:49pm
Try running 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 cannot access the Admin CP you can also use phpMyAdmin to repair tables.