[turba] error ora-01704 updating oracle blob field

Ico Izquierdo ico at cc.upv.es
Thu Jul 16 10:45:46 UTC 2015


Hi all,
on a last version Horde Groupware Webmail Edition having Oracle 11.2.0.4 
as backend.
When I try to add a photo to a contact in Turba there was an error 
ORA-01704: string literal too long.
The field object_photo  is defined as BLOB (until 4Gb of data) but the 
picture I'm trying to upload is not very large.
I can't find any info in lists.

Any help?

Thanks in advance.

The log:

Jul 14 13:35:41 ERR: HORDE [turba] SQL QUERY FAILED: ORA-01704: literal 
de cadena demasiado largo
         UPDATE turba_objects SET owner_id = 'ico at upv.es', object_type =
           'Object', object_members = NULL, object_uid =
           '20130716103710.86163ugbg1asruba at webmail.upv.es', 
object_firstname =
           '', object_lastname = 'Yo mismo 2', object_middlenames = '',
           object_nameprefix = '', object_namesuffix = '', object_alias 
= '',
           object_yomifirstname = '', object_yomilastname = '', 
object_bday =
           NULL, object_anniversary = NULL, object_spouse = '', 
object_photo =
'ffd8ffe000104a46494600010201004800480000ffed0cd850686f746f73686f70203
32e30003842494d03ed0000000000100047ffb4000200020047ffb4000200023842494
d03f300000000000800000000000000003842494d040a00000000000100003842494d2
71000000000000a000100000000000000023842494d03f5000000000048002f6666000
1006c66660006000000000001002f6666000100a1999a0006000000000001003200000
001005a00000006000000000001003500000001002d000000060000000000013842494
d03f80000000000700000ffffffffffffffffffffffffffffffffffffffffffff03e80
0000000ffffffffffffffffffffffffffffffffffffffffffff03e800000000fffffff
fffffffffffffffffffffffffffffffffffff03e800000000fffffffffffffffffffff
fffffffffffffffffffffff03e800003842494d040000000000000200013842494d040
2000000000004000000003842494d04080000000000100000000100000240000002400
00000003842494d0409000000000b49000000010000007a00000080000001700000b80
000000b2d00180001ffd8ffe000104a46494600010201004800480000fffe002746696
c65207772697474656e2062792041646f62652050686f746f73686f70a820342e3000f
fee000e41646f626500648000000001ffdb0084000c08080809080c09090c110b0a0b1
1150f0c0c0f1518131315131318110c0c0c0c0c0c110c0c0c0c0c0c0c0c0c0c0c0c0c0
c0c0c0c0c0c0c0c0c0c0c0c0c0c0c010d0b0b0d0e0d100e0e10140e0e0e14140e0e0e0
            ......
            and more
            ......
abb157fffd7ecb8ab78ab58ab88ae2aa4f02b62a8696d76c552f9adc838aa8185bc315
425c5af31423154aee74f5e24018ab1f9f4890c9455ef8aa6163a0d685c62ac82d2c63
8147118aa2f8d3155e91963418aa616b69dc8c5514f6a29b0c5506f6a7974c555a388a
8a5315565889c555d2103af5c5557a74c55d8ab78abb15762afffd0ec85a87156c1c55
d8abb157138ab47718aa8b5b863538aad36a87b62a859ec6bd062a827d39cfece2ab53
4704d4ae2a8b8f4a551d298aaafe8d18ab869a315578ec913b62a895503618aaea62ab
4c6a715708d7c3155c0018abb15762aec55d8abb156f157ffd1ec678577eb8aae14ed8
ab78abb156b6c55db62aedb1576d8ab5f0d71577c3ed8abbe0f6c55bdb1576d8abb157
62aec55bc55d8abb15762aec55d8abb156b156f15762aff00ffd9',
           object_phototype = 'image/jpeg', 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 =
           'eltioico at gmail.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 =
           '6b41c2710f206f7e4895eba07ab5b97e' [pid 13168 on line 314 of 
"/usr/share/pear/Horde/Db/Adapter/Oci8.php"]
Jul 14 13:35:41 ERR: HORDE [turba] Error del servidor al guardar los 
datos. [pid 13168 on line 550 of 
"/var/www/vhosts/wmy.upv.es/horde/turba/lib/Driver/Sql.php"]
2015-07-14T13:35:41+02:00 DEBUG: HORDE 1. 
Turba_Form_EditContact->execute() 
/var/www/vhosts/wmy.upv.es/horde/turba/edit.php:78
2. Turba_Object->store() 
/var/www/vhosts/wmy.upv.es/horde/turba/lib/Form/EditContact.php:90
3. Turba_Driver->save() 
/var/www/vhosts/wmy.upv.es/horde/turba/lib/Object.php:551
4. Turba_Driver_Share->_save() 
/var/www/vhosts/wmy.upv.es/horde/turba/lib/Driver.php:1068
5. Turba_Driver_Sql->_save() 
/var/www/vhosts/wmy.upv.es/horde/turba/lib/Driver/Share.php:316





-- 
Ico Izquierdo
Analista-Programador
ASIC - UPV



More information about the turba mailing list