Yii Framework Forum

CDbCommand failed to execute the SQL statement 42S22


(laruniq) #1

When i try to access this link on my website http://fondation-zeitgeist.com/live/profil/Valentin/MBAPPE/id/1

It shows me an error

“CDBcommand failed to execute SQL”

CDbCommand n'a pas pu exécuter la commande SQL : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'notread' in 'where clause'. The SQL statement executed was: SELECT `t`.`dest` AS `c`, COUNT(*) AS `s` FROM `pe_mp` `t` WHERE (valid = 1 and notread = 1) AND (`t`.`dest`=1) GROUP BY `t`.`dest`

But i don’t know what to do exactly with this and where to do this. I created my tables with phpmyadmin;

Thanks


(laruniq) #2

I have Resolved the problem!