Jump to content

Edit History

redactuk

redactuk

Hi folks

Testing an upgraded shop (from 1.6 to 1.7) on local WAMP server. Upgrade has gone well and everything seems to be working, except accessing Catalog > Stocks in admin area crashes/freezes PS (and requires WAMP restart). I've enabled debug mode but that doesn't show any errors just multiple failed or timed out calls to /index.php/api/stock.

Now I'm guessing that main Stock management page is doing query that involves ps_stock_available table, and my hunch is this is struggling as there are 38k records.

So my first step, is can anyone show me how I can see what the main query being run in default Stock management page is? If anyone can reply with SQL with that would be awesome. At least then I can run query on database and see if it's an optimisation issue or perhaps local environment resources issue.

Thanks

redactuk

redactuk

Hi folks

Testing an upgraded shop (from 1.6 to 1.7) on local WAMP server. Upgrade has gone well and everything seems to be working, except accessing Catalog > Stocks in admin area crashes/freezes PS (and requires WAMP restart). I've enabled debug mode but that doesn't show any errors just multiple failed or timed out calls to /index.php/api/stock.

Now I'm guessing that main Stock management page is doing querty that involves ps_stock_available table, and my hunch is this is snuggling as we have over 38k records in there.

So my first step, is can anyone show me how I can see what the main query being run in default Stock management page is? If anyone can reply with SAQL with that would be awesome. At least then I can run query on database and see if it's an optimisation issue or perhaps local environment resources issue.

Thanks

×
×
  • Create New...