Bug #407

Incorrect database structure creation within Perm_DB_Complex.sql

Details

Submitted	2003-12-11 16:55 UTC
From	alex at burgiss dot com
Assigned	lsmith
Status	Closed
Package	LiveUser
PHP Version	4.3.4
OS	redhat 9
Roadmaps	(Not assigned)

Comments

[2003-12-11 16:55 UTC] alex at burgiss dot com

Description:
------------
within the sql script Perm_DB_Complex.sql, the columns owner_perm_user_id and owner_group_id within the table liveuser_groups is incorrectly set to NOT NULL as owner_perm_user_id and owner_group_id can be null according to the code in addGroup() in Perms/Container/DB_Complex.php

i've emailed the mailing list about this a while ago (Oct 23rd), and Lukas Smith said he would take a look at the schema and correct this, although it appears to still be there in the latest cvs..

Reproduce code:
---------------
any call to addGroups() as db_complex using default null value for owner_perm_user_id and owner_group_id

Expected result:
----------------
no error msg

Actual result:
--------------
some database error msg complaining about nulls not being allowed in a NOT NULL field
(sorry, I don't have the specific msg)