I am trying to use the unique-index-validator from http://www.yiiframework.com/extension/unique-index-validator/ to validate unique indexes against a mysql db.
But it throws the below error:
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{{`tblNews`}} WHERE Non_unique = 0' at line 1. The SQL statement executed was: SHOW INDEX FROM {{`tblNews`}} WHERE Non_unique = 0
Have anyone used this validator and seen this error?
When I checked the code from the validator, it seems to use the below query,
SHOW INDEX FROM {{%s}} WHERE Non_unique = 0
does the curly braces look valid to you??