MyBB Community Forums

Full Version: MyBB has experienced an internal SQL error and cannot continue.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
My forum quit loading and I get this error that I have no idea how to fix it.

MyBB has experienced an internal SQL error and cannot continue.
SQL Error: 126 - Index for table './hyperspa_mybb180/mybb_posts.MYI' is corrupt; try to repair it Query: SELECT COUNT(*) AS newposts FROM mybb_posts WHERE dateline > '1585581087' AND visible='1'
Please contact the MyBB Group for technical support.
This is a trouble with your database.
Try repairing it from phpmyadmin or using command line: check table mybb_posts; repair table mybb_posts;
is it occurring after logging into forum ?
can't check your forum easily due to BlockScript for my region !
(2020-03-31, 03:25 PM)Crazycat Wrote: [ -> ]This is a trouble with your database.
Try repairing it from phpmyadmin or using command line: check table mybb_posts; repair table mybb_posts;

I never used phpmyadmin before. I took a look at it and not sure where to insert the command line

(2020-03-31, 04:08 PM).m. Wrote: [ -> ]is it occurring after logging into forum ?
can't check your forum easily due to BlockScript for my region !

Update: I deleted my cookies and discovered for guests the forum is fine. The error occurs after I login. I whitelisted my IP on Blockscript to see if that had anything to do with it but it didn't help. There is no option to turn off Blockscript so I don't know if turning that off would help or not.

I discovered what the problem was. For some reason, the plugins "View Unread Posts" and "SEO Links" was causing the problem. I have no idea why those 2 plugins decided to act up.

Everything was fine and now I get a new error that prevent the forum and control panel from loading.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1021 - Disk full (/tmp/#sql_7ec9_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query:
SHOW COLUMNS FROM mybb_users LIKE 'as_uid'

Please contact the MyBB Group for technical support.

Another update: I ran the forum cleanup in the task manager and everything seems fine at the moment.

It seems I'm not out of the woods yet. I'm still getting a variety of error messages like the one below.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
126 - Index for table './hyperspa_mybb180/mybb_posts.MYI' is corrupt; try to repair it
Query:
SELECT DISTINCT tid,uid FROM mybb_posts WHERE uid='4' AND tid IN (11390,8205,288,431,6095,5994,7774) AND visible IN (-1,0,1)
The following error:

Quote:1021 - Disk full (/tmp/#sql_7ec9_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Means the hard drive your database is running on is full. If that's the case, it could be causing the table crashes. The only way to fix this is to contact your host.