| Description | We are facing repeated mysql-errors upon caldav-synchronization Outlook-ClaDavSynchronizer to Sogo:
Apr 17 07:04:50 sogod [127121]: <0x0x555c500e3680[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x555c5013a420> NAME:ExecutionFailed REASON:Incorrect string value: '\xF0\x9F\xA4\xBAMa...' for column sogo.sogo_quick_appointment.c_title at row 1
Apr 17 07:04:50 sogod [127121]: [ERROR] <0x555c4fab1410[SOGoAppointmentObject]:de41621d-1caf-41ce-983c-4d7e878650c2.ics> write failed: <MySQL4Exception: 0x555c5013a420> NAME:ExecutionFailed REASON:Incorrect string value: '\xF0\x9F\xA4\xBAMa...' for column sogo.sogo_quick_appointment.c_title at row 1
I enabled debug and got detailed error:
2023-04-17 07:04:50.343 sogod[127121:127121] <MySQL4Channel[0x0x555c4f8ec220] connection=0x0x555c4f8ee090> SQL: INSERT INTO sogo_quick_appointment (c_iscycle, c_orgmail, c_uid, c_nextalarm, c_name, c_category, c_priority, c_cycleinfo, c_sequence, c_folder_id, c_isallday, c_title, c_cycleenddate, c_description, c_status, c_classification, c_startdate, c_participants, c_partmails, c_partstates, c_component, c_location, c_isopaque, c_enddate) VALUES (0, '', 'de41621d-1caf-41ce-983c-4d7e878650c2', 0, 'de41621d-1caf-41ce-983c-4d7e878650c2.ics', null, 5, null, 0, 14, 0, '�Martin Mazur � � { �️ Please Don’t Kill me �️ }', null, 'For full details, including the address, and to RSVP see: https://www.meetup.com/1337-Tech-Ljubljana/events/267714472
As we continue with a busy pace of knowledge events for 2020, we start the year by inviting the tret...', 1, 0, 1580403600, '', '', '', 'vevent', 'tretton37 d.o.o. - Slovenska cesta 28 - Ljubljana, si', 1, 1580410800);
2023-04-17 07:04:50.343 sogod[127121:127121] <MySQL4Channel[0x0x555c4f8ec220] connection=0x0x555c4f8ee090> ERROR: Incorrect string value: '\xF0\x9F\xA4\xBAMa...' for column sogo.sogo_quick_appointment.c_title at row 1
2023-04-17 07:04:50.343 sogod[127121:127121] <MySQL4Channel[0x0x555c4f9984f0] connection=0x0x555c4ffc6d90> SQL: ROLLBACK;
2023-04-17 07:04:50.343 sogod[127121:127121] <MySQL4Channel[0x0x555c4f9984f0] connection=0x0x555c4ffc6d90> query has no results.
2023-04-17 07:04:50.343 sogod[127121:127121] <MySQL4Channel[0x0x555c4f8ec220] connection=0x0x555c4f8ee090> SQL: ROLLBACK;
2023-04-17 07:04:50.343 sogod[127121:127121] <MySQL4Channel[0x0x555c4f8ec220] connection=0x0x555c4f8ee090> query has no results.
Our environment:
RHEL-8
10.3.35-MariaDB
sogo 5.8.2
Client: Microsoft Outlook 365 (installed CalDavSynchronizer latest version 4.4.1)
I don't know the right cause for this behaviour, but it seems it could be due to "STRANGE-CHARACTERS" in title of sogo_quick_appointment CalDavSynchronizer tries to write (I attached image so special characters are vissible from error log).
MartiaDB-server is configured (my.ini):
[mysqld]
port = 3306
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
show create table sogo_quick_appointment;
CREATE TABLE sogo_quick_appointment (
c_folder_id int(11) NOT NULL,
c_name varchar(255) NOT NULL,
c_uid varchar(255) NOT NULL,
c_startdate int(11) DEFAULT NULL,
c_enddate int(11) DEFAULT NULL,
c_cycleenddate int(11) DEFAULT NULL,
c_title varchar(1000) NOT NULL,
...
c_description text DEFAULT NULL,
PRIMARY KEY (c_folder_id,c_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 'sogo_quick_appo%';
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE |
| def | sogo | sogo_quick_appointment | c_title | 7 | NULL | NO | varchar | 1000 | 3000 | utf8 | utf8_general_ci | varchar(1000) |
I'm not database expert but perhaps tables shouldn't be created using utf8 but utf8mb4 (https://www.sogo.nu/support/faq/how-do-i-configure-sogo-to-use-mysql.html)?
Any help would be appreciated. |
|---|
