Multisite Fail

  • Resolved Adam Nowak

    (@adam320)


    6 years, 3 months ago

    The login lockdown feature tries to access individual tables for each multisite blog, I don’t see that any of the individual blog table sets get any of the aiowps database tables, just the main site. Error below, I got no help on my other thread.

    The plugin is network activated and I was under the impression that it kept the data in the database for the main site, the tables for the individual sites don’t exist, please fix the plugin.

    [17-Oct-2018 01:27:54 UTC] WordPress database error Table ‘XXXXXXXXXXXXXXXX_116_aiowps_login_lockdown’ doesn’t exist for query SELECT * FROM XXXXX_116_aiowps_login_lockdown WHERE release_date > ‘2018-10-17 01:27:54’ AND failed_login_ip = ‘66.249.64.46’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, AIO_WP_Security->aiowps_wp_loaded_handler, AIOWPSecurity_WP_Loaded_Tasks->__construct, AIOWPSecurity_Process_Renamed_Login_Page::renamed_login_init_tasks, require_once(‘/plugins/all-in-one-wp-security-and-firewall/other-includes/wp-security-rename-login-feature.php’), wp_signon, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, call_user_func_array, AIOWPSecurity_User_Login->block_ip_if_locked, AIOWPSecurity_User_Login->check_locked_user

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter Adam Nowak

    (@adam320)

    I just updated to the latest version to see if this was fixed. Still getting the “WordPress database error Table ‘senior85_wplive.sduwk_6_aiowps_login_lockdown’ doesn’t exist for query SELECT * FROM sduwk_6_aiowps_login_lockdown” error. These new errors are showing now:

    [26-Nov-2018 20:29:20 UTC] PHP Warning: include_once(xxxxxxxxxx/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-bot-protection.php): failed to open stream: No such file or directory in xxxxxxxxxx/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-general-init-tasks.php on line 250
    [26-Nov-2018 20:29:20 UTC] PHP Warning: include_once(): Failed opening ‘xxxxxxxxxx/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-bot-protection.php’ for inclusion (include_path=’.:/opt/cpanel/ea-php56/root/usr/share/pear’) in xxxxxxxxxx/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-general-init-tasks.php on line 250
    [26-Nov-2018 20:29:20 UTC] PHP Fatal error: Class ‘AIOWPSecurity_Fake_Bot_Protection’ not found in xxxxxxxxxx/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-general-init-tasks.php on line 251

    • This reply was modified 6 years, 3 months ago by Adam Nowak.
    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, thank you for reporting this. The plugin developers will investigate further this issue.

    Kind regards

    Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi @adam320,
    I think I found the cause of your issue and hence have improved the code which handles multisite activation and table creation. The solution will be available in the next release.
    If you’d like to try it before that release please contact me using my contact form (see my profile)

    I have the same issue.

    Looking at the Installer code.. I see it creates 6 tables per subsite?

    Any chance you’ll be aggregating subsite data into 6 the wp_aiowps tables?
    Or into a 6-set for all subsites?

    With many subsites.. that’s a whole lotta additional tables ??

    Thread Starter Adam Nowak

    (@adam320)

    I am running the latest version of the plugin and still inundated with php errors:

    WordPress database error Table ‘senior85_wplive.sduwk_142_aiowps_login_lockdown’ doesn’t exist for query……..

    Can you please explain what happened and how I can get out out of this mess. Does the new version create these tables for each blog on the multisite, or is it supposed to remove the queries for each blog and just use one table for the whole network?

    Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi,
    Yes the latest version should create the tables for the individual subsites.
    Have you tried deactivating and reactivating the plugin? This will trigger the code which checks the DB tables and will create any missing tables.

    Thread Starter Adam Nowak

    (@adam320)

    Before I do this, I am worried about the individual sites. There are a couple hundred. Will de-activating and re-activating reset the: Enable Rename Login Page Feature?

    When we first took the network live, each individual site had to go to the brute force page and set the renamed login url. The last thing I want to do is break the network if this reverts to the default login. Any suggestions on that. I know the plugin was storing this data for site ID =1, but is it now creating tables for each site on the network? I just want to be sure I don’t loose all 200 sites renamed login page data.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi Adam, have you managed to solve your issue?

    Regards

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Multisite Fail’ is closed to new replies.