Jump to content

[1.7.6.2] Stock management crashes


redactuk

Recommended Posts

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

Edited by redactuk (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...