update from 1.4.3 to 1.4.7.3 SQL errors

[adamus007p]

update from 1.4.3 to 1.4.7.1 (svn14265) SQL errors

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

(1091) Can't DROP 'id_compare_product'; check that column/key exists

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`)

(1060) Duplicate column name 'id_compare'

when I was update 1.4.7.0 do 1.4.7.2 there was about 13 SQL errors

unfortunately when I updated to 1.4.7.0. there is an error http://forge.prestashop.com/browse/PSCFI-5333

update do PS. 1.4.7.0 was OK but there is an error SCFI-5333 and I am not able to add product to card.

so nothing works, I have to stay with 1.4.3

 

another try to update presta, this time useing sbable last version 1472.

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

(1091) Can't DROP 'id_compare_product'; check that column/key exists

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`)

(1060) Duplicate column name 'id_compare'

same errors. any help?

 

upgrade from 1.4.3 to 1.4.7.2 (svn 14465), here is a same error:

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

(1091) Can't DROP 'id_compare_product'; check that column/key exists

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`)

(1060) Duplicate column name 'id_compare'

 

I have normal configuration and default shop settings and theme.

I made several test to update PS form 1.4.3 to 1.4.6.2

There are errors:

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

(1091) Can't DROP 'id_compare_product'; check that column/key exists

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`)

(1060) Duplicate column name 'id_compare'

update to PS to 1.4.5.1 is OK, no errors, it mean that definetely there is a bug in instalator/updater.

I will use 1.4.6.1 to test it and I will you know.

 

You was testing to 1.4.6.0 and it is possible that all updates will be OK.

I will try to localize where the bug exist.

To test I am using PS from http://www.prestashop.com/en/developers-versions

Could you sent me 1.4.6.0 - your installer version to test my shop regards update? Thank you.

 

upgrade 1.4.3 to 1.4.6.1 failed

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

(1091) Can't DROP 'id_compare_product'; check that column/key exists

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`)

(1060) Duplicate column name 'id_compare'

resume:

update 1.4.3 to 1.4.5.1 OK

update to 1.4.6.1, 1.4.6.2, 1.4.7.0, 1.4.7.2, 1.4.7.3 failed, still same errors like above

between 1.4.5.1 and 1.4.6.1 the is a SQL bug in installed,

 

/////

 

http://forge.prestashop.com/browse/PSCFI-5332

 

any help?

[nilady]

same problem with me

[adamus007p]

nilady please write here that you have same problem: http://forge.prestashop.com/browse/PSCFI-5332

[adamus007p]

please tell me why this errors occurs and how to fix it?