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


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

Comments

 [2003-12-11 21:11 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!