PDA

View Full Version : Need help, database error 1016


melmunch
11 Jul 2008, 12:42
My forum started experiencing difficulty last night and has now been offline since then and keeps showing a database error. You can see the error at www.insurance-forums.net/forum

My forum admin guy is on his honeymoon and I am getting desperate. Can anyone help me figure this out? I will gladly pay.

Thanks

Dismounted
11 Jul 2008, 13:33
The error that occurs is this one:
Database error in vBulletin 3.6.7:

Invalid SQL:
select p.threadid, t.forumid from sam_post p left join sam_thread t on(t.threadid = p.threadid) where p.userid = 0;

MySQL Error : Can't open file: 'sam_post.MYI' (errno: 145)
Error Number : 1016
Date : Friday, July 11th 2008 @ 08:31:42 AM
Script : http://www.insurance-forums.net/forum/
Referrer : http://www.vbulletin.org/forum/showthread.php?t=185001
IP Address : 59.167.130.254
Username : Unregistered
Classname : vb_database
Most likely, your database has become corrupt, to fix this, try running this command (in phpMyAdmin or something where you can execute queries).
REPAIR TABLE sam_post