I get the same error on a new customer install when I add the products as featured products to the home page.
Quote:
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 = '16127' GROUP BY xcart_pricing.variantid ORDER BY price HAVING avail > 0
|
X-Cart version 4.0.13
PHP 4.3.10 Details >>
MySQL server 4.0.23a
MySQL client 3.23.58
Web server Apache/2.0.40 (Red Hat Linux)
Operation system Linux
Perl not found Details >>
XML parser (expat) found