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.

[leftwich86]

bump

--------------- Added 1267743315 at 1267743315 ---------------

vsn_vbulletin.post check warning Table is marked as crashed and last repair failed
vsn_vbulletin.post check warning 6 clients are using or haven't closed the table properly
vsn_vbulletin.post check warning Size of indexfile is: 493214720 Should be: 38848512
vsn_vbulletin.post check warning Size of datafile is: 468868464 Should be: 466038412
vsn_vbulletin.post check error Keypointers and record positions doesn't match
vsn_vbulletin.post check warning Found 1316406 parts Should be: 1118782 parts
vsn_vbulletin.post check error Corrupt vsn_vbulletin.postparsed check warning Table is marked as crashed
vsn_vbulletin.postparsed check warning 1 client is using or hasn't closed the table properly
vsn_vbulletin.postparsed check error Size of datafile is: 70218188 Should be: 70220312
vsn_vbulletin.postparsed check error Corrupt

[borbole]

If the repair table option doesn''t help then you should really talk to your host about it as suggested above.

But try to repair the table via myisamchk and see if that would help.

http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html

P.s. Do you have a recent backup copy of your db btw?

[leftwich86]

sunilvarma has helped us in so many ways. He took our forum from literally on it's last breath to fixing it back to 100% health.

THANK YOU SO MUCH sunilvarma