WordPress.org

Ready to get started?Download WordPress

Forums

User Role Editor
[resolved] Multisite setup gives "usermeta" table error (6 posts)

  1. Harpinder
    Member
    Posted 2 years ago #

    Hi,

    Indeed a great plugin!

    but when i use this in Multi site environment, and when i activate individually for each site, it give me following error:

    WordPress database error Table 'DB_NAME.wp_2_usermeta' doesn't exist for query SELECT count(*)
    FROM wp_4_usermeta
    WHERE user_id=1 AND meta_key='wp_4_capabilities' AND meta_value like '%administrator%' made by require_once, do_action, call_user_func_array, ure_init, ure_is_admin, ure_has_administrator_role

    Is this plugin does support multi site ? Also, i created a user in SITE 1, and i can able to login from SITE 2 login screen also (though it redirects me to SITE 1 URL!)

    Am i doing some wrong step? Any help on this would be appreciated.

    Many Thanks,
    Harpinder

  2. Vladimir Garagulya
    Member
    Plugin Author

    Posted 2 years ago #

    Hi,

    It should work in multi-site environment, except of case you found a real bug. If such I will fix it.
    It's very strange error message about 'wp_2_usermeta' doesn't exists, but SQL query contains 'wp_4_usermeta' only.
    I didn't tested per site activation. As plugin is available for the super-admin only it is no sense activate it site by site. Please try to activate it for the whole network at once using 'Network Activate' link from the Network admin Plugins link and let me know if error still exists.

    Login question is not related to the User Role Editor plugin. It is a common feature for WordPress. User is created not in site N, but in the network and added to the selected site then. So you can login and see your profile in any case, even you are not added to any site.

  3. Harpinder
    Member
    Posted 2 years ago #

    Hello ,

    Thanks for your response.

    I understand that on Multi Site environment, it makes no sense to activate a plugin per site. I have done Network Activate first, it has givne me error then. Then i activated per site, it has give the above error. Now, i have done Network Activate once again and now it is giving me following erorr many time:

    WordPress database error Table 'DB_NAME.wp_2_usermeta' doesn't exist for query SELECT count(*)
    FROM wp_2_usermeta
    WHERE user_id=1 AND meta_key='wp_2_capabilities' AND meta_value like '%administrator%' made by require_once, do_action, call_user_func_array, ure_init, ure_is_admin, ure_has_administrator_role

    So, basically it is throwing error in both cases for me: Per site and Network Activate.

    Please let me know if you need more info.

    Thanks,
    Harpinder

  4. Vladimir Garagulya
    Member
    Plugin Author

    Posted 2 years ago #

    Hello,

    It seems you found the bug and I should use more universal code in this place. Please try this updated version of URE plugin
    http://www.shinephp.com/wp-content/downloads/wordpress/plugins/user-role-editor-3.2.1.zip
    and let me know if bug is gone or not.

    Regards,
    Vladimir.

  5. Harpinder
    Member
    Posted 2 years ago #

    Hi Vladimir,

    Issues seems to be fix now... I have tested this plugin for both Network & Site wide ... working fine for me.. no php errors.

    Thanks for correcting the issue.

    Harpinder

  6. Vladimir Garagulya
    Member
    Plugin Author

    Posted 2 years ago #

    Hi Harpinder,

    Thanks to you. I could isolate and fix this issue with your help only.
    Thus it's resolved, I will publish 3.2.1 update.

    Regards,
    Vladimir.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic