Hi there,
I do not need help on that as I found the solution, but I want to inform you about this behaviour and help in case someone is facing the same issue.
I used the Defender’s “Change default database prefix”, and it worked well, but after a few days, I wanted to add a user to one of the multisite subsite, and found that there was no role drop down = I could choose Administator, Editor, etc. I also couldn’t change the role of a current user.
I searched and found something: a question on stack exchange (from 8 years ago!!) was describing my issue
https://wordpress.stackexchange.com/questions/11725/why-are-my-roles-not-visible-in-a-multi-site-network
And in one of the replies, I saw that:
– Determine your Multisite Blog ID. I will use 99 as an example
– Go into the database
– Go to this table: wp_##_options (wp_99_options) — you will have a table for each blog
– Find the record where option_name = wp_user_roles
– Change the text wp_user_roles to wp_##_user_roles (“wp_99_user_roles”:wink:
and indeed, for that subsite, the option_name was oldprefix_user_roles, instead of newprefix_user_roles
As soon as I changed that in the database, I found the normal role dropdown in the admin (add/edit a user).
I searched on other subsites in the database for the same stuff and found out that some but not all, had the same issue. And very strangely, one of the subsites had 2 rows in the database, one with oldprefix_user_roles and one with newprefix_user_roles, leading me to think that this was maybe an incomplete task from the Defender renaming tool, or maybe this field is recreated after some action?
Anyway, it’s solved on my site, but you might want to have a look at how Defender’s renaming tool is taking subsites’ user roles row into account.
Have a great day
(EDIT. PS: it’s always when you have a super busy evening that of your users is messaging “I can’t enter my website anymore” and that you are super efficient to quickly find the solution)
