View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005630SOGoBackend Calendarpublic2022-10-20 14:532023-12-05 17:31
Reporterak Assigned Tosebastien  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionreopened 
PlatformMacbookOSmacOSOS Version12.6
Product Version5.7.1 
Summary0005630: Events are not saved if emoji were used in the event's name or description
Description

Events are not saved if emoji were used in the name or description: e.g. � �
The server returns 500 errors.

Tested with:

  • WebGUI
  • Mac OS X Calendar
  • Thunderbird Lighting

The appointment is saved in the local client and a new invitation will be send to all participants upon each synchronization with the server, which leads to a flood of emails if several people are invited.

A particularly large number of emails will be send in the following constellation:
An Exchange user invites several Sogo users to an appointment. All Sogo users import this appointment as an *.ics file. As described above, the appointment is only saved locally and a confirmation / cancellation is sent to the appointment creator by EVERY Sogo user within each synchronization. If the client synchronizes every 1 minute, the appointment owner will receive multiple emails every minute.

TagsNo tags attached.

Activities

ak

ak

2022-10-20 14:53

reporter  

Bildschirmfoto 2022-10-20 um 16.18.48.png (96,248 bytes)   
Bildschirmfoto 2022-10-20 um 16.18.48.png (96,248 bytes)   
Bildschirmfoto 2022-10-20 um 16.53.25.png (76,164 bytes)   
Bildschirmfoto 2022-10-20 um 16.53.25.png (76,164 bytes)   
ak

ak

2022-10-20 14:56

reporter   ~0016299

Bildschirmfoto 2022-10-20 um 16.55.41.png (34,247 bytes)   
Bildschirmfoto 2022-10-20 um 16.55.41.png (34,247 bytes)   
ak

ak

2022-11-01 11:36

reporter   ~0016331

Hello,

any status update on this one?

Cheers!
sebastien

sebastien

2022-11-01 17:58

administrator   ~0016333

Hi @ak we'll try to fix this for next release, no guarantee
ak

ak

2022-11-08 10:49

reporter   ~0016353

Hi,

here is the corresponding error log:

