Thread: Fine Grained Role Based Access Control (RBAC) system
View Single Post
  #46 (permalink)  
Old 07-03-2008, 08:10 AM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 95
ben has disabled reputation
Default Re: Fine Grained Role Based Access Control (RBAC) system
Quote:
Originally Posted by superj View Post
I am having the hardest time installing the DB. I created an empty database and set the user name in the config.php. The user has access to the database. I run the rb.sql and I get a user access error. If I paste the contents of rb.sql in the sql window of phpmyadmin the tables are created but when I get to the end of the file setting up the foreign keys I get (er121). For those of you who have installed successfully can you please enlighten me on how you did it?
I think there is a data type mismatch between a foreign key and its corresponding primary key. I think one is int(11) and the other is int(10) or something like that. When I get the time I will have a closer look.
Reply With Quote