vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   HELP! Urgent, board completely down ... (https://vborg.vbsupport.ru/showthread.php?t=187233)

KURTZ 08-04-2008 09:45 PM
HELP! Urgent, board completely down ...
 
Code:
Database error in vBulletin 3.7.2:

Invalid SQL:

                                SELECT COUNT(post.postid) as unread
                                FROM post as post FORCE INDEX (dateline)
                                INNER JOIN thread as thread USING (threadid)
                                INNER JOIN forum AS forum USING (forumid)
                                LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
                                LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
                                WHERE thread.forumid IN(01,2,70,78,17,19,79,76,75,15,67,74,18,31,24,26,29,14,21,65,54,63,61,49,51,48,56,66,55,52,62,60,59,53,64,58,57,50,16,22,32,33,68,35,3,13,9,10,72,11,12,4,5,6,7,8,71,69,34) AND thread.forumid NOT IN(0) AND thread.visible IN (0,1,2)
                                AND post.dateline > IF(threadread.readtime IS NULL, 1217888417, threadread.readtime)
                                AND post.dateline > IF(forumread.readtime IS NULL, 1217888417, forumread.readtime)
                                AND post.dateline > 1217888417
                                AND thread.lastpost > IF(threadread.readtime IS NULL, 1217888417, threadread.readtime)
                                AND thread.lastpost > IF(forumread.readtime IS NULL, 1217888417, forumread.readtime)
                                AND thread.lastpost > 1217888417;

MySQL Error  : Table './fniv_board/forumread' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Tuesday, August 5th 2008 @ 12:43:29 AM
Error Date    : Tuesday, August 5th 2008 @ 12:43:29 AM
Script        : http://www.fniv.it/board/index.php
Referrer      :
IP Address    : xxxxxxxxxx
Username      : KURTZ
Classname    : vB_Database
MySQL Version : 5.0.51a
what's up? pls help ... :S

Zachariah 08-04-2008 09:51 PM
Quote:
MySQL Error : Table './fniv_board/forumread' is marked as crashed and should be repaired
PHPmyAdmin: Run
REPAIR TABLE forumread

KURTZ 08-04-2008 10:05 PM
now runs! thx John ;)

but the question is: why this happens? i never saw an error like this ...

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

i found THIS ... a mysql 5 bug ... it's correct? it's really possible?

thx

Zachariah 08-04-2008 11:27 PM
If the server hard rebooted (loss power), it could crash tables in use.
Same thing happens w/ Windows OS (lost allocation tables, FAT tables)

All you are doing is running a maintenance command to repair the problem.
If it happens a lot report the problem to your host. There may need to be some server maintenance done.

Opserty 08-04-2008 11:58 PM
You can also repair/optimize tables through the AdminCP. Its listed under the Maintenance section.

KURTZ 08-05-2008 09:41 AM
i know thx guys for the hand :)


All times are GMT. The time now is 01:09 AM.

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.01000 seconds
  • Memory Usage 1,725KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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