Wordpress Themes - WP Forum at BFA

Wordpress Themes - WP Forum at BFA (http://forum.bytesforall.com/index.php)
-   Installing & running WordPress (http://forum.bytesforall.com/forumdisplay.php?f=6)
-   -   user roles messed up (http://forum.bytesforall.com/showthread.php?t=2542)

thegooser123 Jul 20, 2009 11:34 AM

user roles messed up
I have managed to mess up my user roles and need to restore them to the original.

I believe this might be done in the wp_usermeta but I have no idea what to do.

Any help here would be awesome as I am really pulling my hair out with it.

juggledad Jul 21, 2009 04:44 AM

how new is your site? If it is very new, you might be best just reinstalling Wordpress.
What vrsion of WP?

thegooser123 Jul 21, 2009 11:21 AM

Hiya mate. My site isn't a new install and a fresh install would really be out of the question. I'm using the latest version of WP

Any ideas?

juggledad Jul 21, 2009 04:03 PM

how many users do you have? Could you delete them all except for admin and clean out all the rows in wp_usermeta table except thoes associated with the ADMIN user?

For each user there is one row in the wp_user table and each user has an ID with admin being number 1. In the wp_usermeta table there can be many rows for each user in the wp_user table. Each row has it's unique UMETA_ID and a field called USER_ID that matches the ID field in the wp_user table.

You can have one user with 5 rows in the wp_usermeta table, while another has 17 rows associated with it. It all depends on what has happened with that user.

All times are GMT -6. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.