[Tickets #8442] Re: DB Error: invalid number (With Oracle)

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8442
------------------------------------------------------------------------------
  Ticket             | 8442
  Updated By         | ico at cc.upv.es
  Summary            | DB Error: invalid number (With Oracle)
  Queue              | Nag
  Version            | 2.3.2
  Type               | Bug
  State              | No Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


ico at cc.upv.es (2009-09-18 11:19) wrote:

I have done mentioned changes and now I obtains the same error message  
from ORACLE but SQL sentence construction is correct.

I have tried to execute sentence into sqlplus environment and removing  
dot from field "task_estimate" it works fine.

Sep 18 14:35:16 HORDE [error] [nag] DB Error: invalid number: INSERT  
INTO nag_tasks (task_owner, task_creator, task_assignee, task_id,  
task_name, task_uid, task_desc, task_start, task_due, task_priority,  
task_estimate, task_completed, task_category, task_alarm,  
task_private, task_parent) VALUES ('ico', 'ico', '',  
'57e63639abd3523879c9e99e2cc6ef7b', 'nombre de tarea',  
'20090918143516.10031fpwl0c1y83o at mintaka.cc.upv.es', 'tarea en  
ingles', '0', '0', '3', '35.00', '0', '', '0', '0', '')  
[nativecode=ORA-01722: invalid number] [pid 3562 on line 208 of  
"/srv/www/htdocs/horde/nag/lib/Driver/sql.php"]