Huge MYSQL error on the site.

[leftwich86]

http://i45.tinypic.com/2z9k03o.png
:erm:

[snakes1100]

Post the entire sql error.

[leftwich86]

Database error in vBulletin 3.8.3:
    
    Invalid SQL:
    
        SELECT SQL_CALC_FOUND_ROWS
         visitormessage.*, user.*, visitormessage.ipaddress AS messageipaddress
         ,IF(userlist.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user
         ,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
         ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
         
        FROM visitormessage AS visitormessage
        LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
        LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.type = 'buddy' AND userlist.relationid = 3)
        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
        LEFT JOIN deletionlog AS deletionlog ON (visitormessage.vmid = deletionlog.primaryid AND deletionlog.type = 'visitormessage')
        
        WHERE visitormessage.userid = 3
         AND (visitormessage.state IN ('visible','moderation','deleted'))
        
         
        ORDER BY visitormessage.dateline DESC
        LIMIT 0, 10;
    
    MySQL Error   : Table 'deletionlog' is marked as crashed and should be repaired
    Error Number  : 1194
    Request Date  : Monday, March 1st 2010 @ 05:32:51 PM
    Error Date    : Monday, March 1st 2010 @ 05:32:51 PM
    Script        : http://www.virtualsportsnet.com/forum/member.php?u=3
    Referrer      : http://www.virtualsportsnet.com/forum/index.php
    IP Address    : 1**.**.19.103
    Username      : Rush
    Classname     : vB_Database
    MySQL Version : 5.0.89-community

[ChopSuey]

AdminCP > Maintenance > Repair/Optimize Tables

Repair/Optimize until all say okay.

[leftwich86]

<a href="http://www.virtualsportsnet.com/forum" target="_blank">www.virtualsportsnet.com/forum</a>

we did this and now it's showing up as a 505 Internal error. What is the best way to solve this? The host isn't familiar with vB, so it's a little tough. Any help?

[ChopSuey]

Remove any .htaccess from your directories.

[leftwich86]

So we finally got the site "back". Our home page is back up but our forum is getting a MySQL error.

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
	Database error
The VSN - Sports & Sports Gaming News - Forums - Leagues - Rumors - Discussion database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.virtualsportsnet.com home page, then try to open another page.
Click the Back button to try another link.
The www.virtualsportsnet.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

Thank you very much for the help!

That is the problem.

www.virtualsportsnet.com/forum

[ChopSuey]

MySQL Error   : Table 'datastore' is marked as crashed and should be repaired

Go to your sites cPanel and then MySQL Databases -> Repair databse - (Choose your forum's db)

[leftwich86]

Thank you very much for the help!!!!!!!!!! Will go do that now.

--------------- Added 03 Mar 2010 at 19:16 ---------------

it went up and then went right back to how it was.

[Marco van Herwaarden]

You migth have to run the repair a few times. If tables still get marked as crashed after that, contact your host.