6.0.0-beta1
7/7/25

[#8442] DB Error: invalid number (With Oracle)
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

History
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"]


Saved Queries