Post by hamidg84 » Tue Feb 20, 2018 7:32 am

Hello
we recently upgraded to latest oc version and since they have encountered following errors. website has been down for the whole day due some scripts using lots of resources on server

SELECT * FROM ocob_category c LEFT JOIN ocob_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN ocob_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '1') LEFT JOIN ocob_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '423' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT max(m.manufacturer_id) manufacturer_id, MAX(m.name) name, MAX(m.image) image, COUNT(*) total FROM `ocob_manufacturer` m LEFT JOIN `ocob_manufacturer_to_store` m2s ON (m.manufacturer_id = m2s.manufacturer_id) LEFT JOIN `ocob_product` p ON p.manufacturer_id = m.manufacturer_id LEFT JOIN `ocob_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `ocob_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `ocob_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND p2c.category_id = '354' AND m2s.store_id = '0' GROUP BY m.manufacturer_id HAVING COUNT(*) > 0 ORDER BY m.name, m.sort_order ASC

im unable to login to admin area but have access to cpanel. Kindly suggest something please.

Active Member

Posts

Joined
Wed Feb 29, 2012 6:18 am

Post by rjcalifornia » Tue Feb 20, 2018 12:07 pm

hamidg84 wrote:
Tue Feb 20, 2018 7:32 am
Hello
we recently upgraded to latest oc version and since they have encountered following errors. website has been down for the whole day due some scripts using lots of resources on server

SELECT * FROM ocob_category c LEFT JOIN ocob_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN ocob_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '1') LEFT JOIN ocob_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '423' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT max(m.manufacturer_id) manufacturer_id, MAX(m.name) name, MAX(m.image) image, COUNT(*) total FROM `ocob_manufacturer` m LEFT JOIN `ocob_manufacturer_to_store` m2s ON (m.manufacturer_id = m2s.manufacturer_id) LEFT JOIN `ocob_product` p ON p.manufacturer_id = m.manufacturer_id LEFT JOIN `ocob_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `ocob_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `ocob_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND p2c.category_id = '354' AND m2s.store_id = '0' GROUP BY m.manufacturer_id HAVING COUNT(*) > 0 ORDER BY m.name, m.sort_order ASC

im unable to login to admin area but have access to cpanel. Kindly suggest something please.
Do you have a backup of your site? From which version were you upgrading?

Image
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by hamidg84 » Tue Feb 20, 2018 6:42 pm

Hello

yes.

Active Member

Posts

Joined
Wed Feb 29, 2012 6:18 am
Who is online

Users browsing this forum: No registered users and 19 guests