Well, the command ran and set all the wp_capabilities to the subscribers but when I view the Role in the WP Admin Users area it says “None”. Any suggestions?
I will surely test this now and let you know… Thank you for that. More to come.
Well, I don’t see a replace function in phpmyadmin so here I am looking for the query. I have noticed that the roles that say “None” in the admin area have NO entry for wp_capabilities so I assume that I need to insert the a:1:{s:10:”subscriber”;s:1:”1″;} into it but damn if I know how to do it in one full sweep.
Yes but I can change the admin account back to
a:1:{s:13:”administrator”;s:1:”1″;}
I just need to change all the users to subscribers. I’m looking for a complete query for mysql that I can run because i have 2000 members and that’s a lot to change manually.
