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 |
a valid float value?
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
valid float value?
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)
State ⇒ Feedback
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"]
Horde::logMessage($this->_write_db->last_query, __FILE__, __LINE__,
PEAR_LOG_ERR);
Summary ⇒ DB Error: invalid number (With Oracle)
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.
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.
State ⇒ Feedback
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.
Priority ⇒ 2. Medium
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Due ⇒ 07/18/2009
Summary ⇒ [nag] DB Error: invalid number ( With Oracle )
Type ⇒ Bug
Queue ⇒ Nag
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"]