Inventory totals lost v1.5

[rightminddesign]

I know this was an issue in the BETA, but I had hoped it would be fixed for the stable. In trying to upgrade from v1.4, all of my client's inventory totals are still being lost.

Was a workaround ever determined for this?

[firejdl]

to solve this problem i added the following SQL code to the upgrade script.

CREATE TABLE `REL_Products__Warehouses` (
`record_number` int(11) NOT NULL auto_increment,
`Table_1` int(11) NOT NULL default '0',
`Table_2` int(11) NOT NULL default '0',
`Position` int(11) NOT NULL default '0',
`Stock` int(255) NOT NULL default '0',
PRIMARY KEY (`record_number`)
) TYPE=MyISAM ;

REPLACE INTO `REL_Products__Warehouses` (`Table_1`, `Table_2`, `Stock`)
SELECT Products.record_number, '1', Products.Number_in_Stock
FROM `Products`;

in the script somewhere is already the "CREATE TABLE `REL_Products_Warehouses`" command, but the second is NOT. you just have to make sure to do these two commands BEFORE the line:

ALTER TABLE `Products` DROP `Number_in_Stock`;

[don't be afraid to move things around if you need to. just make sure to back everything up first.]