[Tickets #14163] Driver oci8 fails updating or creating contact

[noreply at bugs.horde.org]

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

Ticket URL: https://bugs.horde.org/ticket/14163
------------------------------------------------------------------------------
  Ticket             | 14163
  Created By         | ico at cc.upv.es
  Summary            | Driver oci8 fails updating or creating contact
  Queue              | Turba
  Version            | 4.2.11
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


ico at cc.upv.es (2015-11-16 17:50) wrote:

>>> Since last version 5.2.11 I can't insert nor update vCard, nor  
>>> modify items in the addressbook.
>>> There is a problem making sql sentence using "returning into".
>>>
>>> I'm using oci8 driver.
>>>
>>> I appreciate some help.
>>>
>>> Nov 16 15:09:42 ERR: HORDE [turba] SQL QUERY FAILED: ORA-00936:  
>>> falta una expresión
>>>        UPDATE turba_objects SET owner_id = 'ico at upv.es', object_type =
>>>          'Object', object_members = NULL, object_uid =  
>>> 'GEjXsIswzRyhMjJmJtYA',
>>>          object_firstname = '', object_lastname = 'Adm.           
>>> SL', object_middlenames = '', object_nameprefix = '',
>>>          object_namesuffix = '', object_alias = 'alejandro',
>>>          object_yomifirstname = '', object_yomilastname = '', object_bday =
>>>          NULL, object_anniversary = NULL, object_spouse = '',  
>>> object_photo =
>>>          NULL, object_phototype = NULL, 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_department = '',  
>>> object_manager = '',
>>>          object_assistant = '', object_tz = '', object_email =
>>>          'direccion at ono.com', object_homephone = '',  
>>> object_homephone2 = '',
>>>          object_homefax = '', object_workphone = '',  
>>> object_workphone2 = '',
>>>          object_cellphone = '', object_carphone = '',  
>>> object_radiophone = '',
>>>          object_companyphone = '', object_assistantphone = '',  
>>> object_fax = '',
>>>          object_pager = '', object_title = '', object_role = '',  
>>> object_company
>>>          = '', object_logo = NULL, object_logotype = NULL,  
>>> object_notes = '',
>>>          object_url = '', object_freebusyurl = '',  
>>> object_pgppublickey = '',
>>>          object_smimepublickey = '', object_imaddress = '',  
>>> object_imaddress2 =
>>>          '', object_imaddress3 = '' WHERE object_id =
>>>          '044384bcea431221f2d2da9ae8f88776' RETURNING INTO [pid  
>>> 4008 on line 314 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"]
>>> Nov 16 15:09:42 ERR: HORDE [turba] Error del servidor al guardar  
>>> los datos. [pid 4008 on line 562 of  
>>> "/var/www/vhosts/wmz.upv.es/horde/turba/lib/Driver/Sql.php"]
>>> 2015-11-16T15:09:42+01:00 DEBUG: HORDE 1.  
>>> Turba_Form_EditContact->execute()  
>>> /var/www/vhosts/wmz.upv.es/horde/turba/edit.php:78
>>> 2. Turba_Object->store()  
>>> /var/www/vhosts/wmz.upv.es/horde/turba/lib/Form/EditContact.php:90
>>> 3. Turba_Driver->save()  
>>> /var/www/vhosts/wmz.upv.es/horde/turba/lib/Object.php:569
>>> 4. Turba_Driver_Share->_save()  
>>> /var/www/vhosts/wmz.upv.es/horde/turba/lib/Driver.php:1111
>>> 5. Turba_Driver_Sql->_save()  
>>> /var/www/vhosts/wmz.upv.es/horde/turba/lib/Driver/Share.php:316
>>
>> Looks like this can happen when there are binary fields defined for  
>> the source but there is no value set for any of them during  
>> update/save. Is that the case you are seeing? I.e., does this still  
>> happen if you try to set a photo for the contact?
>>
>>
>>
> Exactly. You are right. If I load a picture to the contact it works fine.
> Then...?
>
> Same issue happens when importing vCard (without picture, I think).
>
> Can I do anything?

No, it's a bug in the code. Please create a ticket on bugs.horde.org  
so it doesn't get lost. I'll try to work it out shortly.