XF 1.1 Importing and signatures not parsing correctly


Well-known member
I am not sure but i ported everything from VB finally and some signatures are not parsing correct ..here are some examples. If anyone knows what to do or sql query to run to clean up let me know.



5K  24:10 1st AG...shod               5K  23:54 1st AG...BF

8K  40:01 1st AG

10K  47:35 2nd AG

10 mi  1:19: 49 1st AG

13.1  1:50:10 3rd AG

25K  2:09:14  4th AG  talking too much during the race...oh well.

26.2  3:58:05 BQ

Also this one


the link is not parsing as HTML link


Well-known member
yes they are html links. I thought at least that character would parse a space . Well the HTML link parsed in the post but not in the signature.


XenForo moderator
Staff member
If you want to remove or replace them, you can use a simple query:

UPDATE xf_user_profile SET signature = REPLACE(signature,'current_content','new_content');
Take a backup first.


Well-known member
One more thing on my conversion there are some issues in the posts. Can you tell me where to fix the posts special characters