Search code examples
mysqlphpmyadminyiicase-sensitive

CaseSenstive Table names

hi there i made track star application and everything works fine except for one issue that i face error CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'devnmark_root.AuthAssignment' doesn't exist. The SQL statement executed was: SELECT * FROM 'AuthAssignment' WHERE userid=:userid

now this was automatically generated by Yii when i checked for if(Yii::app()->user->checkAccess('createUser',array('project'=>$model))) 18 { 19 $this->menu[] = array('label'=>'Add User To Project','url'=>array('adduser', 'id'=>$model->id)); 20 }

then i went to phpmyadmin and executed this query manually

SELECT * FROMAuthAssignmentWHERE userid=4 and there is error which says same that table does not exist.

if i use small case letter for table name then no error.

i executed same query on local wamp 's phpmyadmin same query does not show any error there so this is clear that there is error with my sql .any idea what can i do to solve?

Solution

  • I suggest you hitting up SQL_MODE documentation for setting your final options. http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

    For testing you can just do a:

    SET sql_mode = '';

    Or adjust your command line:

    --sql-mode=""