Not Solved MyBB has experienced an internal SQL error and cannot continue.
#4
Not Solved
(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)
Reply


Messages In This Thread
RE: MyBB has experienced an internal SQL error and cannot continue. - by Hyperspace - 2020-03-31, 08:31 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)