Guest ebatule Posted September 7, 2011 Share Posted September 7, 2011 I was running 5.0.0 and had no problems. Than I updated to 5.0.1 and the site got slower. Turns out every website my hosting company was hosting got slower due to a rogue SQL Query. They ended up shutting down my site and said it was because of: removing tmp table - SELECT * FROM `CubeCart_inventory` WHERE `status` = '1' ORDER BY RAND() LIMIT 1. They said when ever I have the fix to it that they will turn my account back on and let me fix it. Any ideas? Will updating the the 5.0.3 fix this? Quote Link to comment Share on other sites More sharing options...
Robsta Posted September 7, 2011 Share Posted September 7, 2011 They are complaining about a query that gets one product from the inventory table? Well, I don't know if 5.0.3 fixes it (if it was a problem), but you should upgrade anyway and see how it goes. Quote Link to comment Share on other sites More sharing options...
Guest ebatule Posted September 7, 2011 Share Posted September 7, 2011 Yeah it doesn't make sense to me either. I have added extra product fields and there are about 50,000 products on there. I wonder if its just them though. Supposedly after suspending the site, their CPU went from 80% to 10%. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.