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?
Veronicalottos - 8-4-2013 at 09:29 PM
If you have access to the old database, I would first compare the 'character set' between the old and new database.Nica - 8-4-2013 at 10:50 PM
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 - 8-5-2013 at 03:59 PM
For all tables, I have this "latin1_swedish_ci".Nica - 8-5-2013 at 05:33 PM
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 - 8-5-2013 at 06:32 PM
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 - 8-5-2013 at 09:50 PM
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 - 8-6-2013 at 01:56 AM
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.
Veronicaeman86 - 8-6-2013 at 12:18 PM
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 Mouser - 8-6-2013 at 04:48 PM
Of course XMB supports PHP 5.4
This was NO PHP issue.
This was a charset issue in the database the user created. As you could read above
Of course XMB supports PHP 5.4
This was NO PHP issue.
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