vcpawate
commented
8 years ago please let me know how can I resolve the issue, I am getting this error while importing products
Open vcpawate opened 8 years ago
vcpawate
commented
8 years ago please let me know how can I resolve the issue, I am getting this error while importing products
CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'low_stock_date' at row 1. The SQL statement executed was: INSERT INTOcataloginventory_stock_item(product_id,stock_id,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,qty,low_stock_date,notify_stock_qty`) 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)/opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/db/CDbCommand.php(358)
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 } 362 363 /* 364 * Executes the SQL statement and returns query result. 365 * This method is for executing an SQL query that returns result set. 366 * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative 367 * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing 368 * them in this way can improve the performance. Note that if you pass parameters in this way, 369 * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa. 370 \ Please also note that all values are treated as strings in this case, if you need them to be handled as`
Stack Trace
`Stack Trace
0
1
2
– /opt/bitnami/apps/magento/htdocs/pub/ub-tool/protected/controllers/MigrateController.php(1371): CActiveRecord->save() 1366 $stock_item2->$key = $stock_item->$key; 1367 } 1368 } 1369 //this field is new in Magento 2 1370 $stock_item2->website_id = $website_id; 1371 $stock_item2->save(); 1372 } 1373 } 1374 } 1375 } 1376 }
3
4
5
6
7
8
9
10
– /opt/bitnami/apps/magento/htdocs/pub/ub-tool/index.php(13): CApplication->run() 08 // change the following paths if necessary 09 $yii=dirname(FILE).'/yii/yii.php'; 10 $config=dirname(FILE).'/protected/config/main.php'; 11 12 require_once($yii); 13 Yii::createWebApplication($config)->run();`