Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.16.14
Bug #419 Foreign Key constraint violation
Submitted: 2003-12-12 23:34 UTC
From: kipaten21 at hotmail dot com Assigned: arnaud
Status: Closed Package: LiveUser
PHP Version: Irrelevant OS: ANY
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 36 - 4 = ?

 
 [2003-12-12 23:34 UTC] kipaten21 at hotmail dot com
Description: ------------ In the method LiveUser_Admin_Perm_DB_Common::removeArea(), the rights and areaadmins should be removed before the actual area is deleted to avoid a foreign key constraint violation. Also in LiveUser_Admin_Perm_DB_Common::removeRight(), the userrights and grouprights should be removed before moving the actual right for the same reason. Any other method that removes items should probably follow the same rule, delete all children before deleting the parent. P.S. Don't forget about the other Admin classes also.

Comments

 [2003-12-15 12:16 UTC] arnaud
Fixed in CVS. I also applied the changes to the removeGroup method.