Title: plugin cannot find multisite table Last modified: August 22, 2016 --- # plugin cannot find multisite table * Resolved [jlooooo](https://wordpress.org/support/users/jlooooo/) * (@jlooooo) * [11 years, 1 month ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/) * Hi, * We are running this plugin in a multisite install of wordpress. How does the plugin work with database tables in multisite? * I have this error: * `WordPress database error Table 'our_db_name.wp_3_aiowps_failed_logins' doesn't exist for query INSERT INTO wp_3_aiowps_failed_logins (user_id, user_login, failed_login_date, login_attempt_ip) VALUES ('123', 'user_x', now(), '123.12.123.*') made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, AIOWPSecurity_User_Login- >aiowp_auth_login, AIOWPSecurity_User_Login->increment_failed_logins` * When a user uses a wrong password on site with id 3. * This table: wp_3_aiowps_failed_logins doesn’t exist. Should this table be there? Or should all data be stored in wp_aiowps_failed_logins? * We use some wordpress login filters, which we like to debug, but it would be convenient to know what the result should be. * Thanks. * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) Viewing 7 replies - 1 through 7 (of 7 total) * Thread Starter [jlooooo](https://wordpress.org/support/users/jlooooo/) * (@jlooooo) * [11 years, 1 month ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949001) * Ok. I did some more debugging. * On activation the plugin should create tables for each site in wp-security.installer. php. However, when I do an error_write on some variable I see the database name is the same for both sites. * On activation of plugin. write_log($blog_id); in security.installer.php on line 8 gives: [27-Mar-2015 15:24:32 UTC] 1 [27-Mar-2015 15:24:32 UTC] 3 * write_log($wpdb->prefix); in security.installer.php on line 36 gives: [27-Mar- 2015 15:24:32 UTC] wp_ [27-Mar-2015 15:24:32 UTC] wp_3_ * write_log($lockdown_tbl_name); in security.installer.php on line 41 gives: [ 27-Mar-2015 15:24:32 UTC] wp_aiowps_login_lockdown [27-Mar-2015 15:24:32 UTC] wp_aiowps_login_lockdown * Hence, it creates database tables with the same name for the different sites. I guess the constants for the table names are not ‘updated’ after switching blogs. * Any idea what is going wrong here? * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 1 month ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949109) * Hi jlooooo did you also install the plugin in all the other sub sites? * Thread Starter [jlooooo](https://wordpress.org/support/users/jlooooo/) * (@jlooooo) * [11 years, 1 month ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949260) * The plugin is network activated yes. * [DBJ](https://wordpress.org/support/users/dbj/) * (@dbj) * [11 years, 1 month ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949288) * Thus plugin is good. Multi-site operation is not good. I suppose the logic is if someone is taking care of multisite installation that one needs no special instructions? * But, I would like to disagree. This plugin needs multisite operating mode explanations. And few details to be added for operating on multi site. * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 1 month ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949299) * [@dbj](https://wordpress.org/support/users/dbj/) thank you for your comment and suggestion. The plugin developers are always implementing more features and information for a Multisite installation. * Regards * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [10 years, 2 months ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949359) * @jloooo are you still having issues with your Multi-site installations? * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [10 years, 2 months ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949362) * I am marking this thread as resolved. No replies in 11 months. * Thank you Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘plugin cannot find multisite table’ is closed to new replies. * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256. png?rev=2798307) * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq) * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/) * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/) * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/) * 7 replies * 3 participants * Last reply from: [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/plugin-cannot-find-multisite-table/#post-5949362) * Status: resolved