View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004551 | SOGo | Backend Address Book | public | 2018-09-22 07:37 | 2018-09-27 10:41 |
| Reporter | nspeelman | Assigned To | francis | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | no change required | ||
| Platform | [Server] Linux | OS | Ubuntu | OS Version | 14.04 LTS |
| Product Version | 4.0.2 | ||||
| Summary | 0004551: Cannot add new contacts (no type found for column name c_hascertificate) | ||||
| Description | When I add a new contact through either the Web interface, or through the Exchange ActiveSync connection in Outlook, it fails with the error: "[ERROR] <0x0x7fa7f38b8fc8[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_hascertificate" And SOGo attempts the insert with 11 values for 12 entries. Background: I run MariaDB v10.1.35 on a seperate Debian server. SOGo runs on my mail server on Ubuntu 14.04 LTS with SOGo from the nightly repository. I have added an overview of my sogo database, my sogo.conf and sogo.log as attachments | ||||
| Steps To Reproduce |
| ||||
| Tags | No tags attached. | ||||
 |
sogo_database.txt (37,064 bytes)
MariaDB [sogo]> SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS where table_schema = 'sogo'; +---------------+--------------+-------------------------------+-------------------+--------------------+--------------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | CHARACTER_SET_NAME | COLLATION_NAME | +---------------+--------------+-------------------------------+-------------------+--------------------+--------------------+ | def | sogo | sogoAdminist00175302890 | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890 | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890 | c_creationdate | NULL | NULL | | def | sogo | sogoAdminist00175302890 | c_lastmodified | NULL | NULL | | def | sogo | sogoAdminist00175302890 | c_version | NULL | NULL | | def | sogo | sogoAdminist00175302890 | c_deleted | NULL | NULL | | def | sogo | sogoAdminist00175302890_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_givenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_cn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_sn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_screenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_l | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_mail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_o | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_ou | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_telephonenumber | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_categories | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist00175302890_quick | c_hascertificate | NULL | NULL | | def | sogo | sogoAdminist0023c71345b | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b | c_creationdate | NULL | NULL | | def | sogo | sogoAdminist0023c71345b | c_lastmodified | NULL | NULL | | def | sogo | sogoAdminist0023c71345b | c_version | NULL | NULL | | def | sogo | sogoAdminist0023c71345b | c_deleted | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_startdate | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_enddate | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_cycleenddate | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_title | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_participants | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_isallday | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_iscycle | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_cycleinfo | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_classification | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_isopaque | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_status | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_priority | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_location | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_orgmail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_partmails | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_partstates | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_category | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_sequence | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_nextalarm | NULL | NULL | | def | sogo | sogoAdminist0023c71345b_quick | c_description | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogoAdminist0023c71345b_quick | c_hascertificate | NULL | NULL | | def | sogo | sogo_acl | c_folder_id | NULL | NULL | | def | sogo | sogo_acl | c_object | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_acl | c_uid | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_acl | c_role | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_alarms_folder | c_path | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_alarms_folder | c_name | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_alarms_folder | c_uid | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_alarms_folder | c_recurrence_id | NULL | NULL | | def | sogo | sogo_alarms_folder | c_alarm_number | NULL | NULL | | def | sogo | sogo_alarms_folder | c_alarm_date | NULL | NULL | | def | sogo | sogo_cache_folder | c_uid | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_cache_folder | c_path | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_cache_folder | c_parent_path | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_cache_folder | c_type | NULL | NULL | | def | sogo | sogo_cache_folder | c_creationdate | NULL | NULL | | def | sogo | sogo_cache_folder | c_lastmodified | NULL | NULL | | def | sogo | sogo_cache_folder | c_version | NULL | NULL | | def | sogo | sogo_cache_folder | c_deleted | NULL | NULL | | def | sogo | sogo_cache_folder | c_content | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_cache_folder_jill | c_path | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_cache_folder_jill | c_parent_path | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_cache_folder_jill | c_type | NULL | NULL | | def | sogo | sogo_cache_folder_jill | c_creationdate | NULL | NULL | | def | sogo | sogo_cache_folder_jill | c_lastmodified | NULL | NULL | | def | sogo | sogo_cache_folder_jill | c_version | NULL | NULL | | def | sogo | sogo_cache_folder_jill | c_deleted | NULL | NULL | | def | sogo | sogo_cache_folder_jill | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_cache_folder_nico | c_path | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_cache_folder_nico | c_parent_path | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_cache_folder_nico | c_type | NULL | NULL | | def | sogo | sogo_cache_folder_nico | c_creationdate | NULL | NULL | | def | sogo | sogo_cache_folder_nico | c_lastmodified | NULL | NULL | | def | sogo | sogo_cache_folder_nico | c_version | NULL | NULL | | def | sogo | sogo_cache_folder_nico | c_deleted | NULL | NULL | | def | sogo | sogo_cache_folder_nico | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_folder_id | NULL | NULL | | def | sogo | sogo_folder_info | c_path | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_path1 | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_path2 | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_path3 | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_path4 | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_foldername | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_location | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_quick_location | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_acl_location | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_folder_info | c_folder_type | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_quick_appointment | c_folder_id | NULL | NULL | | def | sogo | sogo_quick_appointment | c_name | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_uid | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_startdate | NULL | NULL | | def | sogo | sogo_quick_appointment | c_enddate | NULL | NULL | | def | sogo | sogo_quick_appointment | c_cycleenddate | NULL | NULL | | def | sogo | sogo_quick_appointment | c_title | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_participants | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_isallday | NULL | NULL | | def | sogo | sogo_quick_appointment | c_iscycle | NULL | NULL | | def | sogo | sogo_quick_appointment | c_cycleinfo | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_classification | NULL | NULL | | def | sogo | sogo_quick_appointment | c_isopaque | NULL | NULL | | def | sogo | sogo_quick_appointment | c_status | NULL | NULL | | def | sogo | sogo_quick_appointment | c_priority | NULL | NULL | | def | sogo | sogo_quick_appointment | c_location | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_orgmail | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_partmails | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_partstates | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_category | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_sequence | NULL | NULL | | def | sogo | sogo_quick_appointment | c_component | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_appointment | c_nextalarm | NULL | NULL | | def | sogo | sogo_quick_appointment | c_description | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_folder_id | NULL | NULL | | def | sogo | sogo_quick_contact | c_name | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_givenname | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_cn | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_sn | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_screenname | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_l | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_mail | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_o | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_ou | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_telephonenumber | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_categories | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_component | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_quick_contact | c_hascertificate | NULL | NULL | | def | sogo | sogo_sessions_folder | c_id | utf8 | utf8_general_ci | | def | sogo | sogo_sessions_folder | c_value | utf8 | utf8_general_ci | | def | sogo | sogo_sessions_folder | c_creationdate | NULL | NULL | | def | sogo | sogo_sessions_folder | c_lastseen | NULL | NULL | | def | sogo | sogo_store | c_folder_id | NULL | NULL | | def | sogo | sogo_store | c_name | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_store | c_content | utf8mb4 | utf8mb4_general_ci | | def | sogo | sogo_store | c_creationdate | NULL | NULL | | def | sogo | sogo_store | c_lastmodified | NULL | NULL | | def | sogo | sogo_store | c_version | NULL | NULL | | def | sogo | sogo_store | c_deleted | NULL | NULL | | def | sogo | sogo_user_profile | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_user_profile | c_defaults | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogo_user_profile | c_settings | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d | c_creationdate | NULL | NULL | | def | sogo | sogojill0010573755d | c_lastmodified | NULL | NULL | | def | sogo | sogojill0010573755d | c_version | NULL | NULL | | def | sogo | sogojill0010573755d | c_deleted | NULL | NULL | | def | sogo | sogojill0010573755d_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_startdate | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_enddate | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_cycleenddate | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_title | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_participants | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_isallday | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_iscycle | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_cycleinfo | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_classification | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_isopaque | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_status | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_priority | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_location | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_orgmail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_partmails | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_partstates | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_category | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_sequence | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0010573755d_quick | c_nextalarm | NULL | NULL | | def | sogo | sogojill0010573755d_quick | c_description | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94 | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94 | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94 | c_creationdate | NULL | NULL | | def | sogo | sogojill0022cb36c94 | c_lastmodified | NULL | NULL | | def | sogo | sogojill0022cb36c94 | c_version | NULL | NULL | | def | sogo | sogojill0022cb36c94 | c_deleted | NULL | NULL | | def | sogo | sogojill0022cb36c94_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_givenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_cn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_sn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_screenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_l | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_mail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_o | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_ou | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_telephonenumber | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_categories | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogojill0022cb36c94_quick | c_hascertificate | NULL | NULL | | def | sogo | sogonico00130c60c38 | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38 | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38 | c_creationdate | NULL | NULL | | def | sogo | sogonico00130c60c38 | c_lastmodified | NULL | NULL | | def | sogo | sogonico00130c60c38 | c_version | NULL | NULL | | def | sogo | sogonico00130c60c38 | c_deleted | NULL | NULL | | def | sogo | sogonico00130c60c38_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_startdate | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_enddate | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_cycleenddate | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_title | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_participants | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_isallday | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_iscycle | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_cycleinfo | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_classification | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_isopaque | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_status | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_priority | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_location | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_orgmail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_partmails | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_partstates | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_category | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_sequence | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_nextalarm | NULL | NULL | | def | sogo | sogonico00130c60c38_quick | c_description | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00130c60c38_quick | c_hascertificate | NULL | NULL | | def | sogo | sogonico0016880dc00 | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00 | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00 | c_creationdate | NULL | NULL | | def | sogo | sogonico0016880dc00 | c_lastmodified | NULL | NULL | | def | sogo | sogonico0016880dc00 | c_version | NULL | NULL | | def | sogo | sogonico0016880dc00 | c_deleted | NULL | NULL | | def | sogo | sogonico0016880dc00_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_givenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_cn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_sn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_screenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_l | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_mail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_o | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_ou | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_telephonenumber | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_categories | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico0016880dc00_quick | c_hascertificate | NULL | NULL | | def | sogo | sogonico00251821f30 | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30 | c_content | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30 | c_creationdate | NULL | NULL | | def | sogo | sogonico00251821f30 | c_lastmodified | NULL | NULL | | def | sogo | sogonico00251821f30 | c_version | NULL | NULL | | def | sogo | sogonico00251821f30 | c_deleted | NULL | NULL | | def | sogo | sogonico00251821f30_acl | c_uid | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_acl | c_object | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_acl | c_role | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_name | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_givenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_cn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_sn | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_screenname | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_l | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_mail | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_o | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_ou | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_telephonenumber | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_categories | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_component | utf8mb4 | utf8mb4_unicode_ci | | def | sogo | sogonico00251821f30_quick | c_hascertificate | NULL | NULL | +---------------+--------------+-------------------------------+-------------------+--------------------+--------------------+ 284 rows in set (0.01 sec) |
|
|
|
|
|
|
 |
