Problem: Table ‘DATEBASE_NAME.AuthAssignment’ doesn’t exist This is because your tables names are in lowercase but in code they are being referred with different capitalization, Linux is case sensitive so it treats authassignment and AuthAssignment differently. In your root/protected/config/main.php specify exactly the same table names as they appear in your database.
If you have used Rights module for RBAC in your Yii application and you deploy it on Linux based server, you may encounter this error.Cause of the problem:
Solution:
'components'=>array( 'authManager'=>array( 'defaultRoles'=>array('guest'), 'class'=>'RDbAuthManager', 'assignmentTable'=>'authassignment', 'itemTable'=>'authitem', 'rightsTable'=>'rights', 'itemChildTable'=>'authitemchild', ),
Yii
Table 'DATEBASE_NAME.AuthAssignment' doesn't exist
<p>If you have used Rights module for RBAC in your Yii application and you deploy it on Linux based server, you may encounter this error.</p>
· 5 min read
Related posts
Yii
How to separate front and admin panel in yii-framework
In my previous post I demonstrated you how to render different layout for different user role, now lets move a step forward and see how to create separate front
Yii
How to save multiple related models in Yii [Complete Solution]
Scenario: You are in a situation where you have two related tables a Parent and a child table. You need to create a user experience in which user presses Save b
Yii
How to make Yii checkBoxList selected
Many people find it hard to make the Yii checkBoxList selected on update view, but believe me in fact its very easy and straight forward. This post will help yo