MyBB Community Forums

My Mysql has crashed.. Plzz guide me to repair it.. Plzz help anyone..

Here is the error !!

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
144 - Table './dotsikhz_biki/mybb_posts' is marked as crashed and last (automatic?) repair failed
Query:
SELECT u.uid,u.username,u.displaygroup,u.usergroup,u.avatar,COUNT(*) AS ptoday FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE p.dateline > 1356541457 GROUP BY p.uid ORDER BY ptoday DESC LIMIT 0,5

Please contact the MyBB Group for support.

run this in phpMyAdmin

REPAIR TABLE `mybb_posts`; 

Its still showing ....

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''mybb_posts'' at line 1

You have to use backticks, not quotes.

While I don't know what this is about, it made me curious: what is the cause of such error?

Means the table in question crashed and an automated attempt by the SQL server to bring it back up failed.