MyBB Community Forums

Full Version: MyBB SQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
When I select My Forum under the My Category heading the following error appears.  Solution?

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
130 - Incorrect file format 'mybb_threadsread'
Query:
SELECT COUNT(t.tid) AS unread_count FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='8') LEFT JOIN mybb_forumsread fr ON (fr.fid=t.fid AND fr.uid='8') WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND t.fid IN (2) AND t.lastpost > IFNULL(tr.dateline,1490752804) AND t.lastpost > IFNULL(fr.dateline,1490752804) AND t.lastpost>1490752804
the error simply means that the file is not accessible for execution.

btw, are you upgrading existing forum or installing MyBB forum afresh ?
Solved other permission error. Now receiving the MyBB SQL error
looks like the table is corrupt. try repairing it from database manager (eg. phpMyAdmin)
Do you know what is to be repaired in phpMyAdmin file?
repair table `mybb_threadsread`

see also common sql queries guidance
Tried to repair/optimize table and received error.
kirkpat5_myBB.mybb_threadsread repair Error Incorrect file format 'mybb_threadsread'
kirkpat5_myBB.mybb_threadsread repair error Corrupt

Is there a way to delete and replace the table?