I’m just getting started with Yii and bought a book called Web Application Development with Yii and PHP. In there is a tutorial to build a webapp for projects. I successfully created the screens using Gii, created the table using the migration tool so I know I can connect to the database, but when I try to add a new project and hit the Create button, I get an exception error. The insert statement looks very strange so I’m not sure that is what my error is.
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1292 Incorrect datetime value: ‘’ for column ‘create_time’ at row 1. The SQL statement executed was: INSERT INTO tbl_project (name, description, create_time, create_user_id, update_time, update_user_id) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5)