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.

 

[Urfe]

In my case I have users with all sorts of different numbers beyond 0. It looks to be related to an old vBulletin import? Assume that at some point the Xenforo behavior for these imported users changed.

I ran this query, based on the contributions above, to fix:

UPDATE xf_user
SET custom_title = ''
WHERE custom_title REGEXP '(^|[^0-9])(0?[0-9]|1[0-9]|2[0-9]|30)([^0-9]|$)';