Can you locate the file "contact.ocs" and modify the c_hascertificate column by setting the "allowsNull" attribute to "NO"? |
|
|
Also: set MySQL4DebugEnabled to YES in sogo.conf and paste the create statement when creating a new address book (or log with a fresh new user). Thanks. |
|
|
|
|
|
I've added a new sogo log file, where I create a new address book with the MySQL4DebugEnabled set to YES. I can see the created address book in the web interface, but I cannot find the table in MariaDB. Where is the "contact.ocs" file located? I have some trouble locating it. |
|
|
/usr/lib/GNUstep/OCSTypeModels/contact.ocs |
|
|
|
|
|
I've done as requested and still cannot add users to the new address book. I've added the sogo log in sogo3.log. The new address book does show in the web interface, but no new table is found in my MariaDB. |
|
|
The column c_hascertificate doesn't appear in the table creation. Have you ever tried to install SOGo manually? find / -name contact.ocs -type f |
|
|
Found an old "contact.ocs" file in /usr/local/lib/GNUstep. After removing this entire GNUstep directory everything works again. Apologies for the inconvenience and thanks for the help. Issue fixed. Can be closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-09-22 07:37 | nspeelman | New Issue | |
| 2018-09-22 07:37 | nspeelman | File Added: sogo_database.txt | |
| 2018-09-22 07:37 | nspeelman | File Added: sogo.conf | |
| 2018-09-22 07:41 | nspeelman | File Added: sogo.log | |
| 2018-09-24 17:40 | francis | Note Added: 0013058 | |
| 2018-09-24 17:41 | francis | Note Added: 0013059 | |
| 2018-09-25 07:15 | nspeelman | File Added: sogo2.log | |
| 2018-09-25 07:21 | nspeelman | Note Added: 0013060 | |
| 2018-09-25 12:38 | francis | Note Added: 0013061 | |
| 2018-09-25 13:38 | nspeelman | File Added: sogo3.log | |
| 2018-09-25 13:41 | nspeelman | Note Added: 0013062 | |
| 2018-09-25 13:42 | nspeelman | Note Edited: 0013062 | |
| 2018-09-25 13:51 | francis | Note Added: 0013064 | |
| 2018-09-25 13:56 | francis | Note Edited: 0013064 | |
| 2018-09-27 05:15 | nspeelman | Note Added: 0013067 | |
| 2018-09-27 10:41 | francis | Status | new => closed |
| 2018-09-27 10:41 | francis | Assigned To | => francis |
| 2018-09-27 10:41 | francis | Resolution | open => no change required |
