After installation of 4.0, on the customer page I get this error at the top of the screen and am unsure what to do about it:
Code:
INVALID SQL: 1064 : You have an error in your SQL syntax near 'xcart_products.avail>0 and AND xcart_products_categories.categoryid IN (248) AN' at line 1
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing 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.variantid = 0 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' xcart_products.avail>0 and AND xcart_products_categories.categoryid IN (248) AND xcart_products.views_stats>0 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
As I mentioned in an earlier post, I can't seem to correctly import data into the extra fields where I still can on my live store(3.4.14). Could this error have anything to do with that? And, am I the only one who got this error after installation?
I have since found from another thread that this SQL error is appearing when you check to disable products that are out of stock. When I unchecked it the error no longer appeared. I re-imported products, checked the box, and the error appears again, so that must be a bug.