MyBB Community Forums

Experiencing some 1.6 problems all of a sudden. Has been fine up in till now.

This is really important to get fixed because I've got a forum with over 200,000 posts so this is not acceptable in current state.

Error message when clicking on the latest post.

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
144 - Table './forumname/mybb_posts' is marked as crashed and last (automatic?) repair failed
Query:
SELECT pid FROM mybb_posts WHERE tid=10745 ORDER BY dateline DESC LIMIT 0, 1

Clicking on a forum name gets me this error:

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
144 - Table './forumname/mybb_posts' is marked as crashed and last (automatic?) repair failed
Query:
SELECT tid,uid FROM mybb_posts WHERE uid='1' AND tid IN (10742,10728,10346,10585,10745,10735,10746,10741,10740,10721,10732,10744,10743,10736,10727,10737,10739,10733,10726,10731)

Please help me fix this ASAP!


THANKS![/align]

You'll need to repair it in phpMyAdmin and if it keeps happening, talk to your host about it. There's little we can do about crashed tables.

Any idea how i can repair it? Worried about this!

phpMyAdmin -> Click forum database on left -> click tickbox next to crashed table(s) -> Select REPAIR TABLES in drop down.

Or run this query:

REPAIR TABLE `mybb_posts`;

Or just run this in phpMyAdmin:

REPAIR TABLE `mybb_posts`;

Thanks for the replies.

When I ran the query, it says "You have to choose at least one column to display", therefore did do anything..?

When I click on mybb_posts I am given this error on the screen.


Error

SQL query: Edit

SHOW INDEX FROM mybb_posts ;

MySQL said: Documentation
#144 - Table './"forumname"/mybb_posts' is marked as crashed and last (automatic?) repair failed


No idea what's happening

Go to phpMyAdmin, choose your MyBB database, then click SQL and run the query.

Thanks boss.