[turba] Problem with oci8 driver?
Ico Izquierdo
ico at cc.upv.es
Mon Nov 16 16:07:17 UTC 2015
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?
Thanks a lot.
--
Ico Izquierdo
Analista-Programador
ASIC - UPV
More information about the turba
mailing list