Database tables missing – increasing system error_log

Hi Root Creations can you follow these instructions if you haven’t done so already to completely delete the plugin and the reinstall it again.

Thank you

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

Should I try dropping the aiowps option tables as well before reinstalling?

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”.

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

Is there an sql query I could run to manually reinstate the missing tables – ty?

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.

Sorry this does not appear to have helped

Just to confirm – is your site a single site or multisite?

It’s single site – which logs specifically should I be looking for in cPanel?

I was wondering if there are any database related logs in the error_log file?

Just to clarify, I meant any other MySQL related logs/errors other than those you’ve already mentioned.

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

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

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