Post by Solan » Sun Oct 14, 2012 10:33 pm

Hi everybody!

Im looking for someone that is good in understanding and solving errors.

The past days im struggeling with very high server load that shuts my site down.

I have version 1.5.1.3 thats modified to my needs.

Some of the errors are:

Code: Select all

2012-10-14 11:35:09 - PHP Notice:  Error: Query execution was interrupted<br />Error No: 1317<br />SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturers_image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '7280' AND pd.language_id = '2' AND p.status > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' in /home2/xxx/public_html/system/database/mysql.php on line 49
2012-10-14 11:35:09 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home2/xxx/public_html/system/database/mysql.php on line 49
2012-10-14 12:49:33 - PHP Warning:  unlink(/home2/xxx/public_html/system/cache/cache.product.2.0.8.cfffad5bcbd18a6165a37885f77fb8fd.1.1350211762) [<a href='function.unlink'>function.unlink</a>]: No such file or directory in /home2/xxx/public_html/system/library/cache.php on line 14
Please send me a pm with an offer. :)

Active Member

Posts

Joined
Sat Feb 19, 2011 7:34 pm

Post by ecgod.com » Sun Oct 14, 2012 11:27 pm

How many products do you have in your database?

Please click here to donate us if my solutions help.
ECGOD Development Center
http://www.ecgod.com
sale@ecgod.com
Robert


User avatar
Active Member

Posts

Joined
Wed Sep 05, 2012 8:36 pm

Post by Solan » Mon Oct 15, 2012 2:34 am

ecgod.com wrote:How many products do you have in your database?
I have about 2500 products...

Active Member

Posts

Joined
Sat Feb 19, 2011 7:34 pm

Post by paulfeakins » Mon Oct 15, 2012 5:13 pm

Hi there, we'd be glad to help. Would you like to email info@antropy.co.uk with some info so we can estimate for you?

Kind regards,
Paul :)

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom
Who is online

Users browsing this forum: No registered users and 15 guests