Support Forum

Hello,

I've had this problem since v. 4.2, just upgraded to 4.3.2 -

The sfmembers table in my DB is missing about half the display_names, they're just blank, with the rest of the information being ok.

Is there something I can do to fix this? I'm a decent PHP developer so I should be able to make a query for it, but I'd rather treat the cause and not the symptom. Any ideas why this happened?

Thanks alot!

Extremely late reply… Sorry about that.

This is a standard WP site, and the users have a display name in the wp_users table.

You might be right in that they never have visited the forum. The missing users dont show up under forum -> users -> member information at least.

Is this correct behaviour? It's annoying that you can't add a user to a usergroup just because that user has never visited the forum. I also find it odd that it results in a sfmembers row without the display_name

Thank you for your help and the great plugin

Oh and I (temporarily) fixed my issue with this query:

UPDATE `wp_sfmembers` SET `wp_sfmembers`.`display_name` = (SELECT
`user_login` FROM `wp_users` WHERE `wp_users`.`ID` = `wp_sfmembers`.`user_id`)
WHERE `wp_sfmembers`.`display_name` = ""