Title: Multisite (sub-directory) database error – Table not found (workaround)
Last modified: August 21, 2016

---

# Multisite (sub-directory) database error – Table not found (workaround)

 *  [tunjic](https://wordpress.org/support/users/tunjic/)
 * (@tunjic)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/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 208.104.132.170] 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`=’208.104.132.170′; 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](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):
    wp_#_itsec_lockouts wp_#_itsec_log wp_#_itsec_temp
 * 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.
 * [https://wordpress.org/plugins/better-wp-security/](https://wordpress.org/plugins/better-wp-security/)

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

 * ![](https://ps.w.org/better-wp-security/assets/icon.svg?rev=3529351)
 * [Kadence Security – Password, Two Factor Authentication, and Brute Force Protection](https://wordpress.org/plugins/better-wp-security/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-wp-security/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-wp-security/)
 * [Active Topics](https://wordpress.org/support/plugin/better-wp-security/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-wp-security/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-wp-security/reviews/)

## Tags

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

 * 0 replies
 * 1 participant
 * Last reply from: [tunjic](https://wordpress.org/support/users/tunjic/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/multisite-sub-directory-database-error-table-not-found-workaround/)
 * Status: not resolved