PDA

View Full Version : Database error in vBulletin 3.0.0 Beta 5:


vB3Dev.Com
Wed 3rd Sep '03, 8:27pm
Database error in vBulletin 3.0.0 Beta 5:

Invalid SQL: UPDATE thread SET replycount = replycount + 1, lastpost = 1062631403, lastposter = 'Queen of the Damned' WHERE threadid = 313
mysql error: Got error 22 from table handler

mysql error number: 1030

Date: Wednesday 03rd of September 2003 07:23:24 PM
Script: http://politicsforum.com/newreply.php
Referer: http://politicsforum.com/newreply.php?do=newreply&p=2682
Username: Queen of the Damned


Why is this happening and how do i fix it?

vB3Dev.Com
Wed 3rd Sep '03, 8:37pm
And when this happened a whole thread vanished.
Any way i can recover the thread?

Steve Machol
Wed 3rd Sep '03, 10:09pm
Error code 22: Invalid argument

Hmmm...if you are running the default, unmodified files then I don't know why you'd get this error. Have you modified any files or added some extra code to the phpinclude templates?

As for the missing thread, try repairing the thread table with this query:

REPAIR TABLE thread;

vB3Dev.Com
Wed 3rd Sep '03, 10:33pm
No I did not add any code at all.

Steve Machol
Wed 3rd Sep '03, 11:46pm
And did you run the query?