X-Cart forums - SQL Variant error

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - SQL Variant error (https://forum.x-cart.com/showthread.php?t=14506)

SQL Variant error

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

Product options with variants SQL error

I think this has something to do with the sort by function -- Any ideas?

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