INVALID SQL: 1053 : Server shutdown in progress
SQL QUERY FAILURE:SELECT xcart_products.*, xcart_quick_flags.*, xcart_pricing.variantid, if(xcart_pricing.is_sale=1 and xcart_pricing.start_date <= 1717570960 and (xcart_pricing.end_date = 0 or xcart_pricing.end_date > 1717570960), xcart_pricing.sale_price, if(xcart_pricing.is_subprice=1 and xcart_pricing.currentsub_productid > 0 and xcart_pricing.sub_price > 0, xcart_pricing.sub_price, xcart_pricing.price)) as price, xcart_pricing.price AS "orig_price", xcart_pricing.sale_price, if(is_sale=1 and start_date <= 1717570960 and (end_date > 1717570960 or end_date=0), 1, 0) as is_sale, xcart_pricing.price as list_price, xcart_products.product, xcart_products.descr, xcart_products.fulldescr, xcart_products.avail as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid LEFT JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_products_addtocart ON xcart_products_addtocart.productid = xcart_products.productid INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.membershipid IN ('20') LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_pricing.variantid = xcart_variants.variantid INNER JOIN xcart_extra_field_values as eff_1759 ON xcart_products.productid = eff_1759.productid and eff_1759.fieldid='1759' and (eff_1759.value = 'Ginger Spice' or concat(',', eff_1759.value, ',') like '%,Ginger Spice,%' or concat(',', eff_1759.value, ',') like '%, Ginger Spice,%' or eff_1759.value = 'Jolie' or concat(',', eff_1759.value, ',') like '%,Jolie,%' or concat(',', eff_1759.value, ',') like '%, Jolie,%' or eff_1759.value = 'Jonathan Plaid' or concat(',', eff_1759.value, ',') like '%,Jonathan Plaid,%' or concat(',', eff_1759.value, ',') like '%, Jonathan Plaid,%' or eff_1759.value = 'Merry Little Christmas' or concat(',', eff_1759.value, ',') like '%,Merry Little Christmas,%' or concat(',', eff_1759.value, ',') like '%, Merry Little Christmas,%') WHERE xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.is_b2b = 1 AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '20') AND (xcart_product_memberships.membershipid IS NULL OR xcart_product_memberships.membershipid = '20') AND xcart_categories.avail in ('Y', 'H') AND xcart_products_categories.categoryid='7' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND (xcart_products.forsale = 'Y' OR xcart_products.forsale = 'R' OR xcart_products.forsale = 'H') AND xcart_products.avail > 0 GROUP BY xcart_products.productid ORDER BY xcart_products_addtocart.is_addtocart desc, xcart_categories.sales_stats DESC, xcart_products.sales_stats DESC, xcart_products.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC LIMIT 0, 40
INVALID SQL: :
SQL QUERY FAILURE:SET NAMES utf8
INVALID SQL: :
SQL QUERY FAILURE:SET NAMES utf8
INVALID SQL: :
SQL QUERY FAILURE:SET NAMES utf8
INVALID SQL: :
SQL QUERY FAILURE:SET NAMES utf8
INVALID SQL: :
SQL QUERY FAILURE:SET NAMES utf8
Cannot connect to MySQL server
Cannot connect to MySQL server
:
INVALID SQL: :
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '2548d8aabcf122cb0d0042f2146d4d75'
INVALID SQL: :
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'hVRdb9QwEPwveUdKch/t+Z6oBAIhUtQKofbFcpLNnaljB9u5UND9d3Zt53oVnHiK4/WOZ2dnLVi5Yb8dKwqWQSu9sbw3LWTbauvYNcuk49bUxmf4i0cq+q5Ylvbo0IZlohWDlwdw2VawdYBbhtROWue588IGgJxl9LliWW3N5MCmv8/ml1RKpL8DWCeNzrYtW+EOIu2FbbO4lIvrdRapKaF3o9hBogT6zdf7FBqU8J2xfQp9k3pRZtujY2WJbLWXyJ4fhJKt8HgVLYn6KlBHCrjlQLfcG95ZiSuKlhRFCk3Qx2Gh2d36MS9XidrooH2RCS8rFgGpMdqLxvPRXUBZvytvbz5dQrkOIMrspL6Qv/yQP779eJFFHgAsHCRMlyis7u7u31f/KURjPh+EBnUB5f5x82Vx+2+UYzwcnFDFE42SQ/wh92GFZiSVyBa0WSKiA0de4J2QCrAfVmiHWgZ7hMQ1uS80iqC5l33yLrVRqEk8Oy6UMhN3e3N2mwNhmz3H/gsqpqBiyDjWtGPjg0xxLnIi7WFn7LPEeiS7ImqLE4JEq4x1OiJpBE4+J9nmXN4L6l+Q4yF8l2dB+ImVnUeRPPrXCQXnu5s4j9BJjfs1K7aRoDNYeidBRcGpPMx0NHjezZeFQ620kOQLsEWakMHKBl6vj2lc9t4PdGlMRTeP2lOLJMtJieVfJ5B4LdsWNFHMY6snReJVie93x0GLWp0M8jDz9mbgPfY8jHUVXYXG2MGcjVgWeuhrsPNMxEtI7FMktrWKQhrVcqV3yVR50NBN0jd7dNTLIxLgsfyp6YOXMNw8QWh50BndgQPATdfh+/SaZBnu/jFi/bzZIyLgmDg3GTvTXtBzhU/h3PHZSBQgB3nTPHGj1fOprUXgqUwjztyev9CLeh7/AA==', expiry='1717572760', pages_count=pages_count+1 WHERE sessid = '2548d8aabcf122cb0d0042f2146d4d75'
