Not a bug vBulletin 4.x Importer doesn't parse HTML in Custom Titles correctly

[jeffwidman]

Importing a VB 4.2 board into XF 1.5 RC 1

Just noticed a bunch of custom titles were broken on import. Here's what I see:

Sitename Friend for Life <br /><img border=0 src="http:

It looks like there was a problem parsing HTML.

I only recently became the admin/owner of the site, and not familiar with how VB stores custom user titles in the database, so unfortunately I'm not sure if this is a problem with parsing VB, or parsing a custom title setup by the previous site owner.

These custom titles look like they weren't setup by the individual users, but instead apply to everyone belonging to specific user groups.

Let me know if you need any more info to reproduce.

I assume to fix it myself I just edit the custom user title column in `xf_user` table? Is this data denormalized to any other tables?

 

[Chris D]

XenForo only supports HTML in user titles which is added by admins to users in the Admin CP via the user group level.

Users adding one themselves will see something similar.

Imported ones will behave in the same way.

I think you can clear custom titles using Batch Update Users.

EDIT: I don't see a way to clear custom titles but you can modify them in batches in there. Generally clearing them from the database is trivial so that's an option.

 

[jeffwidman]

Cool, I fixed them via the mysql cli in about 10 mins, just wanted to make sure they only appeared in the one table.