Missing user roles on mutlisite

  • Resolved Tom Belknap

    (@dragonflyeye)


    10 years, 2 months ago

    Wow, people. This is a lot. It’s been a heck of a day…

    I’ve been using WordPress forever and was a WPMU user prior to the merge… which was a long time ago. But my primary blog never reverted to the wp_table format instead of the wp_1_table format. Having noticed a problem with the multisite functionality – which has been sitting dormant for quite a while – I ended up completely screwing everything up.

    The solution after much consternation was to just manually rename all my main blog tables. That worked, hurray!! But then my limited blogging account (as distinct from my super admin account) couldn’t log in anywhere.

    That’s because it had no role on any blog, nor did any other user. And just like many, many other posts here, I was missing the list of user roles that would have allowed me to correct the problem.

    After reading a few posts, I figured out that it must be iThemes Security that’s the issue, so i turned that plugin on, hoping that it would restore the roles. And hurray!! looking at the user tables, everything looked back to normal.

    But alas, I still couldn’t login and I still don’t have my list of roles.

    I’m not sure what to do next. I have not seen iThemes Security specifically mentioned as a reason for this problem, and other issues seem to have concerned Capabilities Manager, which creates a table of capabilities. Any idea what I can do, besides deleting my account and rebuilding, that would help?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Tom Belknap

    (@dragonflyeye)

    UPDATE: comparing to another multisite installation that I own, I noticed that there is a user meta value called wp_capabilities, which of course in my installation, is called wp_1_capabilities. I switched that meta key to the correct parlance and… no luck.

    I’m assuming there must be a place in the database where the capabilities live, but I’m not seeing it?

    Thread Starter Tom Belknap

    (@dragonflyeye)

    UPDATE OF AN UPDATE:

    After digging up this article, I discovered the problem.

    Just as with the above noted user meta table problem, there are values in the wp_options table that also refer to “wp_1,” including the wp_1_user_roles option, which lists out all capabilities on the site. Change that back to the correct wp_ format – that is: rename the option_name from “wp_1_user_roles” to “wp_user_roles” – and all is well. S’pose I’ll have to do the same with all the other values, too.

    Hope anyone else searching finds this post helpful.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Out of curiosity, in your wp-config.php do you have BOTH defines for WP Multisite activation?

    Thread Starter Tom Belknap

    (@dragonflyeye)

    Meaning WP_ALLOW_MULTISITE and MULTISITE. Yes, sir.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Missing user roles on mutlisite’ is closed to new replies.