We are now receiving SQL errors this morning. Not sure if it's related but I am guessing it is.
Code:
-------------------------------------------------
[31-Jan-2015 07:57:12] SQL error:
Site : xxx
Remote IP : xxx
Logged as :
SQL query : SELECT node.*, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, node.category) AS category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_categories_subcount.top_product_count, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_images_C.imageid, node.show_new_arrivals FROM xcart_categories AS node LEFT JOIN xcart_categories_lng ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=node.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = node.categoryid LEFT JOIN xcart_categories_subcount ON xcart_categories_subcount.categoryid = node.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON node.categoryid = xcart_images_C.id WHERE node.parentid = '433' AND (node.avail = 'Y' OR node.avail = 'G') AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY node.categoryid ORDER BY node.lpos, category
Error code : 1030
Description : Got error 28 from storage engine
Request URI: /cdseopro.php
Backtrace:
/../include/func/func.db.php:309
/../include/func/func.db.php:209
/../include/func/func.category.php:717
/../home.php:75
/../cdseopro.php:65
-------------------------------------------------