Nica
Member
Posts: 6
Registered: 2-4-2011
Member Is Offline
|
|
[Resolved] Copy Pasting Special Chars Blanks Post
Full Board URL: http://www.cerulean-sins.com
XMB Version: 1.9.11
Hey,
So I abhor that I can not figure this out myself, even if I do have some thoughts.
Basically the issue that the users are having is that as this is a role play forums, users type up large amounts of text in their desired text editors
(word, notepad, etc) and then copy paste it into the textbox to post their new thread/reply. This includes a variety of bbcodes and text (html is
turned off). Recently, I switched over from a shared hosting server onto my own cloud, and so the forum/site/content also moved to this new server. At
this point, users discovered that when they copy paste, and then hit "reply" or "post" or "preview", their posts come up absolutely BLANK.
I have tested a little and noticed that if I write a single sentence and copy paste that, I usually have no issues, but the moment I have a carriage
return/paragraph, the whole thing blanks out again. Others have said that other characters, like quotes, do the same thing. So I will assume that it
is any special character that breaks it - which is simply unacceptable. However, I was not having this issue prior to the move.
This makes me think it is a server variable, or perhaps in the database - but what?! I thought all my server settings were identical though of course
one might have been missed, and I'm a at a complete loss. Any thoughts?
Veronica
|
|
lottos
Administrator
Posts: 477
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
If you have access to the old database, I would first compare the 'character set' between the old and new database.
|
|
Nica
Member
Posts: 6
Registered: 2-4-2011
Member Is Offline
|
|
The database is one and the same. It was transferred over to the new server. What is the default character set - if anyone could confirm for me, then
I could at least check that?
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
For all tables, I have this "latin1_swedish_ci".
|
|
Nica
Member
Posts: 6
Registered: 2-4-2011
Member Is Offline
|
|
Switched it to latin1_general_ci and it works like a charm now. Whether it broke other things, I don't know... haha, but at least this issue seems
resolved! Thanks! Glad it wasn't an actual bug.
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
If it was an XMB bug, it would have occurred not only on your forum
Glad it's fixed! I'll mark tis thread as Resolved.
|
|
Nica
Member
Posts: 6
Registered: 2-4-2011
Member Is Offline
|
|
Crap allmighty. Spoke too soon. Apparently same issues. Trying to copy paste documents from microsoft word (with dashes, special characters, etc) and
it still blanks out the post. I had only changed the general settings collation, but the tables were already latin1_swedish_ci as you said yours are.
However, still bugging out. Not sure how to test further.
(Turning on debug doesn't seem to show anything relevant at all.)
|
|
Nica
Member
Posts: 6
Registered: 2-4-2011
Member Is Offline
|
|
My host helped me investigate and was able to narrow down that it was "the version of PHP that cause the issue was: version 5.4.17".
In case anyone else has this issue.
Veronica
|
|
eman86
Member
Posts: 62
Registered: 6-4-2013
Member Is Offline
Mood: Excited
|
|
so XMB isn't PHP 5.4 compatible then? I have PHP 5.4 on my development server, I'll take a test drive on this and see
rest assured XMB 2 will be compatible
Next Gen of XMB in the workings...
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
|
|
Adalberto
Member
Posts: 13
Registered: 5-19-2013
Location: MyHome
Member Is Offline
|
|
Mmm.. I'm not sure, I have all mysql tables "latin1_swedish_ci" and charset is correctly.
If I go in Administration Panel -> Translations and edit for example:
Phrase Name: addtime
and this translations window have special characters, I see correctly with php 5.3 or lower. I see blank window with php 5.4 or higher
|
|