Datetime - Githubissues

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'value' at row 1. The SQL statement executed was: INSERT INTO catalog_product_entity_datetime (attribute_id, store_id, entity_id, value) VALUES (:yp0, :yp1, :yp2, :yp3)

346 { 347 if($this->_connection->enableProfiling) 348 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute'); 349 350 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 351 $message=$e->getMessage(); 352 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.', 353 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 354 355 if(YII_DEBUG) 356 $message.='. The SQL statement executed was: '.$this->getText().$par; 357 358 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 359 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 360 } 361 }

Did you solve the problem yet? I have a similar problem when I was migrating the sales data. Following is my error message:

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'converted_at' at row 1. The SQL statement executed was: INSERT INTO quote (store_id, updated_at, is_active, is_virtual, is_multi_shipping, items_count, items_qty, orig_order_id, store_to_base_rate, store_to_quote_rate, grand_total, base_grand_total, customer_group_id, customer_note_notify, customer_is_guest, trigger_recollect, is_persistent, entity_id, created_at, converted_at, base_currency_code, store_currency_code, quote_currency_code, checkout_method, customer_id, customer_tax_class_id, remote_ip, applied_rule_ids, reserved_order_id, global_currency_code, base_to_global_rate, base_to_quote_rate, subtotal, base_subtotal, subtotal_with_discount, base_subtotal_with_discount, is_changed) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36)

C:\wamp\www\pacmall2\pub\migrate-data-tool\yii\db\CDbCommand.php(358)

ubertheme / module-ubdatamigration

Datetime #32