CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Error upgrading 2.1.3 to 2.2.7
Pages: [1]

Author Topic: Error upgrading 2.1.3 to 2.2.7  (Read 1078 times)

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Error upgrading 2.1.3 to 2.2.7
July 13, 2009, 10:38:52 am
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????


emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Error upgrading 2.1.3 to 2.2.7
July 15, 2009, 04:21:45 am
anyone? anyone?

sorry to bump this...i have a deadline to get this upgraded by today. any help would be sincerely appreciated!!

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Error upgrading 2.1.3 to 2.2.7
July 15, 2009, 07:18:18 am
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 :)

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Error upgrading 2.1.3 to 2.2.7

This forum was archived on 2017-11-26.