Database tables missing – increasing system error_log

  • Resolved Root Creations

    (@root-creations)


    11 years, 5 months ago

    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://ww.wp.xz.cn/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://ww.wp.xz.cn/plugins/all-in-one-wp-security-and-firewall/

Viewing 3 replies - 16 through 18 (of 18 total)
1 2
  • Thread Starter Root Creations

    (@root-creations)

    11 years, 5 months ago

    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 Contributor wpsolutions

    (@wpsolutions)

    11 years, 5 months ago

    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;

    Thread Starter Root Creations

    (@root-creations)

    11 years, 5 months ago

    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)
1 2

The topic ‘Database tables missing – increasing system error_log’ is closed to new replies.