XF 2.2 Converting <br> to XF

[pattycake2]

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?

 

[Brogan]

but I don't know what to replace it with

Nothing.

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

You may also need to do conversation messages:

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.

 

[pattycake2]

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>

 

[K a M a L]

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