Anyone know how i fix this error

[Mancunian_Red]

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]

go to your includes/config.php

and add this line right under <?php

define('DISABLE_HOOKS', true);



br

gsmph

[vbplusme]

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]

Originally Posted by vbplusme

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]

Hooray for you! Glad it worked out.

[Marco van Herwaarden]

Originally Posted by gsmph

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.