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

* Your Email Address
* Spam protection	Enter the letters below: . .._.. .._. __. \| \| \| \|_/ \| (__ \|/\\|_\|_\| \_\|_.__)
Comment	> 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@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/DataTree/sql.php"] > >
Attachment
Watch this ticket