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

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.

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

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

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.

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

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

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'.

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

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'.