German Special Characters in Event SubTitle
Hey,
I have the exact same problem with german special characters (ä, ö, ü, ß), already mentioned in Ticket #100849 [ https://helpdesk.ashanjay.com/ticket/special-characters-and-line-breaks-only-in-subline-shown-wrong-also-on-the-backend/ ].
This problem only appears in Event SubTitle and is shown on front- and backend.
It is possible to "fix" this: If there is a special character in the Event SubTitle , I have to immediately publish the event, without saving it. When I first save, then publish, it will convert the special character into cryptic signs, the exact same as already mentioned in Ticket #100849. A fix is also possible in case 2: After saving and publishing, I have to rewrite the text in EventSubtitle and update it.
This also fixes the problem in the frontend.
Whatever I do, the Unicode-error will ALWAYS appear in backend and cant be fixed.
It also shows other strange behaviour, like doubling the cryptic-sign-string after refilling the SubTitle-Box with the same text, mentioned in case 2.
I guess it has something to do with the Unicode-Conversion, saved in the Database... something like saving the Event_SubTitle in utf8_english instead of utf8_german, but I don't find the specific entry as a table or tuple in another wp-table... absolutely nothing, and I checked the whole DB.
Can you tell me, how this plugin is saving the eventdata ? Where is the data stored ?
I installed the EventON-plugin, when it was at version 2.72. I updated it today to the newest version 2.85 - unfortunately no improvement is visible.
The page is built for a customer without any technical know-how. Therefore the plugin should be easy to use.
Hope you can help.
Thanks in advance and best regards,
Saman
-
-
Jan 16,2020 AT 12:33PM -
Posted 6 years ago
- #158598
Hello,
No issues on our test server:
Please check “Post draft updated. Preview post” as a sign that this event was saved as Draft.
Could you please try the instructions mentioned in this
to make sure your issue is indeed coming from eventon.
-
Jan 23,2020 AT 1:16AM -
Posted 6 years ago
- #159642
Hello guys,
I’ve just tested the whole thing on the hoster we’re using in our company (1&1 ionos) and saw something interesting: It works without problems..no evcal_subtitle – error and this is really strange. The customer’s hoster is strato.de. On both servers (ours and the customers) PHP 7.3 is running. The only difference is the MySQL-version (ours has 5.5; the customers has 5.6.42)
I checked the relevant tuple for the subtitle in the database (wp_postmeta -> evcal_subtitle) on both servers: and it looks equal… both tables have utf8mb4_unicode_ci – collation and on both tables the values in the subtitle-tuples are looking good.
Do you have any idea what the problem can be ?
-
Jan 23,2020 AT 4:50AM -
Posted 6 years ago
- #159703
Thank you for your messages, I am going to assign this ticket to Ashan and he will be able to take it from here and find you a solution. Please allow some time for him to get back to you, we greatly appreciate your patience and thank you for being a eventon customer! Also please disable any IP blocking on your site if there are any.
-
Jan 30,2020 AT 12:08PM -
Posted 6 years ago
- #160947
I think the mySQL version might be the issue, the way the data is saved into the database for special characters. We use wordpress update_post_meta() function to save the event data to database. And there is no escaping all done using wordpress end.
I can not replicate this issue on my end. And you are the first person to report us of this issue.
-
Jan 16,2020 AT 12:33PM -
Posted 6 years ago
- #158598
