Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Trying to install 1.3.2.2 database locally, getting foreign key constraint errors
 
creativelifeform
Sr. Member
 
Avatar
Total Posts:  77
Joined:  2009-06-22
Sydney, Australia
 

Okay so I have a fairly massive database to install locally, it’s around 300MB.

I’m using bigdump.php (http://www.ozerov.de/bigdump/) to do this, and everything is fine until I run into the following error

Error at the line 6487ADD CONSTRAINT `FK_DIRECTORY_REGION_NAME_REGIONFOREIGN KEY (`region_id`) REFERENCES `directory_country_region` (`region_id`) ON DELETE CASCADE ON UPDATE CASCADE;
QueryALTER TABLE `directory_country_region_name`
ADD CONSTRAINT `FK_DIRECTORY_REGION_NAME_REGIONFOREIGN KEY (`region_id`) REFERENCES `directory_country_region` (`region_id`) ON DELETE CASCADE ON UPDATE CASCADE
MySQL
Cannot add or update a child rowa foreign key constraint fails (`magento`.`#sql-1ae4_6b`, CONSTRAINT `FK_DIRECTORY_REGION_NAME_REGIONFOREIGN KEY (`region_id`) REFERENCES `directory_country_region` (`region_id`) ON DELETE CASCADE ON UPDATE CASCADE)

I have read this page http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/restoring_a_backup_of_a_magento_database and done what it asks, yet I still get this error. Has anyone else observed this problem?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top