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 3 replies - 16 through 18 (of 18 total)
  • Ah, sorry – I got it to work this time around, I’d originally copied your code from the automated email response which had omitted a space before the db prefix and included a ‘ on the end. So is this promising? and should it work if I manually create the others tables?, how would I do this? thanks for your patience

    Plugin Author wpsolutions

    (@wpsolutions)

    In that case you can try manually creating the rest of the tables.
    Remember to change the table names if you have a different table prefix.

    =================================

    CREATE TABLE IF NOT EXISTS wp_aiowps_events (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    event_type varchar(150) NOT NULL DEFAULT ”,
    username varchar(150) DEFAULT NULL,
    user_id bigint(20) DEFAULT NULL,
    event_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    ip_or_host varchar(100) DEFAULT NULL,
    referer_info varchar(255) DEFAULT NULL,
    url varchar(255) DEFAULT NULL,
    event_data longtext,
    PRIMARY KEY (id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS wp_aiowps_failed_logins (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    user_id bigint(20) NOT NULL,
    user_login varchar(150) NOT NULL,
    failed_login_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    login_attempt_ip varchar(100) NOT NULL DEFAULT ”,
    PRIMARY KEY (id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS wp_aiowps_global_meta (
    meta_id bigint(20) NOT NULL AUTO_INCREMENT,
    date_time datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    meta_key1 varchar(255) NOT NULL,
    meta_key2 varchar(255) NOT NULL,
    meta_key3 varchar(255) NOT NULL,
    meta_key4 varchar(255) NOT NULL,
    meta_key5 varchar(255) NOT NULL,
    meta_value1 varchar(255) NOT NULL,
    meta_value2 text NOT NULL,
    meta_value3 text NOT NULL,
    meta_value4 longtext NOT NULL,
    meta_value5 longtext NOT NULL,
    PRIMARY KEY (meta_id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS wp_aiowps_login_activity (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    user_id bigint(20) NOT NULL,
    user_login varchar(150) NOT NULL,
    login_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    logout_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    login_ip varchar(100) NOT NULL DEFAULT ”,
    login_country varchar(150) NOT NULL DEFAULT ”,
    browser_type varchar(150) NOT NULL DEFAULT ”,
    PRIMARY KEY (id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    Hi and thanks for that,

    The errors appear to have been cleared for now so that’s great! Obviously my only remaining concerns are with updating the plugin successfully or overlooking a potential security hole?? I guess the only thing to do for now is rerun the disabling/deleting plugin procedure and see if the tables get dropped or emptied?? Any advice on things I should be out looking for would be greatly appreciated.

    Thanks again for all your help and a great plugin

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