INVALID SQL: 1054 : Unknown column 'xcart_class_options.optionid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_classes.*, xcart_class_options.*, xcart_class_lng.class as class_lng, xcart_class_lng.classtext as classtext_lng, xcart_product_options_lng.option_name as option_name_lng FROM xcart_class_options, xcart_classes LEFT JOIN xcart_product_options_lng ON xcart_class_options.optionid = xcart_product_options_lng.optionid AND xcart_product_options_lng.code = 'US' LEFT JOIN xcart_class_lng ON xcart_classes.classid = xcart_class_lng.classid AND xcart_class_lng.code = 'US' WHERE xcart_classes.productid = '664' AND xcart_classes.classid = xcart_class_options.classid AND xcart_class_options.avail = 'Y' AND xcart_classes.avail = 'Y' INVALID SQL: 1054 : Unknown column 'xcart_class_options.optionid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_classes.*, xcart_class_options.*, xcart_class_lng.class as class_lng, xcart_class_lng.classtext as classtext_lng, xcart_product_options_lng.option_name as option_name_lng FROM xcart_class_options, xcart_classes LEFT JOIN xcart_product_options_lng ON xcart_class_options.optionid = xcart_product_options_lng.optionid AND xcart_product_options_lng.code = 'US' LEFT JOIN xcart_class_lng ON xcart_classes.classid = xcart_class_lng.classid AND xcart_class_lng.code = 'US' WHERE xcart_classes.productid = '664' AND xcart_classes.classid = xcart_class_options.classid AND xcart_class_options.avail = 'Y' AND xcart_classes.avail = 'Y' INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT DISTINCT sp2.productid, xcart_products.*, IF (xcart_products_lng.product IS NOT NULL,xcart_products_lng.product, xcart_products.product) AS product, IF (xcart_products_lng.descr IS NOT NULL,xcart_products_lng.descr, xcart_products.descr) AS descr, IF (xcart_products_lng.full_descr IS NOT NULL,xcart_products_lng.full_descr, xcart_products.fulldescr) AS fulldescr FROM xcart_stats_customers_products as sp1, xcart_stats_customers_products AS sp2, xcart_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products.productid=xcart_products_lng.productid AND xcart_products_lng.code='US' WHERE sp1.productid='664' AND sp1.login=sp2.login AND sp2.productid!='664' AND xcart_products.productid=sp2.productid AND xcart_products.forsale='Y' AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.main = 'Y' AND xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.membership IN ('','') ORDER BY xcart_products.product LIMIT 5
The Bead Basket
:: Beads
:: Shaped Gemstone Beads
:: Other Shapes
:: Dyed Opal Diamonds
Categories
Users online
Your cart
Newsletter