Support » Plugin: All In One WP Security & Firewall » Database tables missing – increasing system error_log

  • Resolved Root Creations

    (@root-creations)


    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

    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/

Viewing 15 replies - 1 through 15 (of 18 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    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?

    Plugin Author wpsolutions

    (@wpsolutions)

    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?

    Plugin Contributor mbrsolution

    (@mbrsolution)

    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

    Plugin Author wpsolutions

    (@wpsolutions)

    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?

    Plugin Author wpsolutions

    (@wpsolutions)

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

    Plugin Author wpsolutions

    (@wpsolutions)

    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

    Plugin Author wpsolutions

    (@wpsolutions)

    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

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Database tables missing – increasing system error_log’ is closed to new replies.