vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Huge MYSQL error on the site. (https://vborg.vbsupport.ru/showthread.php?t=237224)

leftwich86 03-01-2010 07:33 PM
Huge MYSQL error on the site.
 
http://i45.tinypic.com/2z9k03o.png
:erm:

snakes1100 03-01-2010 08:13 PM
Post the entire sql error.

leftwich86 03-01-2010 09:33 PM
Code:
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 03-02-2010 07:52 AM
AdminCP > Maintenance > Repair/Optimize Tables

Repair/Optimize until all say okay.

leftwich86 03-02-2010 10:39 PM
<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 03-02-2010 11:04 PM
Remove any .htaccess from your directories.

leftwich86 03-03-2010 12:03 PM
So we finally got the site "back". Our home page is back up but our forum is getting a MySQL error.

Code:
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 03-03-2010 12:32 PM
Code:
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 03-03-2010 12:33 PM
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 03-04-2010 09:21 AM
You migth have to run the repair a few times. If tables still get marked as crashed after that, contact your host.

leftwich86 03-04-2010 08:49 PM
bump

--------------- Added [DATE]1267743315[/DATE] at [TIME]1267743315[/TIME] ---------------

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 03-04-2010 09:55 PM
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 03-05-2010 02:46 AM
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


All times are GMT. The time now is 08:04 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01070 seconds
  • Memory Usage 1,743KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (13)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete