XF 2.2 Issue after batch updating members / UserTitle / Custom Title Rogue Name Left in UserTitle

anons

Member
Hi is there a way via the database to fix the UserTitle / Custom Title updating every user to null "" as after running a mass batch update I am left with a rogue (F) in a lot of the users on the profile the field is called UserTitle but in the admin panel it is called custom Title, which i find a little confusing to why it has different names ? please see screen shots of issue

xen2.webp
xenforo3.webp
 
Anyone have a suggestion on how to fix the above please via database or some other way to update the user profile field back to a blank status on over 180,000 users?
 
Top Bottom