View Issue Details

IDProjectCategoryView StatusLast Update
0004400SOGoActiveSyncpublic2018-03-22 20:14
Reporterszidelek Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionsuspended 
PlatformGmail exchange syncOSAndroidOS Versionany
Product Version3.2.10 
Fixed in Version4.0.1 
Summary0004400: SOGo web breaks on emoji in calendar event
Description

SOGo web breaks on calendar event which contains an emoji in description.
The event is created via activesync client. It cannot be accepted in mail view, neither can view or delete in calendar view.

Steps To Reproduce

Create an event via activesync client (ex. GMail applicaion on Android phone), and write an emoji into the description text.
Log in into the Web interface, and check in the calendar view, "Request Failed" message appears only.

Additional Information

In the database the c_context field is truncated before the emoji.

TagsNo tags attached.

Activities

ludovic

ludovic

2018-03-14 15:52

administrator   ~0012696

Wrong ticket.

Christian Mack

Christian Mack

2018-03-16 08:59

developer   ~0012716

Do you use MySQL or Postgresql?

szidelek

szidelek

2018-03-16 09:02

reporter   ~0012717

We use mysql (mariadb).

Christian Mack

Christian Mack

2018-03-16 09:13

developer   ~0012718

Do you use utf8mb4 as character set in mariadb?
Emoji will only work with utf8mb4.

Read chapter "5.9.1. MySQL complete Unicode compliance" in https://sogo.nu/files/docs/v3/SOGoInstallationGuide.html

ludovic

ludovic

2018-03-22 20:14

administrator   ~0012797

Likely a configuration issue, reopen if necessary.

Issue History

Date Modified Username Field Change
2018-02-12 09:31 szidelek New Issue
2018-03-14 15:49 ludovic Status new => resolved
2018-03-14 15:49 ludovic Fixed in Version => 4.0.1
2018-03-14 15:49 ludovic Resolution open => fixed
2018-03-14 15:49 ludovic Assigned To => ludovic
2018-03-14 15:52 ludovic Note Added: 0012696
2018-03-14 15:52 ludovic Status resolved => feedback
2018-03-14 15:52 ludovic Resolution fixed => reopened
2018-03-16 08:59 Christian Mack Note Added: 0012716
2018-03-16 09:02 szidelek Note Added: 0012717
2018-03-16 09:02 szidelek Status feedback => assigned
2018-03-16 09:13 Christian Mack Note Added: 0012718
2018-03-22 20:14 ludovic Note Added: 0012797
2018-03-22 20:14 ludovic Status assigned => closed
2018-03-22 20:14 ludovic Resolution reopened => suspended