Title: Error in options table
Last modified: November 8, 2021

---

# Error in options table

 *  Resolved [zoblue](https://wordpress.org/support/users/zoblue/)
 * (@zoblue)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/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
   > 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)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [4 years, 7 months ago](https://wordpress.org/support/topic/error-in-options-table/#post-15047812)
 * Use PHPMYADMIN to repair the database: [https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin](https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin)
 *  Thread Starter [zoblue](https://wordpress.org/support/users/zoblue/)
 * (@zoblue)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/error-in-options-table/#post-15047877)
 * [@sterndata](https://wordpress.org/support/users/sterndata/) thank you so much!
   I followed the instructions to repair the tables and it returned no further errors.
   The tables all say repair status **OK** except for two “wfls_2fa_secrets” and“
   wfls_settings” which look like those don’t support the repairing function. I 
   will mark this as closed. Thanks again!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Error in options table’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [zoblue](https://wordpress.org/support/users/zoblue/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/error-in-options-table/#post-15047877)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics