I am working on a 2.2.4 enterprise to 2.3.5-p2 migration.
I have gone through all steps such as composer, internal modules solutions, until setup:upgrade step. I searched for solution on the web, and tried to raise memory limits on MySQL server, but it doesn't work yet.
The upgrade ran smooth on a small development version of the database. But this is a huge client with +40k SKUs and some thousand monthly orders.
Anyone can help ?
Updating modules: Schema creation/updates: SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
SALES_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_IDFOREIGN KEY (
entity_id) ON DELETE SET NULL), query was: ALTER TABLE
entity_idint(10) UNSIGNED NOT NULL AUTO_INCREMEN....