| Summary | object_members doesn't have a default value |
| Queue | Turba |
| Queue Version | 4.2.23 |
| Type | Bug |
| State | Feedback |
| Priority | 1. Low |
| Owners | |
| Requester | jiri.reischig (at) ecn (dot) cz |
| Created | 2018-08-20 (118 days ago) |
| Due | |
| Updated | 2018-10-23 (54 days ago) |
| Assigned | 2018-10-23 (54 days ago) |
| Resolved | |
| Milestone | |
| Patch | No |
`object_members` blob NOT NULL
In configuration I have also "SQL DB schema is ready."
Some upgrade from old version was not good, maybe.
Priority ⇒ 1. Low
State ⇒ Feedback
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Summary ⇒ object_members doesn't have a default value
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
It's error in MariaDB version 10.3 which have enabled STRICT_TRANS_TABLES.
The SQL command ended with error:
INSERT INTO `turba_objects` (`object_type`, `object_firstname`,
`object_lastname`, `object_middlenames`, `object_nameprefix`,
`object_namesuffix`, `object_alias`, `object_bday`, `object_spouse`,
`object_anniversary`, `object_yomifirstname`, `object_yomilastname`,
`object_photo`, `object_homestreet`, `object_homepob`,
`object_homecity`, `object_homeprovince`, `object_homepostalcode`,
`object_homecountry`, `object_workstreet`, `object_workpob`,
`object_workcity`, `object_workprovince`, `object_workpostalcode`,
`object_workcountry`, `object_otherstreet`, `object_otherpob`,
`object_othercity`, `object_otherprovince`, `object_otherpostalcode`,
`object_othercountry`, `object_tz`, `object_email`,
`object_homeemail`, `object_workemail`, `object_homephone`,
`object_homephone2`, `object_workphone`, `object_workphone2`,
`object_carphone`, `object_radiophone`, `object_companyphone`,
`object_assistantphone`, `object_homefax`, `object_cellphone`,
`object_fax`, `object_pager`, `object_imaddress`, `object_imaddress2`,
`object_imaddress3`, `object_title`, `object_role`, `object_company`,
`object_department`, `object_logo`, `object_assistant`,
`object_manager`, `object_notes`, `object_url`, `object_freebusyurl`,
`object_pgppublickey`, `object_smimepublickey`, `owner_id`,
`object_uid`, `object_id`) VALUES ...
Error:
SQL QUERY FAILED: Field 'object_members' doesn't have a default value