0

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 ?

Thanks !!!

Updating modules: Schema creation/updates: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magento.#sql-1c_10, CONSTRAINT SALES_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID FOREIGN KEY (customer_id) REFERENCES customer_entity (entity_id) ON DELETE SET NULL), query was: ALTER TABLE sales_order MODIFY COLUMN entity_id int(10) UNSIGNED NOT NULL AUTO_INCREMEN....

Improve this question
1
  • We are using Azure, Magento needs MySQL 5.7. It looks like the server runs 5.7 but this thing 'connector' responds as 5.6. I don't know if there might be the error.
    – Gustavo Ulyssea
    Aug 20, 2020 at 14:15

1 Answer 1

Reset to default
0

@Gustavo did you find a solution. I am also having the same issue when upgrading from Magento 2.3.2 to Magento 2.3.5-p1.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.