Title: Table &#039;wordpress-mu.wp_itsec_lockouts&#039; doesn&#039;t exist
Last modified: September 1, 2016

---

# Table 'wordpress-mu.wp_itsec_lockouts' doesn't exist

 *  Resolved [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * (@gandalfhh)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/)
 * hi there!
    i use a WordPress Multisite installation. ithemes Security created
   the tables for each site: wp_32_itsec_lockouts wp_32_itsec_log wp_32_itsec_temp
 * for each site. But all tables are empty….
    But in http.error.log I got these 
   lines:
 * `AH01071: Got error 'PHP message: WordPress-Datenbank-Fehler Table 'wordpress-
   mu.wp_itsec_lockouts' doesn't exist f\xc3\xbcr Abfrage SELECT`lockout_host`FROM`
   wp_itsec_lockouts`WHERE`lockout_active`=1 AND`lockout_expire_gmt`> '2016-06-22
   15:57:51' AND`lockout_host`=’xx.xx.xx.xx’; von require(‘wp-blog-header.php’),
   require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-
   settings.php’), do_action(‘init’), call_user_func_array, ITSEC_Lockout->check_lockout\
   n’
 * It seems lockout would write to the wrong tables…
    `
 * [https://wordpress.org/plugins/better-wp-security/](https://wordpress.org/plugins/better-wp-security/)

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

 *  Thread Starter [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * (@gandalfhh)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506455)
 * Correction: not every site gets the created tables, but only one.
    Every access
   to the website is checked against the table wp_itsec_lockouts, which doesnt exist.
   the name of the table in a multisite WP is wp_<nmber>_itsec_lockouts.
 * the wp_32_ … tables were created, but the lookup table is wp_itsec_lockouts.
   
   you see the difference?
 *  [dwinden](https://wordpress.org/support/users/dwinden/)
 * (@dwinden)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506539)
 * [@gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * Is this a new install of the iTSec plugin (> 5.4.x) or did you update the plugin
   from a pre 5.4.x version to the latest release ?
 * dwinden
 *  Thread Starter [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * (@gandalfhh)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506540)
 * It was an upgrade from 5.5
    i deleted all tables. Deinstall and reinstall dont
   help. Should I delete the directory as well?
 *  Thread Starter [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * (@gandalfhh)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506545)
 * Maybe I solved this error by
 * rename table wp_32_itsec_lockouts to wp_itsec_lockouts.
 * Now it works.
 * I only get these error:
 * [Thu Jun 23 10:25:58.323164 2016] [core:error] [pid 7178] [client 66.249.65.121:
   49041] AH00124: Request exceeded the limit of 10 internal redirects due to probable
   configuration error. Use ‘LimitInternalRecursion’ to increase the limit if necessary.
   Use ‘LogLevel debug’ to get a backtrace.
 *  [dwinden](https://wordpress.org/support/users/dwinden/)
 * (@dwinden)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506554)
 * [@gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * Yes, renaming the 3 iTSec plugin tables should resolve the issue.
    I consider
   that to be a workaround, because we still don’t know the cause of the issue. 
   Why did the plugin create 3 wp_32_% tables ?
 * It’s like site 32 was the current blog when the plugin was installed.
    How many
   sites exist in the multi site env ? 32 ?
 * dwinden
 *  Thread Starter [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * (@gandalfhh)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506558)
 * Hm, maybe I was in the blog 32…
    But my multisite WP has 42 tables/blog due to
   install and delete various blogs for testing purpose. But: also wp_ tables exist
   without a number. Cant guess why the _32_ tables were created after deleting 
   the log directory and the itsec tables. Maybe an incorrect selection with multisite
   blogs?
 * Thank you for help.
 *  [dwinden](https://wordpress.org/support/users/dwinden/)
 * (@dwinden)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506567)
 * [@gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * The iTSec plugin can only be installed as a network plugin by a network administrator
   in multi site. It cannot be installed by the site 32 administrator.
 * So somehow the current blog was/is at 32 while installing the iTSec plugin as
   the network administrator. It’s the only way to get 3 wp_32_itsec_% tables created…
 * Perhaps creating/deleting blogs for testing purposes causes some mixup.
 * Anyway renaming the 3 iTSec tables seems to resolve the issue for now.
    If you
   agree please mark this topic as ‘resolved’.
 * dwinden
 *  Thread Starter [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * (@gandalfhh)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506568)
 * solved by renaming the tables to the correct names.

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

The topic ‘Table 'wordpress-mu.wp_itsec_lockouts' doesn't exist’ 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/)

 * 8 replies
 * 2 participants
 * Last reply from: [gandalfhh](https://wordpress.org/support/users/gandalfhh/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/table-wordpress-muwp_itsec_lockouts-doesnt-exist/#post-7506568)
 * Status: resolved