MyBB Community Forums

I'm getting this showing on my forum now...

MySQL error: 145
Table './*******/mybb_posts' is marked as crashed and should be repaired
Query: SELECT u.uid, u.username, u.usergroup, u.displaygroup, COUNT(*) AS poststoday FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE p.dateline > 1225602564 GROUP BY p.uid ORDER BY poststoday DESC LIMIT 0,3

All I did before this happened was try to delete/remove a post, which when trying came up showing a similar error.

Any help in trying to fix this would be muchly appreciated.

Login to a database manager, and you can repair the table easily.

In phpMyAdmin, tick the checkbox next to the crashed tables (in your case mybb_posts) and then at the bottom, from the "With Selected" dropdown, select "Repair Tables".

This should repair the corrupted table...

(2008-11-03, 01:14 PM)destroyer Wrote: [ -> ]http://community.mybboard.net/thread-22002.html

I should visit that section a little more... great stuff

Cool, thanks very much you twos, that did just the trick.