How to fix Invalid customer address id 1678 etc when trying to add to cart in Magento 2.1.5

It was fixed before by adding a foreign key field to "customer_address_id".

After adding the matrixrate module its showing the same error.

  • This issue is fixed by giving below command but how to fix it permanently UPDATE quote_address SET customer_address_id=NULL WHERE customer_address_id NOT IN ( SELECT entity_id FROM customer_address_entity WHERE parent_id = quote_address.customer_id ) ; – Sashi Mar 11 at 19:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.