[Ksenia]

Originally Posted by elmirage001

I've now successfully completed a database upgrade from 4.4.5 --> 4.5.0 and then used the upgrade pack from 4.5.0 --> 4.6.0 This morning I did an upgrade of my dev 4.5.5 site to 4.6.0 and both upgrades processed smoothly except for issues with the Hot Products Module. I have not experienced any of the issues the other posters have described. (patch applied)

The issue with the Hot Products Module involved the SQL which keeps the upgrade from fully completing. My files patched fine and then received the sql patch failed.

The x-hot-products.sql tries to add where they already exist so it fails. To get the SQL patch to finish I had to remove the following. I had used the 4.5.5 x-hot-products_remove but it does not remove them either.

Paul, unfortunately we can not tell for sure how exactly you're upgrading the store, but we assume that
*you have X-Cart Gold ( not GoldPlus where the module is available out of box) so the module is a an add-on.
* you're working with a dev copy ( and thus not afraid to lose any module data/settings).


You may now have 2 options:

OPTION 1

download and unarchive 'x-hot-products.4.6.0.tgz' in the store folder, as usually, run 'install-x-hot-products.php', select 'reinstall'. This procedure will remove the columns you list and recreate them.

OPTION 2
Apply the following SQL patch via 'patch/upgrade center':

ALTER TABLE xcart_products DROP COLUMN on_sale;
ALTER TABLE xcart_products DROP COLUMN mark_as_new;
ALTER TABLE xcart_products DROP COLUMN show_as_new_from;
ALTER TABLE xcart_products DROP COLUMN show_as_new_to;
ALTER TABLE xcart_products DROP KEY sa;
ALTER TABLE xcart_products DROP KEY on_sale;
ALTER TABLE xcart_categories DROP COLUMN show_new_arrivals; 

After that execute 'install-x-hot-products.php'(from v.4.6)

Note that both options will remove the columns and thus data in them. Module will be reinstalled from scratch, previous data may be lost. If you have some data that need to be preserved, you may contact our engineers via HelpDesk account and they'll give detailed instructions on how to patch the store manually AND not affect any module data.

Thank you and have a great day!