Hey,

I'm in the process of upgrading a 5.5.1CE to a 6.0.4CE and so far the process goes through the commit stage and then during the summary stage (when it's running database scripts) it starts spitting out errors as follows:

Code:
Query Failed:ALTER TABLE ps_claims add column ClaimID varchar(14) NULL , add column SubDate date NULL , add column Status varchar(1000) NULL , add column PersonName varchar(1000) NULL , add column Telephone varchar(1000) NULL , add column EMail varchar(1000) NULL , add column Recipient varchar(1000) NULL , add column Address1 varchar(1000) NULL , add column Address2 varchar(1000) NULL , add column CityState varchar(1000) NULL , add column ShipDate date NULL , add column TrackingID varchar(1000) NULL , add column Products varchar(1000) NULL , add column ProdValue decimal(20) NULL , add column LossType varchar(1000) NULL , add column ClaimBody varchar(1000) NULL , add column AmountPaid decimal(20) NULL ::MySQL error 1060: Duplicate column name 'ClaimID'
So, because I'm doing the upgrade on a development server, I go ahead and just drop the columns, and it then proceeds to yell at me for every column in the table. So I drop the table, and it then goes back in - makes the table again - and then starts yelling me about there being duplicate columns again. This sets up an obvious loop which I can't get out of. Can anyone at all help me out with this? I'd like to get this thing up and running if at all possible, right now I'm completely stuck as anytime I pop back into the upgrade wizard it just tries to perform the summary again.

Thanks for any help!

Mike