Loading...
 
Skip to main content

Articles, WSoD when editing an article with Hebrew characters in the Heading field

  • Tracker item actions
Trackers
Items
Status
Open
Subject
Articles, WSoD when editing an article with Hebrew characters in the Heading field
Version
23.x
25.x
master
Category
  • Error
  • Regression
Feature
Article
i18n (Multilingual, l10n, Babelfish)
Resolution status
Confirmed
Submitted by
Bernard Sfez / Tiki Specialist
Lastmod by
Bernard Sfez / Tiki Specialist
Rating
(0)
Description

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:

Copy to clipboard
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 :

Copy to clipboard
[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4


MariaDB System Variables look good:

Copy to clipboard
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


Importance
5
Easy to solve?
5
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7885
Created
Thursday 21 October, 2021 05:50:35 UTC
by Bernard Sfez / Tiki Specialist
LastModif
Sunday 12 February, 2023 04:55:00 UTC


Show PHP error messages