Skip to:
Content
Pages
Categories
Search
Top
Bottom

WP 3.9 php errors when no admin in sub network on multisite network …


  • chuckingit
    Participant

    @chuckingit

    Hi – i’m not certain if this is a BuddyPress issue and/or related to other WP Multisite networks within networks issue and/or issue with WP Multi Network plugin and/or should be reported in https://buddypress.trac.wordpress.org/newticket and/or ..??.. but here i go …

    after i upgraded my WP Multisite Network to WP 3.9 i started seeing daily php fatal log errors (see below example) …

    my site is a Multisite Network with one sub network via the WP Multi Network plugin … thus only two networks … network a = mothership root network and network b = secondary sub network where BuddyPress was activated on this b network but not yet activated on the a network …

    the number 16 in error logs corresponds to sub site id on the b network where BuddyPress was activated …

    neither a or b network had an admin account and this seems to be the problem in that BuddyPress, at least in sub networks created, needs this admin account to be present …

    background fyi – i had installed my WP Multisite Network and created new Super User and deleted the admin account based on various security threads i read about hardening thus thought my new super user account was cool …

    turns out that when i created network b as my new super user admin renamed, the network was created but on that new network my super user status was delegated to subscriber status thus no admin options …

    my only work out was to create a new admin user via phpMyAdmin and insert new admin user but i digress …

    once i had a new admin user then the error messages seemed to stop …

    had read something about BuddyPress issue of “Stop user accounts logging in that have not been activated yet (user_status = 2).” at this url ->
    https://buddypress.trac.wordpress.org/attachment/ticket/4676/

    and suspect the admin account having never been activated being issue ..??..

    any pointers that can be shared are greatly appreciated … cordially, chuck scott

    ===========================
    Example of errors in logs
    ===========================

    
    [24-Apr-2014 04:55:00 UTC] WordPress database error Table 'mysite_wp01main.wp01_16_signups' doesn't exist for query SELECT * FROM wp01_16_signups WHERE active = 0 AND user_login = 'admin' ORDER BY signup_id DESC LIMIT 0, 1 made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, bp_core_signup_disable_inactive, BP_Signup::get
    [24-Apr-2014 09:25:20 UTC] WordPress database error Table 'mysite_wp01main.wp01_16_signups' doesn't exist for query SELECT * FROM wp01_16_signups WHERE active = 0 AND user_login = 'admin' ORDER BY signup_id DESC LIMIT 0, 1 made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, bp_core_signup_disable_inactive, BP_Signup::get
    [24-Apr-2014 15:32:19 UTC] WordPress database error Table 'mysite_wp01main.wp01_16_signups' doesn't exist for query SELECT * FROM wp01_16_signups WHERE active = 0 AND user_login = 'admin' ORDER BY signup_id DESC LIMIT 0, 1 made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, bp_core_signup_disable_inactive, BP_Signup::get
    

    – fin –

Viewing 4 replies - 1 through 4 (of 4 total)

  • r-a-y
    Keymaster

    @r-a-y

    There was a problem in the upgrader script when creating the wp_signups table in v2.0.

    This is probably addressed in ticket #5563:
    https://buddypress.trac.wordpress.org/ticket/5563

    If you are able to, please test latest trunk or apply the changesets in that ticket to your install.

    If not, wait for v2.0.1 to be released in the upcoming week.


    chuckingit
    Participant

    @chuckingit

    @r-a-y – Thank You … i’ll wait till next release as i’m a bit clueless as to how to test latest trunk … eg., when i download the *.patch file, not sure how to go about applying but very much appreciate your response to this thread … cheers – chuck scott


    chuckingit
    Participant

    @chuckingit

    Hi – i just wanted to loop back on this thread as i’m still having this problem even though i’m now at WP 3.9.1 and BuddyPress 2.0.1 … it seems as though somebody keeps trying to login to blog id #16 with usernames that are not in the user table (e.g., webmaster, root) hence the ongoing php fatal error logs … the odd thing is that this blog 16 is a site on a network within a network … thus not sure if maybe i setup this second network and site #16 running BuddyPress wrong, or if maybe there is other issue with BuddyPress thus share in case it is not me and my setup, but something that still can use some code love ..??..


    chuckingit
    Participant

    @chuckingit

    these errors are still happening and today i checked error log to find that a hacker (or bot) within 2 minutes launched 73 attempts to login with non existing username and created 26k error file … thus i’m concerned that this kind of login errors could crash my site by rogue attacks like this … below is clip from first entry and the last one …

    accordingly, anybody have any suggestions as to how i can prevent this from happening ..??.. i just installed the login lock down plugin on site 16 thus this should help to limit login attempts but still, BuddyPress seems like it is hiccupping in this dept by looking for non-existant users ..??..

    
    [05-Jun-2014 08:43:58 UTC] WordPress database error Table 'mysite_wp01main.wp01_16_signups' doesn't exist for query SELECT * FROM wp01_16_signups WHERE active = 0 AND user_login = 'islandbread' ORDER BY signup_id DESC LIMIT 0, 1 made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, bp_core_signup_disable_inactive, BP_Signup::get
    [05-Jun-2014 08:45:50 UTC] WordPress database error Table 'mysite_wp01main.wp01_16_signups' doesn't exist for query SELECT * FROM wp01_16_signups WHERE active = 0 AND user_login = 'islandbread' ORDER BY signup_id DESC LIMIT 0, 1 made by wp_signon, wp_authenticate, apply_filters('authenticate'), call_user_func_array, bp_core_signup_disable_inactive, BP_Signup::get
    
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WP 3.9 php errors when no admin in sub network on multisite network …’ is closed to new replies.
Skip to toolbar