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) »
  • 1.9 to 2.0 upgrade
Pages: [1]

Author Topic: 1.9 to 2.0 upgrade  (Read 1411 times)

shunshifu

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
1.9 to 2.0 upgrade
February 06, 2010, 01:45:45 pm
I'm trying to upgrade civicrm from 1.9 to 2.0 (and beyond once I get that done)

Running drupal 5.1 (will be upgrading that to 6)

In following the instructions at
http://wiki.civicrm.org/confluence/display/CRMDOC21/Upgrade+Drupal+Sites+to+2.0

On step 4 when trying to import the data dump I get the following error.

Code: [Select]
SQL query:

INSERT INTO `civicrm_location` (`id`, `entity_table`, `entity_id`, `location_type_id`, `is_primary`, `name`) VALUES (1249, 'civicrm_contact', 1645, 1, 1, NULL), (1250, 'civicrm_contact', 1646, 1, 1, NULL), (1251, 'civicrm_contact', 1647, 1, 1, ''), (1252, 'civicrm_contact', 1648, 1, 1, NULL), (1253, 'civicrm_contact', 1649, 1, 1, NULL), (1254, 'civicrm_contact', 1650, 1, 1, NULL), (1255, 'civicrm_contact', 1651, 1, 1, NULL), (1256, 'civicrm_contact', 1652, 1, 1, ''), (1257, 'civicrm_contact', 1653, 1, 1, ''), (1258, 'civicrm_contact', 1654, 1, 1, NULL), (1259, 'civicrm_contact', 1655, 1, 1, ''), (1260, 'civicrm_contact', 1656, 1, 1, ''), (1261, 'civicrm_contact', 1657, 1, 1, NULL), (1262, 'civicrm_contact', 1658, 1, 1, NULL), (1263, 'civicrm_contact', 1659, 1, 1, ''), (1264, 'civicrm_contact', 1660, 1, 1, NULL), (1265, 'civicrm_contact', 1661, 1, 1, NULL), (1266, 'civicrm_contact', 1662, 1, 1, NULL), (1267, 'civicrm_contact', 1664, 1, 1, NULL), (1268, 'civicrm_contact', 1665, 1, 1, NU[...]

MySQL said: Documentation
#1062 - Duplicate entry 'civicrm_contact-900-4' for key 2


I've searched extensively for a few days but I just can't seem to get past this.

If I ignore it and try to complete the upgrade it fails at stage three of the database upgrade (location)

I sure would appreciate some help.

Phil

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: 1.9 to 2.0 upgrade
February 06, 2010, 10:26:29 pm

seems like your location table might be inconsistent. Your DB might have been MyISAM at some stage

your best bet might be to hire someone from http://civicrm.org/professional/. We dont support 1.9 / 2.x anymore. sorry

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

shunshifu

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
Re: 1.9 to 2.0 upgrade
February 07, 2010, 10:41:14 am
I'm not sure what MyIsam is.

Yes there's certainly something wrong with the location table. Some time ago the selection box for states (used at registration) went crazy. It started showing all of the states rather than selecting from US states. I am not able to add or remove available countries.

I have contacted one of the services but at this point we are a tapped out non-profit. So I believe I'm at a loss.

DLBaker

  • Guest
Re: 1.9 to 2.0 upgrade
March 30, 2010, 02:34:21 pm
I had this problem too.

I solved it by running the SQL script that clears the location info from the DB, then going to a specific page that rebuilds it specifically for your machine. If you search or look for references to moving your civic install to another server you should find it. Some of the pages that were referenced didn't re-create the data correctly, however, the one that includes an index.php as part of the url did to the trick.

Once you clear and rebuild the info via the url, go into the control panel for civic and re-select the countries you want to use / See.


I wish I could remember clearer information but that should at least get you on the right path.

- Dan.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 1.9 to 2.0 upgrade

This forum was archived on 2017-11-26.