Please take a look at the Issue::search() method in the model class file Issue.php. Towards the end of that method, there may be a typo that results in all previously set criteria conditions being overwritten, rather than appended to. If you change this:
It should address your search issues you are experiencing.
CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens. The SQL statement executed was: SELECT COUNT(*) FROM `tbl_issue` `t` WHERE (project_id LIKE :ycp0) AND (project_id=:projectID)
i’m using Yii 1.1.10
So I found a solution before posting the prob, I guess it’s good but not so sure,