2022-11-07 13:01:49.943 sogod[3184412:3184412] <MySQL4Channel[0x0x55c995b08510] connection=0x0x55c99615b420> ERROR: Incorrect string value: '\xF0\x9F\x98\x8A\x0A\x0A...' for column
sogo.sogo_quick_appointment.c_description at row 1
2022-11-07 13:01:49.943 sogod[3184412:3184412] <MySQL4Channel[0x0x55c995c6edf0] connection=0x0x55c99593b910> SQL: ROLLBACK;
2022-11-07 13:01:49.943 sogod[3184412:3184412] <MySQL4Channel[0x0x55c995c6edf0] connection=0x0x55c99593b910> query has no results.
2022-11-07 13:01:49.943 sogod[3184412:3184412] <MySQL4Channel[0x0x55c995b08510] connection=0x0x55c99615b420> SQL: ROLLBACK;
2022-11-07 13:01:49.944 sogod[3184412:3184412] <MySQL4Channel[0x0x55c995b08510] connection=0x0x55c99615b420> query has no results.
Nov 07 13:01:49 sogod [3184412]: <0x0x55c995f4edc0[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception:
0x55c99624df20> NAME:ExecutionFailed REASON:Incorrect string value: '\xF0\x9F\x98\x8A\x0A\x0A...' for column sogo.sogo_quick_appointment.c_description at row 1
Nov 07 13:01:49 sogod [3184412]: [ERROR] <0x55c996142190[SOGoAppointmentObject]:261F8D56-E2DE-4983-B3B7-067CAA3391C7.ics> write failed: <MySQL4Exception: 0x55c99624df20> NAME:Executi
onFailed REASON:Incorrect string value: '\xF0\x9F\x98\x8A\x0A\x0A...' for column sogo.sogo_quick_appointment.c_description at row 1

Looking forward this issue to be fixed soon...
sebastien

sebastien

2022-11-10 10:34

administrator   ~0016376

Last edited: 2023-12-05 17:31

Hi @ak,

This is not related to SOGo but to your database.
If you are using MySQL / MariaDB, you need to change the charset of the table set in OCSStoreURL.

  • Set charset_set to utf8mb4
  • Set collation to utf8mb4_general_ci

SQL (where sogo_store is the name of your table) :

ALTER TABLE sogo_store CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_store MODIFY c_content MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

EDIT : use utf8mb4_general_ci instead of utf8mb4_bin

Sebastien
ak

ak

2022-11-15 09:58

reporter   ~0016389

Hi Sebastien,

This is not related to SOGo but to your database.
If you are using MySQL / MariaDB, you need to change the charset of the table set in OCSStoreURL.
Set charset_set to utf8mb4
Set collation to utf8mb4_bin

Before applying suggested changes to our system, we have tested this at demo.sogo.nu instance and we were able to partly reproduce the error:
The events were saved, however neither in OSX Calendar nor in WebInterface of demo.sogo.nu Site were emojis correctly displayed...
If you kindly reopen this ticket we'll upload the video recording of this scenario.

Cheers!
ak

ak

2022-11-15 10:23

reporter   ~0016390

Hi,

ist there any chance to increase the upload file size limit to at least 10MB?
ak

ak

2022-11-16 12:36

reporter   ~0016393

Hi Sebastien,

we've solved this. This ticket may be closed. Unfortunately we were not quite successful in finding utf8 related documentation for sogo.. Maybe uft8mb4 will be someday the standard setting without the need to readjust the DB configuration?

The solution was for us as follow:

change the charset and the collation of the sogo database, all tables and modifying all relevant records (important was also to use available utf8mb4 collation - utf8mb4_general_ci, not the suggested utf8mb4_bin ):

MariaDB [(none)]> use sogo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [sogo]> show tables;
+------------------------+
| Tables_in_sogo         |
+------------------------+
| sogo_acl               |
| sogo_alarms_folder     |
| sogo_cache_folder      |
| sogo_folder_info       |
| sogo_quick_appointment |
| sogo_quick_contact     |
| sogo_sessions_folder   |
| sogo_store             |
| sogo_user_profile      |
+------------------------+

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_store;
+----------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field          | Type         | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |
+----------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| c_folder_id    | int(11)      | NULL            | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_name         | varchar(255) | utf8_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_content      | mediumtext   | utf8_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_creationdate | int(11)      | NULL            | NO   |     | NULL    |       | select,insert,update,references |         |
| c_lastmodified | int(11)      | NULL            | NO   |     | NULL    |       | select,insert,update,references |         |
| c_version      | int(11)      | NULL            | NO   |     | NULL    |       | select,insert,update,references |         |
| c_deleted      | int(11)      | NULL            | YES  |     | NULL    |       | select,insert,update,references |         |
+----------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+

MariaDB [sogo]> SHOW CHARACTER SET LIKE 'utf%';
+---------+------------------+--------------------+--------+
| Charset | Description      | Default collation  | Maxlen |
+---------+------------------+--------------------+--------+
| utf8    | UTF-8 Unicode    | utf8_general_ci    |      3 |
| utf8mb4 | UTF-8 Unicode    | utf8mb4_general_ci |      4 |
| utf16   | UTF-16 Unicode   | utf16_general_ci   |      4 |
| utf16le | UTF-16LE Unicode | utf16le_general_ci |      4 |
| utf32   | UTF-32 Unicode   | utf32_general_ci   |      4 |
+---------+------------------+--------------------+--------+
5 rows in set (0.001 sec)

ALTER TABLE sogo_acl CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;              
ALTER TABLE sogo_alarms_folder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;    
ALTER TABLE sogo_cache_folder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;     
ALTER TABLE sogo_folder_info  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;     
ALTER TABLE sogo_quick_appointment CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;    
ALTER TABLE sogo_sessions_folder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;  
ALTER TABLE sogo_store CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;            
ALTER TABLE sogo_user_profile CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> show variables where Variable_name LIKE 'character\_set\_%' OR Variable_name Like 'collation%';
+--------------------------+--------------------+
| Variable_name            | Value              |
+--------------------------+--------------------+
| character_set_client     | utf8mb4            |
| character_set_connection | utf8mb4            |
| character_set_database   | utf8               |
| character_set_filesystem | binary             |
| character_set_results    | utf8mb4            |
| character_set_server     | utf8mb4            |
| character_set_system     | utf8               |
| collation_connection     | utf8mb4_unicode_ci |
| collation_database       | utf8_general_ci    |
| collation_server         | utf8mb4_unicode_ci |
+--------------------------+--------------------+
10 rows in set (0.003 sec)

MariaDB [sogo]> alter database sogo character set utf8mb4 COLLATE utf8mb4_general_ci;
Query OK, 1 row affected (0.001 sec)

MariaDB [sogo]> show variables where Variable_name LIKE 'character\_set\_%' OR Variable_name Like 'collation%';
+--------------------------+--------------------+
| Variable_name            | Value              |
+--------------------------+--------------------+
| 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               |
| collation_connection     | utf8mb4_unicode_ci |
| collation_database       | utf8mb4_general_ci |
| collation_server         | utf8mb4_unicode_ci |
+--------------------------+--------------------+
10 rows in set (0.002 sec)

MariaDB [sogo]> show tables;
+------------------------+
| Tables_in_sogo         |
+------------------------+
| sogo_acl               |
| sogo_alarms_folder     |
| sogo_cache_folder      |
| sogo_folder_info       |
| sogo_quick_appointment |
| sogo_quick_contact     |
| sogo_sessions_folder   |
| sogo_store             |
| sogo_user_profile      |
+------------------------+
9 rows in set (0.001 sec)

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_acl;
+-------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field       | Type         | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+-------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_folder_id | int(11)      | NULL               | NO   | MUL | NULL    |       | select,insert,update,references |         |
| c_object    | varchar(255) | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_uid       | varchar(255) | utf8mb4_general_ci | NO   | MUL | NULL    |       | select,insert,update,references |         |
| c_role      | varchar(80)  | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
+-------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
4 rows in set (0.002 sec)

ALTER TABLE sogo_acl MODIFY c_object varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_acl MODIFY c_uid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_acl MODIFY c_role varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_alarms_folder;
+-----------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field           | Type         | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+-----------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_path          | varchar(255) | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_name          | varchar(255) | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_uid           | varchar(255) | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_recurrence_id | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_alarm_number  | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_alarm_date    | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
+-----------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
6 rows in set (0.002 sec)

ALTER TABLE sogo_alarms_folder MODIFY c_path varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_alarms_folder MODIFY c_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_alarms_folder MODIFY c_uid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_cache_folder;
+----------------+---------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field          | Type                | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+----------------+---------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_uid          | varchar(255)        | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_path         | varchar(255)        | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_parent_path  | varchar(255)        | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_type         | tinyint(3) unsigned | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_creationdate | int(11)             | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_lastmodified | int(11)             | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_version      | int(11)             | NULL               | NO   |     | 0       |       | select,insert,update,references |         |
| c_deleted      | tinyint(4)          | NULL               | NO   |     | 0       |       | select,insert,update,references |         |
| c_content      | longtext            | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
+----------------+---------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
9 rows in set (0.004 sec)

ALTER TABLE sogo_cache_folder MODIFY c_uid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_cache_folder MODIFY c_path varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_cache_folder MODIFY c_parent_path varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_cache_folder MODIFY c_content varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_folder_info;
+------------------+---------------------+--------------------+------+-----+---------+----------------+---------------------------------+---------+
| Field            | Type                | Collation          | Null | Key | Default | Extra          | Privileges                      | Comment |
+------------------+---------------------+--------------------+------+-----+---------+----------------+---------------------------------+---------+
| c_folder_id      | bigint(20) unsigned | NULL               | NO   | UNI | NULL    | auto_increment | select,insert,update,references |         |
| c_path           | varchar(255)        | utf8mb4_general_ci | NO   | PRI | NULL    |                | select,insert,update,references |         |
| c_path1          | varchar(255)        | utf8mb4_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| c_path2          | varchar(255)        | utf8mb4_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| c_path3          | varchar(255)        | utf8mb4_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| c_path4          | varchar(255)        | utf8mb4_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| c_foldername     | varchar(255)        | utf8mb4_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| c_location       | varchar(2048)       | utf8mb4_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| c_quick_location | varchar(2048)       | utf8mb4_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| c_acl_location   | varchar(2048)       | utf8mb4_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| c_folder_type    | varchar(255)        | utf8mb4_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
+------------------+---------------------+--------------------+------+-----+---------+----------------+---------------------------------+---------+
11 rows in set (0.002 sec)

ALTER TABLE sogo_folder_info MODIFY c_path varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_path1 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_path2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_path3 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_path4 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_foldername varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_location varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_quick_location varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_acl_location varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_folder_info MODIFY c_folder_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_quick_appointment;
+------------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field            | Type         | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+------------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_folder_id      | int(11)      | NULL               | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_name           | varchar(255) | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_uid            | varchar(255) | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_startdate      | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_enddate        | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_cycleenddate   | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_title          | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_participants   | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_isallday       | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_iscycle        | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_cycleinfo      | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_classification | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_isopaque       | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_status         | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_priority       | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_location       | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_orgmail        | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_partmails      | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_partstates     | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_category       | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_sequence       | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_component      | varchar(10)  | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_nextalarm      | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
| c_description    | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
+------------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
24 rows in set (0.003 sec)

ALTER TABLE sogo_quick_appointment MODIFY c_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_uid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_title mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_participants mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_cycleinfo mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_location varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_orgmail varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_partmails mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_partstates mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_category varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_component varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_appointment MODIFY c_description mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_quick_contact;
+-------------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field             | Type         | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+-------------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_folder_id       | int(11)      | NULL               | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_name            | varchar(255) | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_givenname       | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_cn              | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_sn              | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_screenname      | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_l               | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_mail            | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_o               | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_ou              | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_telephonenumber | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_categories      | varchar(255) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_component       | varchar(10)  | utf8mb4_general_ci | NO   |     | NULL    |       | select,insert,update,references |         |
| c_hascertificate  | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
+-------------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
14 rows in set (0.004 sec)

ALTER TABLE sogo_quick_contact MODIFY c_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_givenname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_cn varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_sn varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_screenname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_l varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_mail mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_o varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_ou varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_telephonenumber varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_categories varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_quick_contact MODIFY c_component varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_sessions_folder;
+----------------+---------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field          | Type          | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+----------------+---------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_id           | varchar(255)  | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_value        | varchar(4096) | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_creationdate | int(11)       | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_lastseen     | int(11)       | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
+----------------+---------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
4 rows in set (0.002 sec)

ALTER TABLE sogo_sessions_folder MODIFY c_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_sessions_folder MODIFY c_value varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_store;
+----------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field          | Type         | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+----------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_folder_id    | int(11)      | NULL               | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_name         | varchar(255) | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_content      | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_creationdate | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_lastmodified | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_version      | int(11)      | NULL               | NO   |     | NULL    |       | select,insert,update,references |         |
| c_deleted      | int(11)      | NULL               | YES  |     | NULL    |       | select,insert,update,references |         |
+----------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
7 rows in set (0.005 sec)

ALTER TABLE sogo_store MODIFY c_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_store MODIFY c_content mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MariaDB [sogo]> SHOW FULL COLUMNS FROM sogo_user_profile;
+------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field      | Type         | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
+------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| c_uid      | varchar(255) | utf8mb4_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| c_defaults | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| c_settings | mediumtext   | utf8mb4_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
+------------+--------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
3 rows in set (0.002 sec)

ALTER TABLE sogo_user_profile MODIFY c_uid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_user_profile MODIFY c_defaults mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE sogo_user_profile MODIFY c_settings mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Cheers!

Issue History

Date Modified Username Field Change
2022-10-20 14:53 ak New Issue
2022-10-20 14:53 ak File Added: Bildschirmfoto 2022-10-20 um 16.18.48.png
2022-10-20 14:53 ak File Added: Bildschirmfoto 2022-10-20 um 16.53.25.png
2022-10-20 14:56 ak Note Added: 0016299
2022-10-20 14:56 ak File Added: Bildschirmfoto 2022-10-20 um 16.55.41.png
2022-11-01 11:36 ak Note Added: 0016331
2022-11-01 17:58 sebastien Note Added: 0016333
2022-11-08 10:49 ak Note Added: 0016353
2022-11-10 10:34 sebastien Note Added: 0016376
2022-11-10 10:34 sebastien Assigned To => sebastien
2022-11-10 10:34 sebastien Status new => feedback
2022-11-10 15:49 sebastien Status feedback => resolved
2022-11-10 15:49 sebastien Resolution open => no change required
2022-11-15 09:58 ak Status resolved => feedback
2022-11-15 09:58 ak Resolution no change required => reopened
2022-11-15 09:58 ak Note Added: 0016389
2022-11-15 10:23 ak Note Added: 0016390
2022-11-15 10:23 ak Status feedback => assigned
2022-11-16 12:36 ak Note Added: 0016393
2022-11-17 13:00 sebastien Status assigned => closed
2023-12-05 17:30 sebastien Note Edited: 0016376
2023-12-05 17:31 sebastien Note Edited: 0016376