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?