• Resolved zoblue

    (@zoblue)


    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 1

    The 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!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error in options table’ is closed to new replies.