CDbException:CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]:... Base table or view not found: 1146 Table 'X_mts.AuthAssignment
Posted 18 April 2012 - 01:08 AM
I did not have problems in my developing setup (windows 7, latest XAMPP 1.7.7)
but when I deployed my webapp to remote site ( I am using justhost linux env ... )
I got errors
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXXX_mts.AuthAssignment' doesn't exist
I searched this issue from the web ,, there were similar issues in the previous yii too.. can not get solution ....
did I do anything wrong ..!
does anyone have good solutions ..? thx
I believe it is a bug ....
Posted 18 April 2012 - 03:42 AM
Posted 18 April 2012 - 05:07 AM
you will probably need to do the same for
Posted 21 August 2013 - 07:53 AM
Thanks for this!
Sorted my errors out from 'development using wamp on windows' to going 'live on a linux server'.
Used a a few capitalizations in rule components for table names.