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
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.
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
Hi Mall,
can u please help me how can we assign normal value of magento 1
please help us as soon as possible
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