[Forum] Database error on creation of new threads / updating counters etc

[ppss]

Hey all.

Since migrating servers we've had a problem with the database. When trying to create a new thread / reply to a thread / update counters or mostly anything that writes to the database you get the following error:

Database error in vBulletin 4.0.8:
Invalid SQL:
INSERT INTO searchgroup (username, contenttypeid, groupid, userid, dateline)
VALUES ( 'alanmidd', 2, 6, 10, 1149608802 )
ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), groupid = VALUES(groupid), userid = VALUES(userid), dateline = VALUES(dateline);
MySQL Error : Failed to read auto-increment value from storage engine
Error Number : 1467
Request Date : Monday, November 22nd 2010 @ 09:04:48 AM
Error Date : Monday, November 22nd 2010 @ 09:04:48 AM
Classname : vB_Database
MySQL Version : 5.1.51

I've searched through the forums and elsewhere and the only advice I can find is to repair the searchgroup table. I've tried this, but to no avail.

Any help would be really warmly appreciated.

PPSS

[Trevor Hannant]

This appears to be a bug in MySQL. You may need to upgrade MySQL beyond 5.1.28 as this is the version that contained the fix.