Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
tips-topic
Which table in database for user accounts?
Avatar
Bart C.
New Jersey, USA
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:09 pm

We've been trying to troubleshoot a number of gremlins that have been present since switching over from vBulletin.  we have non-compliant usernames and I've read that I can change usernames in the wp-user table of our database using phpMyAdmin.  

The problem is, I can't find that table in our database.  There is a table titled users which has all of our user data but when I make changes there they are not propogating to our website data as viewable in the WordPress dashboard under User.

THanks,

Bart

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:16 pm

The database table that stores the required data for a user account is indeed the WP table 'users'. The other table that holds support user data for WordPress is 'usermeta' keyed on a key/data pairing system.

Is the data you are looking to change anything to do with Simple:Press? As that may be a different issue.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Bart C.
New Jersey, USA
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:32 pm

At the moment we're trying to confirm our ability to change usernames through database edits but so far we're not seeing the changes propagating to the website.  the database has definitely changed but the user data in the WP Dashboard Users area isn't showing the changes.

Regarding SimplePress, I tried to help a user by registering him with a rules-compliant name that was similar to his original name and then deleted the original account.  When deleting the account I tried to credit his posts to the new account but it didn't take and his old posts show the original name with the user-title "Guest".

Help with either issue would be appreciated.

Bart

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:42 pm

On the second issue that is the best we could do with that version because up until late in WP 4.0 WordPress had no hook into the user deletion process - an oversight we raised with them and campaigned to get. It came too late in the 4.0 dev cycle for us but we have now managed to improve things in the next SP release.

On the first issue while I know that the login name can be edited directly in the database table it is not really recommended or supported. However I have done it myself several times and it has always worked just fine. I assume you ARE referring to the Login name.

Are you sure you have no caching going on on your site...?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Bart C.
New Jersey, USA
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:44 pm

actually just found the table wp-users which i wasn't able to find before. 

how soon before we will be able to credit deleted accounts' posts to new accounts?  I have a lot of bad user accounts to repair and re-credit to the new accounts.

Avatar
Bart C.
New Jersey, USA
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:51 pm

making changes with the wp-users table and everything is working as it should except for the posts that are now marked as guest with the user's old username.

it would be a big help to get that crediting function back for deleting old users

thanks for the help YS.

bart

Avatar
Bart C.
New Jersey, USA
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2014 - 3:54 pm

is the table User the user records for SimplePress and the WP-Users is the WP user records?  I'm trying to understand the presence of both in the database.

also, how often do the two tables synchronize?  it appears that the User table is two weeks behind the WP-Users table.

Thanks,

Bart

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 16, 2014 - 4:27 pm

The deletion of users improvements will be in the next release. Hopefully - if all goes to plan - around the end of this month.

The WordPress account table is called 'users'. There is an SP table named 'sfmembers' that lonks to it by user_id - row for row by user.

Neither WP or SP creates a table simply called 'user'.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Bart C.
New Jersey, USA
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2014 - 4:53 pm

interesting because I've found the wp-users table and by changing the username field for a test user i was able to change the user's display when using the main WP dashboard.

In your first reply you said, "The database table that stores the required data for a user account is indeed the WP table ‘users’" and in that table I've found data for our forums users but i suppose that table could have been used for the transition to Simple-Press by our migration vendor.

I'll look in the other table you mentioned, "sfmembers" and get back to you.

Thanks,

Bart

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 16, 2014 - 6:37 pm

I have to be honest and say I have no idea what you are really talking about here. I will just repeat it... the WP table that stores account data is called 'users' - prefixed, of course, with whatever prefix you have set up in your wp-config.php file.

To complete this information - the column that contains the user name is called 'user_login'.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 647
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17344
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79598