X-Cart forums - Possible Advanced Search Bug 3.3.1

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

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

- - Possible Advanced Search Bug 3.3.1 (https://forum.x-cart.com/showthread.php?t=1157)

Possible Advanced Search Bug 3.3.1

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? :?

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... :roll:

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:

Code:

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

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