[turba] problems with oracle

Ico Izquierdo ico at cc.upv.es
Mon Jul 20 14:48:46 UTC 2009


Thanks for your answer.
Field photo and the other fields were left in blank.
Then "Array" is a wrong value, and too the rest of them until the end.

Ico

Jan Schneider escribió:
> Zitat von Ico Izquierdo <ico at cc.upv.es>:
>
>> Hello all,
>> Last version of Horde Groupware Webmail Edition installed.
>> Oracle as DataBase.
>> When I try to add a contact operation fails. It seems like an error 
>> constructing the sentence.
>> I appreciate some help.
>>
>> Message of horde.log:
>> Jul 17 10:45:08 HORDE [error] [turba] DB Error: unknown error: INSERT 
>> INTO turba_objects (object_type, object_firstname, object_lastname, 
>> object_middlenames, object_nameprefix, object_namesuffix, 
>> object_alias, object_bday, object_photo, 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_tz, object_email, 
>> object_homephone, object_workphone, object_cellphone, object_fax, 
>> object_pager, object_title, object_role, object_company, object_logo, 
>> object_category, object_notes, object_url, object_freebusyurl, 
>> object_pgppublickey, object_smimepublickey, owner_id, object_uid, 
>> object_id) VALUES ('Object', 'Ico', 'Izquierdo Sebastián', '', 'Sr. 
>> D.', 'el tio ico', 'eltioico', '1966-03-18', 'Array', '', 'Ico'0, 
>> 'Ico'1, 'Ico'2, 'Ico'3, 'Ico'4, 'Ico'5, 'Ico'6, 'Ico'7, 'Ico'8, 
>> 'Ico'9, 'Izquierdo Sebastián'0, 'Izquierdo Sebastián'1, 'Izquierdo 
>> Sebastián'2, 'Izquierdo Sebastián'3, 'Izquierdo Sebastián'4, 
>> 'Izquierdo Sebastián'5, 'Izquierdo Sebastián'6, 'Izquierdo 
>> Sebastián'7, 'Izquierdo Sebastián'8, 'Izquierdo Sebastián'9, ''0, 
>> ''1, ''2, ''3, ''4, ''5, ''6, ''7, ''8, ''9, 'Sr. D.'0) 
>> [nativecode=ORA-01465: invalid hex number] [pid 6979 on line 300 of 
>> "/srv/www/htdocs/horde/turba/lib/Driver/sql.php"]
>
> Looks like something goes wrong with quoting. What's the values you 
> entered into those fields? "Ico"?
> The "Array" for the photo field doesn't look correct either, but 
> that's a different problem.
>
> Jan.
>


More information about the turba mailing list