vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Anyone know how i fix this error (https://vborg.vbsupport.ru/showthread.php?t=206955)

Mancunian_Red 03-01-2009 12:34 AM

Anyone know how i fix this error
 
Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM post AS post
LEFT JOIN threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = 1)
WHERE dateline >= 1235857518 AND dateline > IF(threadread.readtime IS NULL, 1235010424, threadread.readtime)
AND visible = 1;

MySQL Error : Table './mancred_techwars/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Saturday, February 28th 2009 @ 08:27:04 PM
Error Date : Saturday, February 28th 2009 @ 08:27:04 PM
Script : http://www.techwars.co.uk/index.php
Referrer : http://www.techwars.co.uk/admincp/index.php?do=head
IP Address : 217.171.129.72
Username : Mancunian_Red
Classname : vB_Database
MySQL Version : 5.1.30

Any help would be appreciated i am stuck i honestly don't know what i have done wrong.

gsmph 03-01-2009 02:16 AM

go to your includes/config.php

and add this line right under <?php

define('DISABLE_HOOKS', true);



br

gsmph

vbplusme 03-01-2009 02:22 AM

Actually, you haven't done anything wrong, one (or more) or your tables got corrupted / crashed. You should go into your phpMyAdmin and check all your tables, repair any that need it and see if that fixes the problem. With luck, it will only be this table that crashed but you should check them all.

Mancunian_Red 03-01-2009 03:24 AM

Quote:

Originally Posted by vbplusme (Post 1757303)
Actually, you haven't done anything wrong, one (or more) or your tables got corrupted / crashed. You should go into your phpMyAdmin and check all your tables, repair any that need it and see if that fixes the problem. With luck, it will only be this table that crashed but you should check them all.

Excellent advise worked a treat thank you for your help.:up:

vbplusme 03-01-2009 03:46 AM

Hooray for you! Glad it worked out.

Marco van Herwaarden 03-02-2009 07:38 AM

Quote:

Originally Posted by gsmph (Post 1757296)
go to your includes/config.php

and add this line right under <?php

define('DISABLE_HOOKS', true);



br

gsmph

Please only give advise if you know what is the cause and solution to a problem. The solution you are suggesting has nothing to do with the problem posted.


All times are GMT. The time now is 10:52 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.01497 seconds
  • Memory Usage 1,718KB
  • 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
  • (2)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