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) »
  • trying to upgrade frrom 2.0.7
Pages: [1]

Author Topic: trying to upgrade frrom 2.0.7  (Read 701 times)

sraisz

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
    • sambandha.net
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
trying to upgrade frrom 2.0.7
May 25, 2011, 05:42:45 pm
I'm trying to move an old civicrm db from version 2.0.7 to 3.4.1

I understand the first step is toi upgrade to 2.1 but I get this error:

Quote
DB Error: already exists

Database Error Code: Duplicate entry '10000' for key 1, 1062

Return to home page.

Error Details:
Code: [Select]
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(10000, 1107, "CI", "Carbonia-Iglesias"),
(10001, 1107, "OT", "Olbia-Tempio"),
(10002, 1107, "VS", "Medio Campidano"),
(10003, 1107, "OG", "Ogliastra") [nativecode=1062 ** Duplicate entry '10000' for key 1]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(10000, 1107, "CI", "Carbonia-Iglesias"),
(10001, 1107, "OT", "Olbia-Tempio"),
(10002, 1107, "VS", "Medio Campidano"),
(10003, 1107, "OG", "Ogliastra") [nativecode=1062 ** Duplicate entry '10000' for key 1]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(10000, 1107, "CI", "Carbonia-Iglesias"),
(10001, 1107, "OT", "Olbia-Tempio"),
(10002, 1107, "VS", "Medio Campidano"),
(10003, 1107, "OG", "Ogliastra") [nativecode=1062 ** Duplicate entry '10000' for key 1]"]
)

I tried truncating this table before running ther update script but it didn't help.

I can't get past this.

Any suggestions?

I really need help on this.
« Last Edit: May 31, 2011, 05:47:24 pm by sraisz »

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

This forum was archived on 2017-11-26.