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

6.0.0-beta1

7/7/25

Summary	DB Error: invalid number (With Oracle)
Queue	Nag
Queue Version	2.3.2
Type	Bug
State	No Feedback
Priority	2. Medium
Owners
Requester	m.wessler (at) gmx (dot) ch
Created	07/18/2009 (5833 days ago)
Due	07/18/2009 (5833 days ago)
Updated	04/14/2010 (5563 days ago)
Assigned	09/18/2009 (5771 days ago)
Resolved	10/09/2009 (5750 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

04/14/2010 10:58:24 AM	qw (at) gmail (dot) com	Comment #12	Reply to this comment
So, can anybody using Oracle please explain to me why 35.00 is not a valid float value? It' look like this <a href="http://dom.com/">Site</a>

10/09/2009 08:01:46 AM	Jan Schneider	State ⇒ No Feedback

09/23/2009 11:58:16 AM	ico (at) cc (dot) upv (dot) es	Comment #11	Reply to this comment
FYI Including NLS_NUMERIC_CHARACTERS='.,' variable into start section of apache2 script I've resolved the problem. I'm now a new problem with null value in task_parent column; but this is another history. I think that in some place and using DB with oci8, building sentence is wrong. Thanks

09/21/2009 09:06:32 AM	Jan Schneider	Comment #10	Reply to this comment
So, can anybody using Oracle please explain to me why 35.00 is not a valid float value?

09/21/2009 07:50:04 AM	ico (at) cc (dot) upv (dot) es	Comment #9	Reply to this comment
Executing "desc" on sqlplus the result is FLOAT(126): Nombre ?Nulo? Tipo ----------------------------------------- -------- ---------------------------- TASK_ID NOT NULL VARCHAR2(32) TASK_OWNER NOT NULL VARCHAR2(255) TASK_CREATOR NOT NULL VARCHAR2(255) TASK_PARENT NOT NULL VARCHAR2(255) TASK_ASSIGNEE VARCHAR2(255) TASK_NAME NOT NULL VARCHAR2(255) TASK_UID NOT NULL VARCHAR2(255) TASK_DESC CLOB TASK_START NUMBER(38) TASK_DUE NUMBER(38) TASK_PRIORITY NOT NULL NUMBER(38) TASK_ESTIMATE FLOAT(126) TASK_CATEGORY VARCHAR2(80) TASK_COMPLETED NOT NULL NUMBER(38) TASK_COMPLETED_DATE NUMBER(38) TASK_ALARM NOT NULL NUMBER(38) TASK_PRIVATE NOT NULL NUMBER(38)

09/18/2009 03:37:59 PM	Jan Schneider	Comment #8 State ⇒ Feedback	Reply to this comment
What's the type of the task_estimate column in your table?

09/18/2009 03:19:40 PM	ico (at) cc (dot) upv (dot) es	Comment #7	Reply to this comment
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@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"]

08/18/2009 01:31:11 PM	Jan Schneider	State ⇒ No Feedback

08/03/2009 03:10:48 PM	Jan Schneider	Comment #6	Reply to this comment
If yes, put the following on line 207: Horde::logMessage($this->_write_db->last_query, __FILE__, __LINE__, PEAR_LOG_ERR);

08/03/2009 03:09:05 PM	Jan Schneider	Comment #5 Summary ⇒ DB Error: invalid number (With Oracle)	Reply to this comment
Exactly the same, including these weird 'helmut'0, 'helmut'1, 'helmut'2, etc?

07/22/2009 05:21:19 PM	m (dot) wessler (at) gmx (dot) ch	Comment #4	Reply to this comment
and no differences Sorry ... same error... :-( Please download DB from http://download.pear.php.net/package/DB-1.7.14RC1.tgz, unpack it, and replace the files in horde/pear. Then try again. If it still fails, post the (hopefully) then different error message.

07/22/2009 05:20:08 PM	m (dot) wessler (at) gmx (dot) ch	Comment #3	Reply to this comment
Sorry ... same error... :-( Please download DB from http://download.pear.php.net/package/DB-1.7.14RC1.tgz, unpack it, and replace the files in horde/pear. Then try again. If it still fails, post the (hopefully) then different error message.

07/20/2009 03:17:47 PM	Jan Schneider	Comment #2 State ⇒ Feedback	Reply to this comment
Please download DB from http://download.pear.php.net/package/DB-1.7.14RC1.tgz, unpack it, and replace the files in horde/pear. Then try again. If it still fails, post the (hopefully) then different error message.

07/18/2009 08:02:11 PM	m (dot) wessler (at) gmx (dot) ch	Comment #1 Priority ⇒ 2. Medium State ⇒ Unconfirmed Patch ⇒ No Milestone ⇒ Due ⇒ 07/18/2009 Summary ⇒ [nag] DB Error: invalid number ( With Oracle ) Type ⇒ Bug Queue ⇒ Nag	Reply to this comment
[nag H3 (2.3.2)] DB Error: invalid number ( With Oracle ) this happens if you want to create a new task: Jul 18 21:48:19 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 ('helmut', 'helmut', '', '173fc6d45d6514401b1cc8d33c77898a', 'test', '20090718214819.83252je9h9xpaewz@webmail.aroundtheworld.com', '', '0', '0', '3', 'helmut'0, 'helmut'1, 'helmut'2, 'helmut'3, 'helmut'4, 'helmut'5) [nativecode=ORA-01722: invalid number] [pid 22542 on line 207 of "/var/www2/mail/nag/lib/Driver/sql.php"]