XF 2.3 Custom user titles "0"

[PNE-Online]

I know this has been reported for 2.2 but following the upgrade to 2.3 there is no change.

Doesn't matter what user group they are in but many just have "0" under their user name.

Is there any way of resetting, without going through each indervidual member?

 

[Anatoliy]

+1

 

[Paul B]

Is there any way of resetting, without going through each indervidual member?

You will have to run a query.
Take a backup first.

UPDATE xf_user SET custom_title = REPLACE(custom_title, '0', '');

 

[Anatoliy]

You will have to run a query.
Take a backup first.

Thanks.
I'm afraid to run a query. )
Can I find in phpmyadmin ' 'where custome_title like 0, and replace 0 one by one manually? It's kinda the same. I'm asking because several years ago I ve been told by someone from XF team (maybe even you) to never ever change anything in db manually (not via XF interface)

 

[Paul B]

Yes, you can do that, but you're still making manual changes and it will take a lot longer if you have many of them.

SELECT * from xf_user WHERE custom_title = '0';

In general we don't recommend it but in this case, it's just a custom user title field so is safe to do.

 

[Anatoliy]

Thanks.