The following SQL error is returned on products which have options with variants...
Code:
INVALID SQL: 1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING avail > 0' at line 1
SQL QUERY FAILURE: SELECT xcart_variants.variantid, xcart_variants.weight, xcart_variants.productcode, MIN(xcart_pricing.price) as price , xcart_variants.avail FROM xcart_pricing, xcart_variants WHERE xcart_pricing.quantity = 1 AND xcart_pricing.membership = '' AND xcart_pricing.variantid = xcart_variants.variantid AND xcart_pricing.productid = '27' GROUP BY xcart_pricing.variantid ORDER BY price HAVING avail > 0
any ideas?
xcart - 4.1.3