Support Forum
Support Forum
Offline
Problem:
1. When I go to the Users page on Simplepress, the "Display Name" for nearly everybody is blank.
2. When I go to Manage User Groups, it says there are 332 users in group, but nearly everybody is blank.
3. In forum it says "logged in as" but no username is shown.
4. Under "First post" or "Last post" it shows no username.
Partial solution: Only of the user goes to /login/?action=profile and changes "Display name publicly as" does the username show up in Simplepress.
Question: How do I change all users to have a username which shows up in Simplepress?
Thank you very much
Jonathan
Offline
have a look in the db... is display_name column empty in wp users table? and what about the sfmembers table?
what settings do you have on forum - profiles - options in the display name format section???
how were the users created? by plugin? or membership thing? if something that creates the user is not using the wp api, we may not know about it...
Visit Cruise Talk Central and Mr Papa's World
Offline
Thank you for the quick response.
display_name in wp_users is fine (it is in username format - incidentally I'd prefer Firstname Lastname format).
display_name in sfmembers is blank (except in cases where users have edited profile themselves).
Users were created by Add Multiple Users plugin (http://wordpress.org/extend/pl.....ple-users/).
I assume I need to copy across the display_names from wp_users to sfmembers. Can you give me a foolproof sql query for that? Or is there some way of doing it via the simplepress admin pages?
Also, what other problem might have been caused by using Add Multiple Users?
Thanks again
Offline
I have not come across 'Add Multiple Users' before but as Steve said above it sounds like it does not, perhaps, use the WP API as it should. Having said that I have not come across circumstances where the forum display_name field would be empty. The whole episode is somewhat curious.
You should be able to update the required display name with the following SQL statement:
UPDATE wp_sfmembers SET display_name = (SELECT display_name FROM wp_users WHERE wp_users.ID = wp_sfmembers.user_id);
You will need to change the table prefix if yours is not the default 'wp_' of course.
 |
YELLOW
SWORDFISH
|
Offline
The SQL statement had the desired effect, thanks.
In future I'll be able to create users without needing to use the Add Multiple Users extension.
But in relation to existing users, I would like to check there weren't any other unintended consequences. What effect does it have on Simplepress whenever a new user is created in the 'normal' way?
Thanks
Jonathan
Offline
SP will create their entry in the sfmembers table. It will also place the new user in the default SP User Group (as set by your options) and create an entry in the sfmemberships table.
If you go to the Manage User Groups panel there is an option at the bottom to display any members not in a User Group...
|
YELLOW
SWORDFISH
|
Offline
Thank you. It seems to have created an entry in the sfmembers table and also in sfmemberships for each user. The only thing that doesn't seem to have happened is copying the display name from the users table to the sfmembers table. Clicking that button leads to the following: "All members have a usergroup membership."
Incidentally, is there any significance to two entries in sfmemberships where user_id is 0?
membership_id user_id usergroup_id
Edit Delete 294 0 2
Edit Delete 295 0 2
Edit Delete 296 295 2
Edit Delete 297 296 2
Edit Delete 298 297 2
Thanks
Jonathan
All RSS1 Guest(s)