New Zenner
- Join Date:
- Nov 2008
- Posts:
- 33
- Plugin Contributions:
- 0
HOSTING ACCOUNT SUSPENSION for high system resource usage with reward_status mod
My hosting company has been suspending my account when I edit or add new products in admin. They said it is because there are hundreds of lines of queries. I have attached the queries log, they said if the issue continues my account may be suspended again and possibly require an upgrade to a virtual private server.
How can I reduce the queries to prevent having my account suspended?
Their response is below, thank you in advance.
System administration was forced to suspend your site in an emergency to prevent server and system overloads. The direct cause of this issue is not clear at this time; however, when your account is suspended, the server stabilizes immediately.
Here's a very small excerpt from the log:
9935846 Query SELECT * FROM zen_reward_status_track WHERE orders_id='4625' ORDER BY date DESC LIMIT 1
9935846 Query SELECT * FROM zen_orders_status WHERE language_id='1' ORDER BY orders_status_id
9935846 Query SELECT * FROM zen_reward_status_track WHERE orders_id='6026' ORDER BY date DESC LIMIT 1
9935846 Query SELECT * FROM zen_orders_status WHERE language_id='1' ORDER BY orders_status_id
9935846 Query SELECT * FROM zen_reward_status_track WHERE orders_id='5239' ORDER BY date DESC LIMIT 1
9935846 Query SELECT * FROM zen_orders_status WHERE language_id='1' ORDER BY orders_status_id
9935846 Query SELECT * FROM zen_reward_status_track WHERE orders_id='5273' ORDER BY date DESC LIMIT 1
9935846 Query SELECT * FROM zen_orders_status WHERE language_id='1' ORDER BY orders_status_id
9935846 Query SELECT * FROM zen_reward_status_track WHERE orders_id='5342' ORDER BY date DESC LIMIT 1
9935846 Query SELECT * FROM zen_orders_status WHERE language_id='1' ORDER BY orders_status_id
9935846 Query SELECT * FROM zen_reward_status_track WHERE orders_id='5458' ORDER BY date DESC LIMIT 1
There are hundreds of these lines of queries. I highly recommend providing the log or excerpts of the commands to the Zen Cart community to see if they can assist or provide more information into the cause of the issue.
If the issue continues, your account may be suspended again, possibly requiring an upgrade to a virtual private server.