Hi there.
When previewing a message, special characters appears like this:
(https://i.imgur.com/9eoUozz.png)
But when posting, everything is ok. I believe this happened after the recent PHP update in my server.
What can I do to correct this?
sorry for small delay, but are you using UTF-8?
Thanks for replying, Deaks.
Yes, I am. I never experienced this in years using SMF and when posting everything is ok. This only happens when previewing.
Youmentioned you think its the php version, what version are you running?
Also go to your admin panel and convert all to utf-8 again this is long shot but may fix it :D
My server's PHP version is 7.3.6.
I did as you suggested, but the problem persists. :-\
I've noticed that 1/3 of my database has utf8_general_ci collation and 2/3 has latin1_swedish_ci collation. I think this has nothing to do with it, because nothing changed there in the last months, but could something have changed in the last SMF update because of this?
Other than the small detail of you having UTF-8-presented-as-Latin1, you mean. Not relevant except for the fact it looks suspiciously relevant.
How did you arrive at '1/3 of my database', by looking at the table default which is a default and overridden entirely by SMF given any chance whatsoever?
What's the value of $db_character_set in Settings.php? What language are you using on the site yourself to make that preview?
I arrived at 1/3 just by looking at database column collation, but I really can't tell what's relevant from what's not, Arantor.
I'm running the forum as it is for years and this problem just appeared in the last few weeks, after updating to 2.0.17, which coincided with the PHP version update.
The value of
$db_character_set is
utf8.
I'm using Portuguese_pt-utf8 language to make the preview. My forum has portuguese_pt-utf8 and english "installed".
Quote from: Arantor on July 06, 2020, 05:14:17 PM
Other than the small detail of you having UTF-8-presented-as-Latin1, you mean. Not relevant except for the fact it looks suspiciously relevant.
How did you arrive at '1/3 of my database', by looking at the table default which is a default and overridden entirely by SMF given any chance whatsoever?
What's the value of $db_character_set in Settings.php? What language are you using on the site yourself to make that preview?
Anyone? :-\
Is this happening in the previous posts only, or in the new posts too?
It happens in old and new topics/messages.
By the way, this doesn't happen when previewing private messages.
Might be related to a JS bug that was recently introduced. Try changing the code found in https://www.simplemachines.org/community/index.php?topic=571082.msg4042818#msg4042818
Hmmm, now that I remember, I did those edits on script.js, like shawnb61 suggests. It did solve the issue mentioned in that topic, but could it be that it produced this one I brought up here?
Thanks to live627, I rechecked the changes in the topic mentioned and realized I only had done the first change.
Now that I also did the second change, everything went back to normal.
Sorry about that and thank you all for your help.