[mmoskva]

My cart was running great yesterday, but when I looked at it today I see a list of sql error messages and I cannot understand why? can someone explain?

Admin side:

INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT IF (L1.value IS NOT NULL, L1.value, IF (L2.value IS NOT NULL, L2.value, L3.value) ) AS country, xcart_countries.code as country_code, xcart_countries.display_states, xcart_countries.region FROM xcart_countries LEFT JOIN xcart_languages L1 ON L1.name = CONCAT('country_',xcart_countries.code) AND L1.code = 'US' LEFT JOIN xcart_languages L2 ON L2.name = CONCAT('country_',xcart_countries.code) AND L2.code = 'US' LEFT JOIN xcart_languages L3 ON L3.name = CONCAT('country_',xcart_countries.code) AND L3.code = 'US' WHERE xcart_countries.active='Y' ORDER BY country


Customer side:

INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT xcart_products.*, MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.p roductid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products .productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products.product ASC LIMIT 0, 10