Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.16.14

Bug #407 Incorrect database structure creation within Perm_DB_Complex.sql
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)    

 [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)


 [2003-12-11 21:11 UTC] arnaud
This bug has been fixed in CVS. In case this was a documentation problem, the fix will show up at the end of next Sunday (CET) on In case this was a website problem, the change will show up on the website in short time. Thank you for the report, and for helping us make PEAR better.