Hi
I have just loaded this mod and I get this error:
INVALID SQL: 1064 : You have an error in your SQL syntax near 'SELECT COUNT(pc.productid) FROM xcart_products_categories pc WHERE pc.ca' at line 7
SQL QUERY FAILURE: SELECT c.categoryid, c.category, c.parentid, ( SELECT COUNT(pc.productid) FROM xcart_products_categories pc WHERE pc.categoryid = c.categoryid ) AS prod_cnt FROM xcart_categories c WHERE c.avail="Y"
This is on the latest version of x-cart.
Any ideas on the cause?
Thanks
Peter