6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
11/12/25
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers