Frequently Asked Questions

Foreign Key
Last Updated 4 years ago

Problem
I have installed "Collins Harper Canada Post 2.0", in the onepage checkout, after I choose my shipping method (the Canada Post shipping methods are listed as supposed to), I get redirected to the cart.

The response I get from "checkout/onepage/saveShippingMethod/" is 503 Service Unavailable and the error message from the report is "SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`dev95551_mage630`.`mg_ch_canadapost_quote_param`, CONSTRAINT `mg_ch_canadapost_quote_param_ibfk_1` FOREIGN KEY (`magento_quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCA)".

Answer
Recreate the foreign key reference.

Please Wait!

Please wait... it will take a second!