XF 1.5 Newline everywhere

[Kalgon]

Recently we moved webservers and exported our SQL database so we could import it. Easy enough, right? Wrong. Somewhere along the line, instead of inserting breaks \n and \n\n were spammed amongst our database causing this to happen to all our CSS, templates, etc.

and

<div id="Captcha" data-source="{xen:link misc/captcha}">\n    <xen:if is="{$captchaQuestion.question}">\n        <div class="ddText"><label for="cq_{$captchaQuestion.hash}">{$captchaQuestion.question}</label></div>\n        <input type="text" name="captcha_question_answer" id="cq_{$captchaQuestion.hash}" value="" placeholder="{xen:phrase please_answer_the_question_above}" class="textCtrl OptOut" />\n    <xen:else />\n        {xen:phrase n_a}\n    </xen:if>\n    <input type="hidden" name="captcha_question_hash" value="{$captchaQuestion.hash}" />\n</div>

As you could imagine, we can't have that and we have a fairly large userbase so starting over isn't an option. Is there any simple way to remove all the \n and \n\n from the database without manually editing it all?

 

[Tylerss]

Cloudflare messed all of the interpretations, so still gotta try fixing it either by hand or a simpler way.

 

[Mike]

Honestly, if this happened from the move, it's a bad database dump. You need to redo that, preferably using mysqldump.

 

[Kalgon]

Honestly, if this happened from the move, it's a bad database dump. You need to redo that, preferably using mysqldump.

I figured that out but sadly that wasn't an option. I'm now going through every table manually in small chunks exploding the string at every \\n and it's working quite well on re-import.

This can be closed.