Error in options table
-
The website I help maintain went down so I tried logging into the site’s WordPress dashboard. It showed me it one or more database tables were unavailable and needed to be repaired. I had to add this line to the wp-config.php file:
define('WP_ALLOW_REPAIR', true);
After doing that and refreshing the page, I chose “Repair Database” from the two repair options it showed me. It then listed messages about repairing tables and at the end, it couldn’t fix one table:
_2DB_options: Wrong block with wrong total length starting at 11752
The repair brought the site back up and it’s running ok so I logged into phpMyAdmin so I could export the table as a backup and it showed me the following errors at the bottom:
Error reading structure for table wp_cl._2DB_options: #145 – Table ‘./wp_cl/_2DB_options’ is marked as crashed and should be repaired
Error reading data for table wp_cl._2DB_options: #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘FROM
wp_cl
._2DB_options
‘ at line 1The site is running but I don’t know how to fix those errors or what next steps to take. If I share the exported table from phpMyAdmin, what could I tell an SQL dev to look for or how to fix these errors? Thanks in advance!
- The topic ‘Error in options table’ is closed to new replies.