MyBB Community Forums

Full Version: MyBB SQL error 145
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,
I have been working on my localhost and since yesterday i got this error.
I tried logging into PHPmyAdmin but i couldnt find a repair table button in there.

Here is the error i get : http://i.imgur.com/VIHFz4F.png


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
145 - Table '.\mybb\mybb_forumsread' is marked as crashed and should be repaired
Query:
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder

I have tried googling but was in vain, help is appreciated.
Thank you
regards
if you can log into admin panel then you should be able to fix it through below method
admin panel >> tools & maintenance >> Task Manager >> Tables Check -->
click on right side clock image to run the task and then check if the error goes away

another method is to run SQL query from the database manager (eg. phpMyAdmin)
REPAIR TABLE `mybb_forumsread`