Can't migrate – any sql error

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

Profile photo of Mall Staff 184060.00 $tone January 4, 2018
Public

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.

#1

Please login or Register to Submit Answer

Written By

Comments