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', ),
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>
Scriptbaker Editorial Team
The Scriptbaker editorial team comprises engineers, AI specialists, and digital strategists based in Dubai and Rawalpindi. We write about software development, artificial intelligence, and digital transformation to help organisations build better products. Learn more about us →
Related posts
Yii
Separate Front & Admin in Yii
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
Yii Multiple Related Models Save Guide
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