Bug upgrading from 1.2.5.0 to 1.4.9.0

[dhcmega]

Hi all this is my first post here, and my first contact with PS. I hope I am not getting this wrong.

 

I am trying to upgrade a PS 1.2.5.0 to 1.6.lastest. The problem is that in the middle of the process I get an Error 500.

 

Checking the log I see this:

*ERROR*         2016/09/06 - 16:24:58: PHP error: /* PHP:gridextjs_deprecated(); */

*ERROR*         2016/09/06 - 16:24:58:
*ERROR*         2016/09/06 - 16:25:03: SQL query:
ALTER TABLE `ps_category_product` DROP INDEX `category_product_index`, ADD PRIMARY KEY (`id_category`, `id_product`)
*ERROR*         2016/09/06 - 16:25:03: SQL error:
Can't DROP 'category_product_index'; check that column/key exists

And checking the sql files that run the upgrades of the database, I've found this:

1.2.3.0.sql:ALTER TABLE `PREFIX_category_product` ADD INDEX (`id_product`);
1.4.9.0.sql:ALTER TABLE `PREFIX_category_product` DROP INDEX `category_product_index`, ADD PRIMARY KEY (`id_category`, `id_product`);

I have checked on the table the only index is the one created at 1.2.3.0, so the line that DROPs that index breaks

 

I think that there is a error here, I will fix the 1.4.9.0 file so I can run the updated.

 

Thanks!

 

 

Edited September 6, 2016 by dhcmega (see edit history)

[bellini13]

well, you can try adding the index so that it can be removed during the upgrade

or, you can change the upgrade scripts so that it does not try to drop the index

[dhcmega]

yes, I have changed the upgrade file so it makes sense, I was just letting people know so it may help someone else. thanks.