Title: Database tables missing – increasing system error_log Last modified: August 22, 2016 --- # Database tables missing – increasing system error_log * Resolved [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 6 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/) * Hi, I’m experiencing a problem with a growing error_log and apparently missing DB tables, a similar post on the issue can be found here – [https://wordpress.org/support/topic/receiving-database-error-regarding-login-lockdown?replies=15](https://wordpress.org/support/topic/receiving-database-error-regarding-login-lockdown?replies=15) * I can confirm that none of the additional aiowps database tables are actually there (aside from within the options table). Nor are they being rewritten when deactivating/rectivating – deleting/reinstalling the plugin. I’m getting errors for – * aiowps_login_lockdown’ doesn’t exist aiowps_login_activity’ doesn’t exist aiowps_events’ doesn’t exist * I’m also getting the following message about the db cleanup cron job – could this be telling? * AIOWPSecurity_Cronjob_Handler->aiowps_daily_cron_event_handler, do_action(‘aiowps_perform_db_cleanup_tasks’), call_user_func_array, AIOWPSecurity_Backup->aiowps_scheduled_db_cleanup_handler, AIOWPSecurity_Utility::cleanup_table * I have had this issue with an ever increasing error_log since migrating from a local install, but I have to say other builds have been fine. I guess it’s possible I manually deleted the tables accidentally at some point during migration. But this seems unlikely as I can’t find a backup with complete tables in it so can’t identify when or if that may have happened – I love the plugin, so do my clients – please help if you can! * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) Viewing 15 replies - 1 through 15 (of 18 total) 1 [2](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/page/2/?output_format=md) [→](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/page/2/?output_format=md) * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 6 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535411) * Hi Root Creations can you follow these [instructions ](https://wordpress.org/support/topic/features-that-are-labelled-advanced?replies=15) if you haven’t done so already to completely delete the plugin and the reinstall it again. * Thank you * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535639) * Hi, * I followed the instructions to remove the plugin and reset the htaccess rules as instructed, also optimised and repaired the database. Unfortunately, when reinstalling and activating the plugin the aiowps database tables are still not being rewritten and populated. * Oddly enough the plugin configuration is being reinstated (bar the firewall options) so I’m assuming that not all the option data is erased on plugin removal, could this be preventing a solution, please instruct – ty * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535642) * Should I try dropping the aiowps option tables as well before reinstalling? * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535643) * To completely remove the plugin configuration you should also delete the row from the “options” table which has “option_name” equal to “aio_wp_security_configs”. * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535644) * Hi, I’ve tried the suggestion, reinstalled and manually reconfigured the plugin– still no joy – clearly the plugin is able to write to my database as it is saving the configuration, bizarre – to confirm the following tables are missing when comparing to other working installs * ***_aiowps_events ***_aiowps_failed_logins ***_aiowps_global_meta ***_aiowps_login_activity*** _aiowps_login_lockdown * any other ideas? – ty * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535645) * Is there an sql query I could run to manually reinstate the missing tables – ty? * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535646) * Hi, you might have a conflict with a plugin. Try and deactivate all the plugins except this one and see if the tables populate. If not keep all the plugins deactivated and delete this plug again and reinstall it without activating your other plugins. * See what happens. * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535652) * Sorry this does not appear to have helped * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535683) * Just to confirm – is your site a single site or multisite? * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535684) * It’s single site – which logs specifically should I be looking for in cPanel? * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535688) * I was wondering if there are any database related logs in the error_log file? * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535691) * Just to clarify, I meant any other MySQL related logs/errors other than those you’ve already mentioned. * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535695) * Hi, Ok – here are the extent of the errors which I am finding in greater detail– I’ve omitted (I hope) all sensitive info and replaced with hashtags as well as any effectively duplicate errors. I’d recently deleted the error_log so it wasn’t that full, but basically the errors continue to be repetitive – I hope this can shed some light – ty * [03-Dec-2014 14:32:44 UTC] WordPress database error Table ‘#db-user.db-name#_aiowps_login_activity’ doesn’t exist for query UPDATE `#db-name_aiowps_login_activity` SET `logout_date` = ‘2014-12-03 14:32:44’ WHERE `user_id` = 3 AND `login_ip` = ‘#ip.ip.ip.ip’ AND` logout_date` = ‘0000-00-00 00:00:00’ made by wp_logout, wp_clear_auth_cookie, do_action(‘clear_auth_cookie’), call_user_func_array, AIOWPSecurity_User_Login- >wp_logout_action_handler * [03-Dec-2014 14:32:44 UTC] WordPress database error Table ‘#db-user.#db-name_aiowps_login_lockdown’ doesn’t exist for query SELECT * FROM #db-name_aiowps_login_lockdown WHERE release_date > now() AND failed_login_ip LIKE ‘#ip.ip.ip.ip’ made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), call_user_func_array, AIOWPSecurity_User_Login- >aiowp_auth_login, AIOWPSecurity_User_Login->check_locked_user * [03-Dec-2014 14:42:16 UTC] WordPress database error Table ‘#db-user.#db-name_aiowps_login_activity’ doesn’t exist for query INSERT INTO #db-name_aiowps_login_activity (user_id, user_login, login_date, login_ip) VALUES (‘3’, ‘#wp-username’, ‘2014-12-03 14: 42:16’, ‘#ip.ip.ip.ip’) made by wp_signon, do_action(‘wp_login’), call_user_func_array, AIOWPSecurity_User_Login::wp_login_action_handler * [03-Dec-2014 17:15:12 UTC] WordPress database error Table ‘#db-user.#db-name_aiowps_login_lockdown’ doesn’t exist for query SELECT * FROM #db-name_aiowps_login_lockdown WHERE release_date > now() AND failed_login_ip LIKE ‘#ip.ip.ip.ip’ made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), call_user_func_array, AIOWPSecurity_User_Login- >aiowp_auth_login, AIOWPSecurity_User_Login->check_locked_user * [03-Dec-2014 17:15:12 UTC] WordPress database error Table ‘#db-user.#db-name_aiowps_login_activity’ doesn’t exist for query UPDATE `#db-name_aiowps_login_activity` SET `logout_date` = ‘2014-12-03 17:15:12’ WHERE `user_id` = 0 AND `login_ip` = ‘#ip.ip.ip.ip’ AND` logout_date` = ‘0000-00-00 00:00:00’ made by wp_clear_auth_cookie, do_action(‘ clear_auth_cookie’), call_user_func_array, AIOWPSecurity_User_Login->wp_logout_action_handler * [03-Dec-2014 21:44:34 UTC] WordPress database error Table ‘#db-user.#db-name_aiowps_login_activity’ doesn’t exist for query INSERT INTO #db-name_aiowps_login_activity (user_id, user_login, login_date, login_ip) VALUES (‘3’, ‘#wp-username’, ‘2014-12-03 21: 44:34’, ‘#ip.ip.ip.ip’) made by wp_signon, do_action(‘wp_login’), call_user_func_array, AIOWPSecurity_User_Login::wp_login_action_handler * [03-Dec-2014 21:45:47 UTC] WordPress database error Table ‘#db-user.#db-name_aiowps_events’ doesn’t exist for query select count(*) from #db-name_aiowps_events made by do_action_ref_array, call_user_func_array, AIOWPSecurity_Cronjob_Handler->aiowps_daily_cron_event_handler, do_action(‘aiowps_perform_db_cleanup_tasks’), call_user_func_array, AIOWPSecurity_Backup- >aiowps_scheduled_db_cleanup_handler, AIOWPSecurity_Utility::cleanup_table * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535705) * I’m not really sure why your system has not created the tables but can you try doing a small manual test? Log in to your site’s PHPMyAdmin and try executing the following SQL query: * ====== CREATE TABLE IF NOT EXISTS `wp_aiowps_login_lockdown` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `user_login` varchar( 150) NOT NULL, `lockdown_date` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,` release_date` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `failed_login_ip` varchar(100) NOT NULL DEFAULT ”, `lock_reason` varchar(128) NOT NULL DEFAULT ”,` unlock_key` varchar(128) NOT NULL DEFAULT ”, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ====== * **IMPORTANT: If you have changed your DB prefix, then you will need to make sure that you modify the above code so that the “wp_” portion of the table name “wp_aiowps_login_lockdown” is replaced with your new prefix.** * Eg, if your DB prefix was changed to “xyz” then the name of the table in above code would be **xyz_aiowps_login_lockdown** * Thread Starter [Root Creations](https://wordpress.org/support/users/root-creations/) * (@root-creations) * [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/#post-5535711) * Hi, the test returned this error – I changed the prefix as instructed * #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘EXISTSdbprefix_aiowps_login_lockdown`( id bigint(20) NOT NULL AUTO_INCREMENT’ at line 1 Viewing 15 replies - 1 through 15 (of 18 total) 1 [2](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/page/2/?output_format=md) [→](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/page/2/?output_format=md) The topic ‘Database tables missing – increasing system error_log’ 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/) ## Tags * [error_log](https://wordpress.org/support/topic-tag/error_log/) * [missing tables](https://wordpress.org/support/topic-tag/missing-tables/) * [tables](https://wordpress.org/support/topic-tag/tables/) * 18 replies * 3 participants * Last reply from: [Root Creations](https://wordpress.org/support/users/root-creations/) * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/database-tables-missing-increasing-system-error_log/page/2/#post-5535732) * Status: resolved