Hey everyone, I am upgrading from Joomla 1.5 to 1.7 using jUpgrade.
When I install CB on my new Joomla 1.7 site, I get the following errors in red:
Installation Process:
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'fieldid_ordering' SQL=ALTER TABLE `j17_comprofiler_field_values` ADD INDEX fieldid_ordering (`fieldid`, `ordering` );
SQL =
ALTER TABLE `#__comprofiler_field_values` ADD INDEX fieldid_ordering (`fieldid`, `ordering` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'tabid_pub_prof_order' SQL=ALTER TABLE `j17_comprofiler_fields` ADD INDEX `tabid_pub_prof_order` ( `tabid` , `published` , `profile` , `ordering` );
SQL =
ALTER TABLE `#__comprofiler_fields` ADD INDEX `tabid_pub_prof_order` ( `tabid` , `published` , `profile` , `ordering` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'readonly_published_tabid' SQL=ALTER TABLE `j17_comprofiler_fields` ADD INDEX `readonly_published_tabid` ( `readonly` , `published` , `tabid` );
SQL =
ALTER TABLE `#__comprofiler_fields` ADD INDEX `readonly_published_tabid` ( `readonly` , `published` , `tabid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'registration_published_order' SQL=ALTER TABLE `j17_comprofiler_fields` ADD INDEX `registration_published_order` ( `registration` , `published` , `ordering` );
SQL =
ALTER TABLE `#__comprofiler_fields` ADD INDEX `registration_published_order` ( `registration` , `published` , `ordering` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'pamr' SQL=ALTER TABLE `j17_comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
SQL =
ALTER TABLE `#__comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'aprm' SQL=ALTER TABLE `j17_comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
SQL =
ALTER TABLE `#__comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'membrefid' SQL=ALTER TABLE `j17_comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` );
SQL =
ALTER TABLE `#__comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'type_pub_order' SQL=ALTER TABLE `j17_comprofiler_plugin` ADD INDEX `type_pub_order` ( `type` , `published` , `ordering` );
SQL =
ALTER TABLE `#__comprofiler_plugin` ADD INDEX `type_pub_order` ( `type` , `published` , `ordering` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'enabled_position_ordering' SQL=ALTER TABLE `j17_comprofiler_tabs` ADD INDEX `enabled_position_ordering` ( `enabled` , `position` , `ordering` );
SQL =
ALTER TABLE `#__comprofiler_tabs` ADD INDEX `enabled_position_ordering` ( `enabled` , `position` , `ordering` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'pub_ordering' SQL=ALTER TABLE `j17_comprofiler_lists` ADD INDEX `pub_ordering` ( `published` , `ordering` );
SQL =
ALTER TABLE `#__comprofiler_lists` ADD INDEX `pub_ordering` ( `published` , `ordering` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'default_published' SQL=ALTER TABLE `j17_comprofiler_lists` ADD INDEX `default_published` ( `default` , `published` );
SQL =
ALTER TABLE `#__comprofiler_lists` ADD INDEX `default_published` ( `default` , `published` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'status_user_date' SQL=ALTER TABLE `j17_comprofiler_userreports` ADD INDEX `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` );
SQL =
ALTER TABLE `#__comprofiler_userreports` ADD INDEX `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'reportedbyuser_ondate' SQL=ALTER TABLE `j17_comprofiler_userreports` ADD INDEX `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` );
SQL =
ALTER TABLE `#__comprofiler_userreports` ADD INDEX `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'lastview' SQL=ALTER TABLE `j17_comprofiler_views` ADD INDEX `lastview` ( `lastview` );
SQL =
ALTER TABLE `#__comprofiler_views` ADD INDEX `lastview` ( `lastview` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061
Duplicate key name 'profile_id_lastview' SQL=ALTER TABLE `j17_comprofiler_views` ADD INDEX `profile_id_lastview` (`profile_id`,`lastview`);
SQL =
ALTER TABLE `#__comprofiler_views` ADD INDEX `profile_id_lastview` (`profile_id`,`lastview`);
Could someone help me troubleshoot this?
krileon
