[Tickets #2745] NEW: Import Problem

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=2745
-----------------------------------------------------------------------
 Ticket             | 2745
 Created By         | scalero at datadec.es
 Summary            | Import Problem
 Queue              | Nag
 Version            | FRAMEWORK_3
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


scalero at datadec.es (2005-10-07 00:05) wrote:

I use Nag H3 2.0.2, Horde 3.0.5 and Oracle 10g like data storage.

If one user export his tasks in a CSV o Icalendar format file and another
user want to export this same file, the second user obtains this error: "DB
Error: null value violates not-null constraint"

And in 'horde.log' this appears: 

Oct 06 15:42:56 HORDE [error] [nag] DB Error: null value violates not-null
constraint: INSERT INTO nag_tasks (task_owner, task_id, task_name, task_uid,
task_desc, task_due, task_priority, task_completed, task_category,
task_alarm) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [nativecode=ORA-01400:
cannot insert NULL into ("DB_USER"."NAG_TASKS"."TASK_COMPLETED")] [on line
184 of "/u01/horde/nag/lib/Driver/sql.php"]

I think the problem is that Oracle does not distinguish between null and
emptiness ('') values, and several fields(task_priority, task_completed,
task_alarm, task_private) in the table nag_tasks have 'NOT NULL' . 

Could these fields be null? Any Problems?

Greetings and thanks.

Sebastian Calero