[turba] error ora-01704 updating oracle blob field

[Jan Schneider]

Zitat von Ico Izquierdo <ico at cc.upv.es>:

> 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
>
> -- 
> turba mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org

Fixed in Git.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/