sales_flat_order_grid works like an index to make displaying, sorting and filtering in the order grid faster and not blocking the real order tables.
Eventually i had to write a shell script to fix this. I'm sharing this small script that will reindex the table in case anyone has the same problem and ...
The only tables which had changed was sales_flat_order_grid as I'd expected.
It's work for me using insertion like this $entity_id =1; $entity_type_id =4; $ attribute_id = 92; $value = 'red'; $store_id =1; $resource ...
A shell script which allows you to fix data inconsistency between sales_flat_order and sales_flat_order_grid database tables in your Magento.
The more commonly discovered table is sales_flat_order_grid . This is the table that's used to display grid information in the Magento admin.
denied to user 'magento'@'localhost' for table 'sales_flat_order_grid', ...
I am migrating from Magento 1.9.1.0 to Magento 2.3.1 but I keep getting
By default “Sales > Orders” grid uses the “sales_flat_order_grid” table for rendering. This table is basically a redundant subset of “sales_flat_order ...
email_sent` FROM `sales_flat_order_grid` AS `main_table` LEFT JOIN ` sales_flat_order_status_history` AS `ordercomment_table` ON ...