Support » Plugin: iThemes Security (formerly Better WP Security) » Multisite (sub-directory) database error – Table not found (workaround)

  • I made the move to iThemes Security 4.0.21 this morning from WP Security. I deactivated WPSecurity, and the upgrade went fine. No site errors, or configuration settings issues.

    However, I immediately had repeated database errors like this:

    [Sat Apr 12 12:06:00 2014] [error] [client] WordPress database error Table ‘name_mu.wp_itsec_lockouts’ doesn’t exist for query SELECT lockout_host FROM wp_itsec_lockouts WHERE lockout_active=1 AND lockout_expire_gmt > ‘2014-04-12 19:06:00’ AND lockout_host=’′; made by require_once(‘wp-load.php’), require_once(‘/var/www/vhosts/’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, ITSEC_Lockout->check_lockout, referer:

    Looking at the database, I noticed that the plugin does create for each of my sites (# = Site ID):

    But that’s the problem; the plugin is looking for the Table wp_itsec_lockouts, etc., with no site ID and that Database Table was not created.

    SO… a workaround… I copied/created the three needed tables, naming them without the site ID numbers, and the plugin errors are gone.

  • The topic ‘Multisite (sub-directory) database error – Table not found (workaround)’ is closed to new replies.