[Tickets #14859] Column 'object_members' cannot be null in table turba_objects

[noreply at bugs.horde.org]

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

Ticket URL: https://bugs.horde.org/ticket/14859
------------------------------------------------------------------------------
  Ticket             | 14859
  Created By         | jiri.reischig at ecn.cz
  Summary            | Column 'object_members' cannot be null in table
                     | turba_objects
  Queue              | Turba
  Version            | FRAMEWORK_5_2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


jiri.reischig at ecn.cz (2018-09-26 10:37) wrote:

I find problem with ActiveSync and Turba in SQL.

It's look like bad column definition or SQL in command.

The Error:

Sep 26 10:41:39 ecn4 HORDE: [turba] SQL QUERY FAILED: Column  
'object_members' cannot be null  #012#011UPDATE `turba_objects` SET  
`owner_id` = '***', `object_type`#012#011  = 'Object',  
`object_members` = NULL, `object_uid` =#012#011   
'20180926103222.dVI3oddh6Jo9jwTvFXEtJt4 at webmail.ecn.cz',#012#011   
`object_firstname` = 'J', `object_lastname` = 'webmail',#012#011   
`object_middlenames` = '', `object_nameprefix` = '',#012#011   
`object_namesuffix` = '', `object_alias` = '',  
`object_yomifirstname`#012#011  = '', `object_yomilastname` = '',  
`object_bday` = '',#012#011  `object_anniversary` = '',  
`object_spouse` = '', `object_photo` = '',#012#011  `object_phototype`  
= NULL, `object_homestreet` = '', `object_homepob`#012#011  = NULL,  
`object_homecity` = '', `object_homeprovince` = '',#012#011   
`object_homepostalcode` = '', `object_homecountry` = '',#012#011   
`object_workstreet` = '', `object_workpob` = NULL, `object_workcity`  
=#012#011  '', `object_workprovince` = '', `object_workpostalcode` =  
'',#012#011  `object_workcountry` = '', `object_otherstreet` =  
'',#012#011  `object_otherpob` = NULL, `object_othercity` =  
'',#012#011  `object_otherprovince` = '', `object_otherpostalcode` =  
'',#012#011  `object_othercountry` = '', `object_department` = '',  
`object_manager`#012#011  = '', `object_assistant` = '', `object_tz` =  
NULL, `object_email` =#012#011  '', `object_homephone` = '',  
`object_homephone2` = '',#012#011  `object_homefax` = '',  
`object_workphone` = '', `object_workphone2` =#012#011  '',  
`object_cellphone` = '111 111 111, `object_carphone` = '',#012#011   
`object_radiophone` = '', `object_companyphone` = '',#012#011   
`object_assistantphone` = '', `object_fax` = '', `object_pager` =  
'',#012#011  `object_title` = '', `object_role` = NULL,  
`object_company` = 'ecn#012#011  studio', `object_logo` = NULL,  
`object_logotype` = NULL,#012#011  `object_notes` = NULL, `object_url`  
= '', `object_freebusyurl` = NULL,#012#011  `object_pgppublickey` =  
NULL, `object_smimepublickey` = NULL,#012#011  `object_imaddress` =  
'', `object_imaddress2` = '', `object_imaddress3`#012#011  = '',  
`object_homeemail` = '', `object_workemail` = '' WHERE  
object_id#012#011  = '4g8JGm81OB90NWlH2qjv8ec' [pid 14166 on line 318  
of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]