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

* Your Email Address
* Spam protection	Enter the letters below: .___. __ . .. . . _/ / `\|\ \|\ / \| ./__.\__.\| \\| \/ \__\|
Comment	>>>> 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@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@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. >
Attachment
Watch this ticket

Saved Queries