A A A
Forum Scope


Match



Forum Options



Min search length: 3 characters / Max search length: 84 characters
Forum Login
Lost password?
tips-topic
Which table in database for user accounts?
Avatar
Bart C.
New Jersey, USA
85 Posts
(Offline)
1
Oct 16, 2014 - 3:09 pm
Print

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

16436 Posts
(Offline)
2
Oct 16, 2014 - 3:16 pm
Print

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
85 Posts
(Offline)
3
Oct 16, 2014 - 3:32 pm
Print

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

16436 Posts
(Offline)
4
Oct 16, 2014 - 3:42 pm
Print

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…?

sp_Check
This post answers the topic
andy-signature.png
YELLOW
SWORDFISH
Avatar
Bart C.
New Jersey, USA
85 Posts
(Offline)
5
Oct 16, 2014 - 3:44 pm
Print

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
85 Posts
(Offline)
6
Oct 16, 2014 - 3:51 pm
Print

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
85 Posts
(Offline)
7
Oct 16, 2014 - 3:54 pm
Print

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

16436 Posts
(Offline)
8
Oct 16, 2014 - 4:27 pm
Print

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
85 Posts
(Offline)
9
Oct 16, 2014 - 4:53 pm
Print

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

16436 Posts
(Offline)
10
Oct 16, 2014 - 6:37 pm
Print

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: America/New_York
All RSSShow Stats
Administrators: Blues Dancer, Simple Press, SP Community Support
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 630
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Newest Members:
David Hnát
Gary Lee
Glen Stewart
Rodney Pacis
kent black
Robert Meharg
test test
narek amprachamian
Forum Stats:
Groups: 7
Forums: 17
Topics: 10065
Posts: 79362

 

Member Stats:
Guest Posters: 607
Members: 16923
Moderators: 0
Admins: 3

Most Users Ever Online
499
Currently Online
Guest(s)
9
Currently Browsing this Page

1 Guest(s)