Wordpress Themes - WP Forum at BFA
Click here to register or to donate.
Auto self-registration is not available here - far too many spammers. This forum has many, many backlinks and because of that there is an intense desire among spammers to drop their links here.

Wordpress Themes - WP Forum at BFA » Running WordPress » Installing & running WordPress »

user roles messed up


  #1  
Old Jul 20, 2009, 11:34 AM
thegooser123
 
2 posts · Jul 2009
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.
  #2  
Old Jul 21, 2009, 04:44 AM
juggledad's Avatar
juggledad
 
23,655 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
how new is your site? If it is very new, you might be best just reinstalling Wordpress.
What vrsion of WP?
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #3  
Old Jul 21, 2009, 11:21 AM
thegooser123
 
2 posts · Jul 2009
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?
  #4  
Old Jul 21, 2009, 04:03 PM
juggledad's Avatar
juggledad
 
23,655 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
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.
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do people sign up as a user for a comment? nasu Page & Category Menu Bars 6 Jul 12, 2013 12:40 PM
Improvements suggested by new user MrBean New Versions, & Updating 2 Jun 21, 2009 12:25 AM
User Community designer666 Plugins & Atahualpa 2 May 15, 2009 05:52 AM
User Registration link vincotek Atahualpa 3 Wordpress theme 8 May 6, 2009 03:50 PM
User Photo johnnewton Atahualpa 3 Wordpress theme 3 Mar 15, 2009 02:43 PM


All times are GMT -6. The time now is 10:58 PM.


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