CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘current_timestamp()’ for column ‘created_time’ at row 1. The SQL statement executed was: INSERT INTO `ub_migrate_map_step_3` (`can_reset`, `created_time`, `offset`, `entity_name`, `m1_id`, `m2_id`, `m2_model_class`, `m2_key_field`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
How to fix it?
3 answers
Hi there,
CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘current_timestamp()’ for column ‘created_time’ at row 1.
Seem you are using latest version of MariaDB engine. To solve that issue you could do with steps as followings:
Step 1: Download the php file at here
Step 2: Upload replace downloaded file to the file at path: pub/ub-tool/yii-1.1.19/db/schema/mysql/CMysqlColumnSchema.php
Once done, you could continue with our tool.
Regards,
Mall.
Ok, now it works bu t there is new problem at step 7
https://www.ubertheme.com/question/error-at-step-7/
Hi there,
Yeah, please followup my answer on that question now.
Regards,
Mall.