Duplicate key error while upgrade to 6

[kingikra]

Hi,

I cannot upgrade my sugarCRM from 4.5.1 to 5 or above because of an old candidates module we bought long time ago so my boss decided to uninstall the problematic module and upgrade without it.
Whatever I've tried to do, when I got to the point of upgrading from 5.5.1 to 6.0.2, I got the same error:
Query Failed:ALTER TABLE jcrmtime modify column date_entered datetime NULL , modify column date_modified datetime NULL , modify column date date NULL , modify column invoice_id char(36) NULL , ADD INDEX JCRMTime_speed_index (assigned_user_id, date, case_id, account_id)::MySQL error 1061: Duplicate key name 'JCRMTime_speed_index'

I did all my upgrades using the silent upgrade. The second time I used the admin->repair to repair relationships. The third time I've tried to repair the database after the first upgrade from 4.5.1 to 5.1.0 and found out the the same error shows up. I have fixed the error message by running:
ALTER TABLE jcrmtime drop key JCRMTime_speed_index;

After running the above command it looked like the problem had gone away but again, while trying to silent upgrade from 5.5.1 to 6.0.2 the same error message appeared.

Can anyone assist?

Thanks
Gil

[mbalu]

I got the same error message while upgrading. Deleting the key does not seem to help.

I believe that this module is no longer supported. Would anybody be kind enough to post a step-by-step instruction on how to remove this module. (or point to a location where instructions are available)?

Thanks in advance.
MB

[mbalu]

A lot of people seem to be getting this message in the CE versions. We would appreciate if anybody could post a solution to this problem.