*sigh* yup - that was it. For some reason, PHPMyAdmin was double escaping the newline characters and throwing everything off. Thanks for your input, Mike.
Apologies, I lied... i forgot i made the dump using PHPMyAdmin... I started out with mysqldump, but I needed to exclude some tables, so I used PHPMyAdmin... so perhaps that is the root cause. I'll report back.
Yes, those are the tools I used and they are the ones causing the issue. The other difference is that the production DB is MariaDB 10.1 and the test system is on MySQL 5.7. There is nothing anywhere about the dump/import having this kind of problem between these two (since they are supposed to...
Thanks, Mike - I have the site behind a password control so it's not accessible at the moment.
I've done more digging and it seems to be the data is already screwed up in the xf_template table. If I look at the template in DB in the live site, the newlines are displayed normally. I dump the...
Hey everyone,
I've recently moved a production site into a test environment to do some enhancements. As part of that move, I changed the boardURL and tried rebuilding the add-on caches. However, after the rebuild completes, the screen is littered with '\n' newlines (See screenshot). I also...