upgrade from 1.4.4.1 to 1.4.6.2 get sql error

[Melinda]

When going from 1.4.4.1 to 1.4.6.2 sql error using the updater I get this error:

ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`)

(1062) Duplicate entry '1' for key 'PRIMARY'

 

 

When I manually added this key it ended up being an INDEX key and NOT the PRIMARY KEY.

I ran a fresh install and it shows:

 

PRIMARY BTREE Yes No id_country 244 A

 

On the manual change database it shows:

id_country BTREE No No id_country 244 A

 

I tried to run the sql again and the id_country error one disappears with the same error message and will not let me add this at all.

ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`);

 

Any help is greatly appreciated.

 

Thanks!