wp_0_options

  • Resolved davemosk

    (@davemosk)


    7 years, 10 months ago

    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

    (@davemosk)

    7 years, 10 months ago

    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

    (@atomicjeep)

    7 years, 10 months ago

    I’m getting this error too, it seems to be stopping a backup plugin (WPMUDEV Snapshop) from completing it’s job.

    wfalaa

    (@wfalaa)

    7 years, 9 months ago

    Hi @davemosk and @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.

Tags