[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.

ALTER TABLE xcart_products ADD on_sale binary(1) NOT NULL default 'N' AFTER title_tag;
ALTER TABLE xcart_products ADD mark_as_new enum('S','A','N') NOT NULL default 'N' AFTER on_sale;
ALTER TABLE xcart_products ADD show_as_new_from int(11) NOT NULL default '0' AFTER mark_as_new;
ALTER TABLE xcart_products ADD show_as_new_to int(11) NOT NULL default '0' AFTER show_as_new_from;
ALTER TABLE xcart_products ADD key sa (show_as_new_from, add_date);
ALTER TABLE xcart_products ADD key on_sale (on_sale);
ALTER TABLE xcart_categories ADD show_new_arrivals enum('Y','N') NOT NULL default 'Y' AFTER title_tag;