[turba] Problem with oci8 driver?

[Ico Izquierdo]

El 16/11/2015 a las 17:21, Michael J Rubinsky escribió:
>
> Quoting Ico Izquierdo <ico at cc.upv.es>:
>
>> El 16/11/2015 a las 15:56, Michael J Rubinsky escribió:
>>>
>>> Quoting Ico Izquierdo <ico at cc.upv.es>:
>>>
>>>> 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. 
>>>> Inmobiliaria Izquierdo
>>>>          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 =
>>>>          'adimiz 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.
>
>
>
>
Thank you for the patch.

-- 
Ico Izquierdo
Analista-Programador
ASIC - UPV