[turba] Problem with oci8 driver?

[Michael J Rubinsky]

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?

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5751 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/turba/attachments/20151116/3042f228/attachment.bin>