Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Studio 42 on June 06, 2019, 22:46:07 PM

Title: Illegal mix of collations on search in shop
Post by: Studio 42 on June 06, 2019, 22:46:07 PM
r
Code Select
`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]
Title: Re: Illegal mix of collations on search in shop
Post by: Studio 42 on June 06, 2019, 22:54:25 PM
Hum response bugs in posting too
The problem is for eg keyword=poli%car in the URL
Text only | Text with Images