View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004719 | SOGo | Backend Calendar | public | 2019-03-29 22:48 | 2019-06-04 13:50 |
Reporter | Socs28 | Assigned To | |||
Priority | normal | Severity | tweak | Reproducibility | have not tried |
Status | new | Resolution | open | ||
Platform | Nethserver | OS | RHEL/CentOS | OS Version | 7 |
Product Version | 4.0.7 | ||||
Summary | 0004719: Certain Emoticons cause calendar events to not be accessbile | ||||
Description | When certain emoticons, such as a chicken, are put in an event on an android device, the event becomes unusable on the server. | ||||
Additional Information | I believe the applicable line in the log file is this: Mar 29 15:42:25 sogod [16026]: [ERROR] <0x55d2bcd9a4e0[SOGoAppointmentFolder]:3C1E-5C92AA80-1-3A0DA280> cyclic record doesn't have content -> {"c_category" = "<null>"; "c_classification" = 0; "c_component" = vevent; "c_content" = "BEGIN:VCALENDAR However I am not sure as other log lines are coming through as well. | ||||
Tags | No tags attached. | ||||
As an update, when these emojis are entered, everything after summary in the c_content filed of the event is deleted and the c_title field in the quick table is cleared as well. If this data is put back the event will come back and read properly, but with no emoji. Other events with emojis that apparently work, like a heart, show as random numbers of question marks in the database. |
|
See https://sogo.nu/files/docs/SOGoInstallationGuide.html#_mysql_complete_unicode_compliance |
|
I made the config changes, which now allows the events with odd emojis to not kill the event, but all emojis still show up as question marks in the database. I'm assuming that's because I didn't run this: mysql -hHOST -uUSER -p -D SOGO < Scripts/mysql-utf8mb4.sql I can't find the script, and I'm not sure if that would kill my database anyway. Thoughts? Help? |
|
I was able to use phpmyadmin to update the existing database to use utf8mb4, but it still is converting emoticons to question marks. Fortunately not killing the event though. |
|
This is a database encoding issue - your schema is still incorrect. |
|
Thank you, do you have an idea of how to fix it? |
|
You can find the script at: You should carefully read the header of it. It can not correct existing invalid characters. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2019-03-29 22:48 | Socs28 | New Issue | |
2019-04-12 17:50 | Socs28 | Note Added: 0013544 | |
2019-04-12 17:50 | Socs28 | Note Edited: 0013544 | |
2019-04-12 17:51 | Socs28 | Note Edited: 0013544 | |
2019-04-12 18:13 | francis | Note Added: 0013545 | |
2019-04-17 21:47 | Socs28 | Note Added: 0013550 | |
2019-04-18 21:54 | Socs28 | Note Added: 0013551 | |
2019-05-23 13:34 | ludovic | Note Added: 0013576 | |
2019-05-23 13:34 | ludovic | Severity | major => tweak |
2019-05-23 20:59 | Socs28 | Note Added: 0013578 | |
2019-06-04 13:50 | Christian Mack | Note Added: 0013607 |