vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.


All times are GMT. The time now is 01:06 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01288 seconds
  • Memory Usage 1,738KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete