Title: wp_0_options
Last modified: August 12, 2018

---

# wp_0_options

 *  Resolved [davemosk](https://wordpress.org/support/users/davemosk/)
 * (@davemosk)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/wp_0_options/)
 * I’ve just installed Wordfence on a multisite installation, and I’m getting a 
   lot of errors in my error.log file like:
 * [Sun Aug 12 22:44:24.045334 2018] [:error] [pid 6524] [client 54.36.148.191:22952]
   WordPress database error Table ‘wpmu.wp_0_options’ doesn’t exist for query INSERT
   IGNORE INTO `wp_0_options` (`option_name`, `option_value`, `autoload`) VALUES(‘
   wfSyncGeoIP.lock’, ‘1534070664’, ‘no’) /* LOCK */ made by require(‘wp-blog-header.
   php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘
   wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->
   apply_filters, wordfence::veryFirstAction, wfConfig::createLock
 * It would seem that somewhere along the way the table wp_0_options is missing.
   Any suggestions for how to fix this?
 * Thanks!

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

 *  Thread Starter [davemosk](https://wordpress.org/support/users/davemosk/)
 * (@davemosk)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/wp_0_options/#post-10584013)
 * I fixed this by manually creating the table:
    CREATE TABLE wpmu.wp_0_options (
   option_id bigint(20) unsigned NOT NULL auto_increment, option_name varchar(64)
   NOT NULL default ”, option_value longtext NOT NULL, autoload varchar(20) NOT 
   NULL default ‘yes’, PRIMARY KEY (option_id), UNIQUE KEY option_name (option_name))
   DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 *  [Paul Hart](https://wordpress.org/support/users/atomicjeep/)
 * (@atomicjeep)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/wp_0_options/#post-10585481)
 * I’m getting this error too, it seems to be stopping a backup plugin (WPMUDEV 
   Snapshop) from completing it’s job.
 *  [wfalaa](https://wordpress.org/support/users/wfalaa/)
 * (@wfalaa)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/wp_0_options/#post-10599874)
 * Hi [@davemosk](https://wordpress.org/support/users/davemosk/) and [@atomicjeep](https://wordpress.org/support/users/atomicjeep/)
 * This issue was reported to our dev team and I can see a fix for it has been scheduled
   for the next release, at the moment I don’t have an ETA for that release yet.
 * Thanks for bringing this issue to us.

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

The topic ‘wp_0_options’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

## Tags

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

 * 3 replies
 * 3 participants
 * Last reply from: [wfalaa](https://wordpress.org/support/users/wfalaa/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/wp_0_options/#post-10599874)
 * Status: resolved