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

6.0.0-alpha14

7/2/25

Summary	Driver oci8 fails updating or creating contact
Queue	Horde Framework Packages
Type	Bug
State	Resolved
Priority	3. High
Owners	mrubinsk (at) horde (dot) org
Requester	ico (at) cc (dot) upv (dot) es
Created	11/16/2015 (3516 days ago)
Due
Updated	11/17/2015 (3515 days ago)
Assigned
Resolved	11/17/2015 (3515 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

11/17/2015 03:26:49 PM	Michael Rubinsky	Assigned to Michael Rubinsky

11/17/2015 03:26:37 PM	Michael Rubinsky	Comment #5 Version ⇒ Queue ⇒ Horde Framework Packages State ⇒ Resolved	Reply to this comment
Horde_Db 2.3.0

11/17/2015 03:21:56 PM	Git Commit	Comment #4	Reply to this comment
Changes have been made in Git (master): commit bf86a66b4ebf7a2d5a6754b24429946a7297255c Author: Michael J Rubinsky <mrubinsk@horde.org> Date: Tue Nov 17 10:21:36 2015 -0500 Add test for ~~Bug: 14163~~ framework/Db/test/Horde/Db/Adapter/Oci8Test.php \| 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) http://github.com/horde/horde/commit/bf86a66b4ebf7a2d5a6754b24429946a7297255c

11/17/2015 02:36:30 PM	Git Commit	Comment #3	Reply to this comment
Changes have been made in Git (master): commit 98f152ce69ed30ef4fcb76e8a391b50057752e0e Author: Michael J Rubinsky <mrubinsk@horde.org> Date: Tue Nov 17 09:36:02 2015 -0500 ~~Bug: 14163~~ Forgot to remove this. framework/Db/lib/Horde/Db/Adapter/Oci8.php \| 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) http://github.com/horde/horde/commit/98f152ce69ed30ef4fcb76e8a391b50057752e0e

11/17/2015 01:25:34 PM	Git Commit	Comment #2	Reply to this comment
Changes have been made in Git (master): commit 508e7624daaae02c7841d602ad17880d04d70dd5 Author: Michael J Rubinsky <mrubinsk@horde.org> Date: Tue Nov 17 08:24:08 2015 -0500 ~~Bug: 14163~~ Fix SQL in oci8 when setting a blob field to an empty value. framework/Db/lib/Horde/Db/Adapter/Oci8.php \| 23 +++++++++++++++++------ 1 files changed, 17 insertions(+), 6 deletions(-) http://github.com/horde/horde/commit/508e7624daaae02c7841d602ad17880d04d70dd5

11/16/2015 05:50:01 PM	ico (at) cc (dot) upv (dot) es	Comment #1 Priority ⇒ 3. High Type ⇒ Bug Summary ⇒ Driver oci8 fails updating or creating contact Queue ⇒ Turba Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
[Show Quoted Text - 80 lines][Hide Quoted Text] 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.