News:

Support the VirtueMart project and become a member

Main Menu

Illegal mix of collations on search in shop

Started by Studio 42, June 06, 2019, 22:46:07 PM

Previous topic - Next topic

Studio 42

r`l`.product_name LIKE "%poli�r%" OR `p`.product_sku LIKE "%poli�r%" OR `l`.product_s_desc LIKE "%poli�r%" OR `l`.product_desc LIKE "%poli�r%" OR `category_name` LIKE "%poli�r%" OR `category_description` LIKE "%poli�r%" OR `p`.product_special LIKE "%poli�r%")
[[code]https://demo.virtuemart.net/?keyword=poli%car&view=category&option=com_virtuemart&virtuemart_category_id=0&Itemid=121[/code]

Studio 42

Hum response bugs in posting too
The problem is for eg keyword=poli%car in the URL