Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-7418

Upgrade error- Database Error Code: Duplicate key name 'index_medium_id', 1061

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 3.3.2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Ran into some errors when attempting to upgrade to 3.3.2 or 3.3.3 from 3.0.3.

      DB Error: already exists
      Database Error Code: Duplicate key name 'index_medium_id', 1061

      Additional Details:
      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -5
      [message] => DB Error: already exists
      [mode] => 16
      [debug_info] => ALTER TABLE civicrm_activity
      ADD INDEX UI_source_record_id(source_record_id),
      ADD INDEX UI_activity_type_id (activity_type_id),
      ADD INDEX index_medium_id (medium_id),
      ADD INDEX index_is_current_revision (is_current_revision),
      ADD INDEX index_is_deleted (is_deleted) [nativecode=1061 ** Duplicate key name 'UI_activity_type_id']
      [type] => DB_Error
      [user_info] => ALTER TABLE civicrm_activity
      ADD INDEX UI_source_record_id(source_record_id),
      ADD INDEX UI_activity_type_id (activity_type_id),
      ADD INDEX index_medium_id (medium_id),
      ADD INDEX index_is_current_revision (is_current_revision),
      ADD INDEX index_is_deleted (is_deleted) [nativecode=1061 ** Duplicate key name 'UI_activity_type_id']
      [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_activity
      ADD INDEX UI_source_record_id(source_record_id),
      ADD INDEX UI_activity_type_id (activity_type_id),
      ADD INDEX index_medium_id (medium_id),
      ADD INDEX index_is_current_revision (is_current_revision),
      ADD INDEX index_is_deleted (is_deleted) [nativecode=1061 ** Duplicate key name 'UI_activity_type_id']"]
      )

      Tried dropping indexes as suggested in the civicrm forums, http://forum.civicrm.org/index.php/topic,18186.0.html, When doing so I received another error-
      Sorry. A non-recoverable error has occurred.
      One of parameters (value: 6,800.00) is not of the type Float

      Any suggestions?

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              c3 J. Scott
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: