Tickets :: Comment on [#2745] Import Problem

* Your Email Address
* Spam protection	Enter the letters below: .__ . ..__ . ,. . [ __\|\/\|[ __ \./ \|__\| [_./\| \|[_./ \| \| \|
Comment	> 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 > > > >
Attachment
Watch this ticket