Invalid parameter number: number of bound variables does not match number of tokens.

Yii 1.1 General Discussion
1

I’ve make query to my table of DB:


$result = Masters::model()->findAll('prove=:myParams AND show:=myVal AND otd=:myCat', array(':myParams'=>1,':myVal'=>1,':myCat'=>$buf->otd));

Framework make erorr:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens. The SQL statement executed was: SELECT * FROM masters t WHERE prove=:myParams AND reject:=myVal AND otd=:myCat

If I remove middle param "AND show:=myVal", it works!?

2

You have an error in show=:myVal




$result = Masters::model()->findAll('prove=:myParams AND show=:myVal AND otd=:myCat', array(':myParams'=>1,':myVal'=>1,':myCat'=>$buf->otd));
3

+1