X-Cart forums

[Hyperdelicious]

The following SQL error is returned on products which have options with variants...

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

[Hyperdelicious]

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

[memdy]

I get the same error on a new customer install when I add the products as featured products to the home page.

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