INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, xcart_product_features.fclassid, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN xcart_product_features ON xcart_product_features.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
INVALID SQL: 1054 : Unknown column 'xcart_feature_classes.fclassid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_feature_classes.*, IF(xcart_feature_classes_lng.class IS NOT NULL, xcart_feature_classes_lng.class, xcart_feature_classes.class) as class, IF(xcart_feature_images.fclassid IS NULL,'','Y') as is_image FROM xcart_feature_classes, xcart_feature_options, xcart_product_features, xcart_product_foptions, xcart_products LEFT JOIN xcart_feature_classes_lng ON xcart_feature_classes.fclassid = xcart_feature_classes_lng.fclassid AND xcart_feature_classes_lng.code = 'US' LEFT JOIN xcart_feature_images ON xcart_feature_images.fclassid = xcart_feature_classes.fclassid WHERE xcart_feature_classes.avail = 'Y' AND xcart_feature_classes.fclassid = xcart_feature_options.fclassid AND xcart_feature_classes.fclassid = xcart_product_features.fclassid AND xcart_feature_options.foptionid = xcart_product_foptions.foptionid AND xcart_product_features.productid = xcart_products.productid AND xcart_products.forsale = 'Y' GROUP BY xcart_feature_classes.fclassid ORDER BY xcart_feature_classes.orderby


If the page is not updated in a 5 seconds, please follow this link: continue >>