[Tickets #597] NEW: Broken SQL constraint when initializing permissions

[bugs at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=597
-----------------------------------------------------------------------
 Ticket     | 597
 Created By | rvs at angara.ru
 Summary    | Broken SQL constraint when initializing permissions
 Queue      | Horde Base
 Version    | HEAD
 State      | Unconfirmed
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


rvs at angara.ru (2004-09-16 10:59) wrote:

Platform: Apache1.3.31+php4.3.8+Oracle9.2.1

After creating SQL tables and initial configuring HORDE,
the DataTree is empty. If I try to add a permission the following
error occurs (see log entry below). The permission can be added
only after removal of the constraint NOT NULL for column DATATREE_PARENTS.

Sep 17 02:52:45 HORDE [error] [horde] DB Error: null value violates not-null
constraint: INSERT INTO horde_datatree (datatree_id, group_uid,
datatree_name, datatree_order, datatree_data, user_uid, datatree_serialized,
datatree_parents) VALUES (2, 'horde.perms', 'whups', NULL, 'a:0:{}',
's.rozinov at sibron.ru', 15, '') [nativecode=ORA-01400: cannot insert NULL
into ("HORDE3"."HORDE_DATATREE"."DATATREE_PARENTS")] [on line 367 of
"/var/optpart/local/apache/http/beta.sibron.ru/htdocs/rvs/framework/Horde/Da
taTree/sql.php"]