Textpattern CMS

#1 2017-03-24 03:49:21

bici

Member

From: vancouver

Registered: 2004-02-24

Posts: 2,121

Website Mastodon

weird charset

so this is interesting. i moved my site from my localhost to my web host to test out the site. but the whole thing is borked:

r\n<txp:output_form form="adi_variables" />\r\n<txp:output_form form="meta_home" />\r\n<!-- /head in META -->\r\n<txp:output_form form="browser" />\r\n<!-

and

div data-caption-animate="fadeInUp" data-caption-delay="100">\r\n\r\n

i looked at my sql export file and i see this:

What do you want to do next?\\n\\n* Modify or delete this article? The \"article list\":/textpattern/index.php?event=list is the place to start.\\n* Change this site\'s name, or modify the style of the URLs? It\'s all up to your 

what is up i wonder?
\r\n\r\n

---

…. texted postive

#2 2017-03-24 15:17:29

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,315

Re: weird charset

\r\n\r\n are in their thousands in my SQL files, that’s a blank line. You’ll probably find these yourself searching with duplicated slashes \\r\\n\\r\\n. (Don’t ask me why it needs a “new line” directive plus a return.)

Just laying stepstones for smarter people to contradict me:
I wonder whether the output is just the visible remainder, the result of code that’s not been copied over, hence has not been applied (see the lacking slash at the beginning of your first line of code here above).

Edit: Have you exported the data base as an SQL file or copied text from a textarea and missed, say, line 1?

Last edited by uli (2017-03-24 15:26:07)

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2017-03-24 16:21:47

bici

Member

From: vancouver

Registered: 2004-02-24

Posts: 2,121

Website Mastodon

Re: weird charset

I simply exported the DB using phpMyAdmin. have done this many times and this is the firs ttime this has happened.
When i imported the DB sql file this is the result

---

…. texted postive

#4 2017-03-24 21:19:06

jsoo

Plugin Author

From: NC, USA

Registered: 2004-11-15

Posts: 1,793

Website

Re: weird charset

Maybe this issue?

http://stackoverflow.com/questions/40911643/phpmyadmin-export-import-issue-with-line-breaks

---

Code is topiary

#5 2017-03-25 03:38:31

bici

Member

From: vancouver

Registered: 2004-02-24

Posts: 2,121

Website Mastodon

Re: weird charset

thanks jsoo. that link makes sense : windows use “\r\n” and *unix use “\n”

but when copying and pasting I would of thought that those issues would be moot. so even though i was copying from flat html files that didnt seem to have any special characters those somehow got copied over.
I have been copying text from LOCALHOST and pasting into the active domain and those charset issues disappears. which is interesting.

---

…. texted postive

#6 2017-03-25 10:23:00

jsoo

Plugin Author

From: NC, USA

Registered: 2004-11-15

Posts: 1,793

Website

Re: weird charset

Right, the bug is not the Windows line endings, it’s that the backslashes are being escaped on export in the buggy version of phpmyadmin. So, it looks like this is fixed if you can upgrade phpmyadmin.

---

Code is topiary

#7 2017-03-25 17:24:03

bici

Member

From: vancouver

Registered: 2004-02-24

Posts: 2,121

Website Mastodon

Re: weird charset

hmm. intersting that this has never arisen with other DBs . I have been using MAMP Pro on LOCALHOST from APPsolute and Webfaction for web hosting for sometime now. MAMP Pro is using phpMyAdmin Version: 4.6.5.1 and at Webfaction it is Version : 4.4.15.7

I just checked and the other DBs exported from LOCALHOST don’t have any signs of the dreaded windows line ending issues. will keep checking.
Thanks for your feedback.

---

…. texted postive