On 11/11/2019 at 11:01 AM, musicmaster said:Some additional thoughts:
- when you check in the intermediate shops whether ASM works it might help to pinpoint the problem.
That's a great idea, I have done the process again and the new shop running 1.6.1.1 with copied data from the old shop worked fine. Then I upgraded that shop to 1.6.1.24 in order to use php 7.1 for the upgrade to PS 1.7. I thought it might be the reason why the upgrade to 1.7 failed, and it was the case, this time the upgrade was able to finish successfully with warnings detected during upgrade.
On that shop, I can still see the combinations on the product page but the stocks page is not working, the page is displayed but the content loads forever until I get an Internal Server Error popup. I checked the tables for ps_stock, ps_stock_available and ps_stock_mvt, the tables are similar between a fresh 1.7 shop and the updated one. The only differences I could find are that 1.7 does not use ps_stock anymore and "depends_on_stock" in ps_stock_available is set to 0 by default instead of 1 (both of which are normal since there is no ASM in 1.7). I tried removing all entries from stock and setting all stocks in ps_stock_available to 0 but I still can't load the page.
Since I get no error message it is hard to understand why the query hangs just on the Stocks page but I have noticed that this page is using the BO API instead of querying the DB directly. I know that this is not really related to your script but do you know of any other tables that are involved in the stock management? Once I copy that shop to a fresh 1.7.6.1 shop, I can't even see the combinations on the product's pages.