mardi 12 juillet 2016

1452; Cannot add or update a child row: a foreign key constraint fails

How do I solve this?
Am importing a csv file through Store Manager Magento but I received this error:

1452; Cannot add or update a child row: a foreign key constraint fails (ccmcnige_f3june.customer_entity,
CONSTRAINT >FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_IDFOREIGN KEY (store_id)<br> >REFERENCEScore_store(store_id`) ON DELETE SET NULL ON UPDATE CAS) UPDATE customer_entity SET store_id='1' WHERE entity_id = 3;

I don't know a thing about sql. I have access to phpmyadmin by the way.

Thank you.

Aucun commentaire:

Enregistrer un commentaire