XF 2.2 Converting <br> to XF

pattycake2

Active member
Recently converted large (6 million posts, 170,000 members) vb to XF. Had some issues during the import that I ended up working through but one that I can't seemed to find a fix for, is converting posts that have <BR> in them. Is there some type of find/replace that I can use to fix these posts? I was thinking about going in to phpmyadmin and then do an sql to replace "<br>" , but I don't know what to replace it with.

Anyone have an issue like this and fixed it or, can anyone help me with the find/replace values?
 
but I don't know what to replace it with
Nothing.

SQL:
UPDATE xf_post SET message = REPLACE(message, '<br>', '');

You may also need to do conversation messages:
SQL:
UPDATE xf_conversation_message SET message = REPLACE(message, '<br>', '');

Take a backup first or check on a test installation to ensure it has the desired result.
 
Thank you for the reply but, I need to replace it with an equivalent "line feed"... ie, \n\r or something like that that Xenforo will put the line breaks in for each <br>
 
Top Bottom