CiviCRM Community Forums (archive)

I am trying to upgrade 2.1.3 to 2.2.7. I was getting errors when I tried to do it normally, so I'm now following my instructions in this forum post:

http://forum.civicrm.org/index.php/topic,4259.msg21599.html#msg21599

I have tried this multiple times (and on step 4 I have tried using both the original structure of 2.1 and 2.0). I have also tried this option: http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

Yet whenever I try to import my dumped data into my new DB that has the civicrm structure, I get this error:

#1452 - Cannot add or update a child row: a foreign key constraint fails (`nyscasa_ctest/civicrm_acl`, CONSTRAINT `FK_civicrm_acl_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))

OK, so then I tried adding SET FOREIGN_KEY_CHECKS=0; and SET FOREIGN_KEY_CHECKS=1; at the beginning and end of my dumped data respectively. When I do that and try to import it, then I get this error with the civicrm_contact table:

#1054 - Unknown column 'greeting_type' in 'field list'

Any ideas on what I should do next?

OK, I talked with deepak in irc and we determined there was an issue with my civicrm_domain table. I actually cleared out the config_backend column in my original install, refreshed that, then was able to clean up and migrate my db into a new structure. then the upgrade script worked