Frequently Asked Questions

Foreign Key

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.

Attachments: canpost2_fkey_fix.zip (3.1 kb) 


 Last updated Tue, Jul 8 2014 12:31pm

Be sure to browse our E-commerce Questions Section (FAQs), before opening a ticket.

Please Wait!

Please wait... it will take a second!