iThemes Security (formerly Better WP Security)
Multisite (sub-directory) database error - Table not found (workaround) (1 post)

  1. tunjic
    Posted 2 years ago #

    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/domain.com/wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, ITSEC_Lockout->check_lockout, referer: http://www.domain.com/wp-admin/network/admin.php?page=toplevel_page_itsec_settings

    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.


Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic