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?hamidg84 wrote: ↑Tue Feb 20, 2018 7:32 amHello
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.
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo
Who is online
Users browsing this forum: No registered users and 21 guests