plugin cannot find multisite table

  • Resolved jlooooo

    (@jlooooo)


    9 years, 11 months ago

    Hi,

    We are running this plugin in a multisite install of wordpress. How does the plugin work with database tables in multisite?

    I have this error:

    WordPress database error Table 'our_db_name.wp_3_aiowps_failed_logins' doesn't exist for query INSERT INTO wp_3_aiowps_failed_logins (user_id, user_login, failed_login_date, login_attempt_ip) VALUES ('123', 'user_x', now(), '123.12.123.*') made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, AIOWPSecurity_User_Login->aiowp_auth_login, AIOWPSecurity_User_Login->increment_failed_logins

    When a user uses a wrong password on site with id 3.

    This table: wp_3_aiowps_failed_logins doesn’t exist. Should this table be there? Or should all data be stored in wp_aiowps_failed_logins?

    We use some wordpress login filters, which we like to debug, but it would be convenient to know what the result should be.

    Thanks.

    https://www.ads-software.com/plugins/all-in-one-wp-security-and-firewall/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter jlooooo

    (@jlooooo)

    Ok. I did some more debugging.

    On activation the plugin should create tables for each site in wp-security.installer.php. However, when I do an error_write on some variable I see the database name is the same for both sites.

    On activation of plugin.
    write_log($blog_id); in security.installer.php on line 8 gives:
    [27-Mar-2015 15:24:32 UTC] 1
    [27-Mar-2015 15:24:32 UTC] 3

    write_log($wpdb->prefix); in security.installer.php on line 36 gives:
    [27-Mar-2015 15:24:32 UTC] wp_
    [27-Mar-2015 15:24:32 UTC] wp_3_

    write_log($lockdown_tbl_name); in security.installer.php on line 41 gives:
    [27-Mar-2015 15:24:32 UTC] wp_aiowps_login_lockdown
    [27-Mar-2015 15:24:32 UTC] wp_aiowps_login_lockdown

    Hence, it creates database tables with the same name for the different sites. I guess the constants for the table names are not ‘updated’ after switching blogs.

    Any idea what is going wrong here?

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi jlooooo did you also install the plugin in all the other sub sites?

    Thread Starter jlooooo

    (@jlooooo)

    The plugin is network activated yes.

    Thus plugin is good. Multi-site operation is not good.
    I suppose the logic is if someone is taking care of multisite installation that one needs no special instructions?

    But, I would like to disagree. This plugin needs multisite operating mode explanations. And few details to be added for operating on multi site.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    @dbj thank you for your comment and suggestion. The plugin developers are always implementing more features and information for a Multisite installation.

    Regards

    Plugin Contributor mbrsolution

    (@mbrsolution)

    @jloooo are you still having issues with your Multi-site installations?

    Plugin Contributor mbrsolution

    (@mbrsolution)

    I am marking this thread as resolved. No replies in 11 months.

    Thank you

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘plugin cannot find multisite table’ is closed to new replies.