CDbCommand failed to execute the SQL statement

Yii 1.1 General Discussion
1

I’m getting this:

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘admin_level’ cannot be null. The SQL statement executed was: UPDATE users SET name=:yp0, email=:yp1, password=:yp2, admin_level=:yp3, newsletter=:yp4, birth_day=:yp5, birth_month=:yp6, birth_year=:yp7 WHERE users.id=‘1’

How to find out the value of yp0, yp1, … ?

2

just add

‘enableParamLogging’=>true,

in your db component configuration. In this example however it is quite simple to guess that :yp3 (admin_level) is NULL and it should not be…

3

redguy, your constant help is much appreciated!. Thank you very much!