6.0.0-git
2018-12-16

[#14847] object_members doesn't have a default value
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

History
2018-10-23 10:16:27 jiri (dot) reischig (at) ecn (dot) cz Comment #3 Reply to this comment
I'm sorry, I have this definition in my database:
   `object_members` blob NOT NULL

In configuration I have also "SQL DB schema is ready."

Some upgrade from old version was not good, maybe.


2018-10-23 01:15:57 Michael Rubinsky Comment #2
Priority ⇒ 1. Low
State ⇒ Feedback
Reply to this comment
object_members is defined as nullable, so, why would it need a default value?
2018-08-20 15:29:42 jiri (dot) reischig (at) ecn (dot) cz Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Summary ⇒ object_members doesn't have a default value
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
Reply to this comment
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


Saved Queries