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…

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/plugins/add-multiple-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

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.

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

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…

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

Errors. And not one I have seen before. So maybe your multiple user plugin was calling the WP action but with incomplete data?
There should never be a user ‘0’ so they are safe to remove.