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.
Pages: 1 2
I am on a Debian 8 x64 VPS running mariadb and nginx 1.8 running mybb 1.8.5. I would like to upgrade to 1.8.6 but am concerned these errors will affect something.

I get this error when I try to back up locally on the VPS using the admin mod panel

SQL Error:
144 - Table './htpcguidesmybbdb/mybb8_adminoptions' is marked as crashed and last (automatic?) repair failed
Query:
SELECT * FROM mybb8_adminoptions WHERE uid='1'

Then I enter MySQL and repair the table and verify it has been repaired, then when I try to back up on the VPS again and get this error

SQL Error:
144 - Table './htpcguidesmybbdb/mybb8_adminoptions' is marked as crashed and last (automatic?) repair failed
Query:
SHOW FIELDS FROM mybb8_adminoptions

Then I try and back up again and get the first error.

I am able to mysqldump after repairing so I believe everything is safe.

The forum is at http://forum.htpcguides.com
Bump, could really use some help here
Try contacting your host and let them know all the tables keep crashing. They might have an issue with their phpmyadmin set up.
I am the admin and it is only this specific table that is crashing. phpmyadmin is not even installed.
Try backing up using the command line (mysqldump). It's probably more reliable than the ACP backup tool.
mysqldump works successfully as pointed out in OP

So the question is why is the ACP breaking my admin tables?
Maybe its because you are running MariaDB? I know you can use it as a dropin for MySQL, but I am not sure if the MyBB team have said they support MariaDB "out of the box".
MyBB works fine with MariaDB. If a table keeps crashing it's a problem with the database server and not with MyBB.
(10-27-2015, 11:01 AM)blindpet Wrote: [ -> ]mysqldump works successfully as pointed out in OP

So the question is why is the ACP breaking my admin tables?

Whoops, missed that. A common reason for tables crashing is the partition where MySQL stores its data running out of space. Also hardware (memory) and software (MariaDB? PHP?) errors.

You could try to use Aria instead of MyISAM as it has better crash recovery features.
The hard drive has 20 GB of space and is barely using 3 GB. It has been running smoothly for months but the last successful backup was a month ago.

I'm using php 5.6 and the Mariadb 10.0.20.

Right after I try to run the backup the error log shows no errors and only shows this in access log

IP - - [28/Oct/2015:19:28:52 -0400] "POST /admin/index.php HTTP/1.1" 200 3592 "https://forum.htpcguides.com/admin/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36"
IP - - [28/Oct/2015:19:29:50 -0400] "GET /admin/index.php?module=tools-backupdb HTTP/1.1" 200 2244 "https://forum.htpcguides.com/admin/index.php" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36"
IP - - [28/Oct/2015:19:30:00 -0400] "GET /admin/index.php?module=tools-backupdb&action=backup HTTP/1.1" 200 3774 "https://forum.htpcguides.com/admin/index.php?module=tools-backupdb" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36"
IP - - [28/Oct/2015:19:30:08 -0400] "POST /admin/index.php?module=tools-backupdb&action=backup HTTP/1.1" 503 2049 "https://forum.htpcguides.com/admin/index.php?module=tools-backupdb&action=backup" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36"
IP - - [28/Oct/2015:19:30:08 -0400] "GET /admin/index.php?action=mybb_logo HTTP/1.1" 200 12664 "https://forum.htpcguides.com/admin/index.php?module=tools-backupdb&action=backup" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36"

Is there a straightforward way to convert to Aria without breaking anything?

I'd like to reiterate that I can easily dump the database with mysqldump and repair it in the sql cli so I am failing to see why it's not a mybb issue

MariaDB [htpcguidesmybbdb]> repair table mybb8_adminoptions;
+-------------------------------------+--------+----------+----------+
| Table                               | Op     | Msg_type | Msg_text |
+-------------------------------------+--------+----------+----------+
| htpcguidesmybbdb.mybb8_adminoptions | repair | status   | OK       |
+-------------------------------------+--------+----------+----------+
1 row in set (0.00 sec)

Update: to anybody else who gets this error, after repairing the table, check the table engine with this command after selecting the mybbdatabase in the sql cli

show table status where Name = 'mybb_adminoptions';

If it is myisam or anything else, change the table to use aria like this

alter table mybb8_adminoptions engine=Aria;

Now I can back up again in the admin panel, thank you Nathan Smile

Edit 2: This only worked once and now the same table is broken again. The only thing I can think of that has changed is using https instead of http, is there some value I can change to force it to be https always?
Pages: 1 2