On a Tiki23 I create a first article in "en" then create a "he" translation (new article) with everything in hebrew but nothing in the body (using title and header field).
On save I have a WSoD.
If I refresh the page everything is here.
If I add a body (no hebrew in it, just an image) I got a Tiki system error:
System error. חזרה הודעת שגיאה זו: Incorrect string value: '\xD7' for column `bernardsfez_tiki23`.`tiki_objects`.`description` at row 1 The query was: update `tiki_objects` set `description`=?,`name`=?,`href`=? where `objectId`=? Values: להתאים את סביבת עבודה בדיוק איך שאתה אוהב tiki-read_article.php?articleId=66 226
The article is saved and visible (while something seems weird in the display)
I tried to check if they were invisible characters or some specific word or letter that cause the issue and I couldn't find.
If I take the same text and remove it form the Heading to paste it in the body, it is working as expected.
It couldn't be reproduced on the show instance so I checked my database setting.
In my (Virtualmin) configuration file (my.cnf) I added :
[client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4
MariaDB System Variables look good:
character_set_client utf8mb4 character_set_connection utf8mb4 character_set_database utf8mb4 character_set_filesystem binary character_set_results utf8mb4 character_set_server utf8mb4 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ check_constraint_checks ON collation_connection utf8mb4_general_ci collation_database utf8mb4_general_ci collation_server utf8mb4_general_ci
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |