[Tickets #14847] Re: object_members doesn't have a default value

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14847
------------------------------------------------------------------------------
  Ticket             | 14847
  Updated By         | jiri.reischig at ecn.cz
  Summary            | object_members doesn't have a default value
  Queue              | Turba
  Version            | 4.2.23
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


jiri.reischig at ecn.cz (2018-08-20 15:29) wrote:

Column object_members in table turba_objects  doesn't have a default value.

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