Migration Error

Hi Ubertheme

We have migration m1 to m2 all step working fine except 7 sales data are not migrated ites gettting error like this
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field ‘delivery_date’ doesn’t have a default value. The SQL statement executed was: INSERT INTO `sales_order_grid` (`entity_id`, `status`, `store_id`, `store_name`, `customer_id`, `base_grand_total`, `grand_total`, `increment_id`, `base_currency_code`, `order_currency_code`, `shipping_name`, `billing_name`, `created_at`, `updated_at`, `customer_email`, `customer_group`, `customer_name`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16)

please help us as soon as possible

4 answers

Profile photo of Mall Staff 184060.00 $tone June 17, 2019
Public

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field ‘delivery_date’ doesn’t have a default value. The SQL statement executed was: INSERT INTO `sales_order_grid` (`entity_id`, `status`, `store_id`, `store_name`, `customer_id`, 

The ‘delivery_date’ is a custom field in table ‘sales_order_grid’ it may added by a third-party extension which you installed to your site. You should set a default value for that field to solve the issue you mentioned in data migration context.
Regards,
Mall.

#1
Profile photo of ubdev Staff 98310.00 $tone June 17, 2019
Public

Hi Harsh Bhatt,
Please let us know if you have another paid profile at Ubertheme? We could not keep track of your purchase. 
Our technical support requires active subscription though. 
Regards,
Ubertheme team

#2
Profile photo of ubdev Staff 98310.00 $tone June 17, 2019
Public

Hi Harsh Bhatt,
Please help to answer our question regarding your subscription, as mentioned in our reply #2. 
Thanks for your understanding.
Regards,
Ubertheme team

#4

Please login or Register to Submit Answer

Written By

Comments