CiviCRM Community Forums (archive)

Hello I'm looking to find a list of database schema changes between 2.1.4 and 2.2.9.  We are trying the automatic upgrade between these two versions but having FOREIGN KEY RESTRAINTS issues.  The solution here: http://forum.civicrm.org/index.php/topic,4259.msg21599.html#msg21599 is appealing but requires some manual DB structure manipulation before and after the data migration from a 2.1.4 to a 2.2.9 schema.  Where in the code/docs do I find such a thing?

PS. Is there any way to turn OFF foreign key checks during the automatic upgrade process?

PPS. Running 5.0.90 mysql on this server.

The recommended way to deal with schema problems is to import a clean structure for your existing version (2.1.4) in a new db, then import data only from your live site, then upgrade using that clean schema + data. That ensures the structure you are starting out with is correct.

You can also trace the schema changes required from one revision/version to another in this folder:
/civicrm/CRM/Upgrade/Incremental/sql/

By exporting data only from my 2.1.4 database (which had originally been upgraded from a 1.7 database) and excluding the following tables from the export:

   a. custom field tables, any thing beginning with "civicrm_value" aka civicrm_value*
   b. civicrm_dupe_match
   c. civicrm_cache

Then uploading all this data, adding my custom fields tables, into a proper 2.1.4 schema helped, but it didn't solve the problem.  I was attempting to upgrade directly from 2.1.4 to 2.2.9, which was a mistake, even with a proper schema it still didn't work.

So I started over with 2.1.4 and upgraded to 2.2.0.  yay! this worked then I could upgrade through the 2.2 series all the way to 2.2.7 no problem.

thanks guys