Please make sure that your database user "magento" have full
It seems the order is trying to be insert in the "sales_order_grid" table, but the column
( grandtotal minus refunded amount) but both values separately (grand_total and total_refunded).
These tables have different columns (Magento2's table has 10 additional columns), and they can't be moved just like that. Is there any way to re- ...
Modifying the Default Magento 2 Sales Order Grid — Adding a Coupon Code Column - Magenable / Magento ecommerce consulting, ...
Deleting the file your-mysql-data-dirs/your-magento-store-schema-dirs/ sales_shipment_item.ibd seems to solve the issue in my case. (Magento 2.3.2, mySQL ...
Magento Commerce only
CRITICAL: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT ...
Then, using Magento 2 UI, let's add a new column to the standard grid. For that
Once you go through your magento 2 root directory and run. 1. php bin/magento
migrate:data vendor/magento/data-migration-tool/etc/