Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
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
Offline
#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
Offline
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
Offline
Re: weird charset
Maybe this issue?
http://stackoverflow.com/questions/40911643/phpmyadmin-export-import-issue-with-line-breaks
Code is topiary
Offline
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
Offline
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
Offline
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
Offline
Pages: 1