CiviCRM Community Forums (archive)

I was also experiencing a foreign key problem, pretty much like http://forum.civicrm.org/index.php/topic,96.0.html . My problem was occuring when importing the 1.6 data (after running the upgrade script) into a 1.7 db, having installed its tables using the civicrm_41.mysql script. The import of the dumpfile didn't work because of the foreign key error on the civicrm_address table:

|#1452 - Cannot add or update a child row: a foreign key constraint fails (`db/civicrm_address`, CONSTRAINT `FK_civicrm_address_location_id` FOREIGN KEY (`location_id`) REFERENCES `civicrm_location` (`id`)) |

I applied the fix described in the mentioned forum post (http://forum.civicrm.org/index.php/topic,96.0.html):

- instead of dumping just the 1.6 data after running the upgrade script, dumping structure + data
- importing the dump

Like this, my civicrm 1.7 install works fine so far. I'm asking myself though if this is a good way to do it, since I didn't install 1.7 from scratch. Does it make a difference whether I install the 1.7 db scheme or run the upgraded 1.6 one?

Thank you.