X-Cart forums

[B00MER]

Okie is anyone else getting SQL errors when doing a price search in advanced search, I think its because ORDER BY price should go after GROUP BY xcart_products.productid which it isn't on the price search, in search.php and func.php.

Anyone else?

[jpsowin]

Yes. This release seems to be very buggy in alot of areas.

This has already been reported:
http://forum.x-cart.com/viewtopic.php?t=957
And another place, but I can't find it.

I had them custom build the "search by price" into my cart with the 3.1.3 release. I left my customized cart easy because EVERYTHING (bestsellers, shopping cart funnel/top page views/etc, search by price, "also of interest" in product detail, and more) is in the 3.3.0 release. Does make it easier, though.

Do they have beta testers? Maybe they need to or something...

[B00MER]

I've got a fix but it doesn't sort the pricing, but still returns results with no errors:

in customer/search.php search for:

$sort_by_price = $price_condition?" ORDER BY price":"";

And comment this code line out with // or # and all should be good.

[B00MER]

Full fix here:

http://forum.x-cart.com/viewtopic.php?t=1261