1271 - Illegal mix of collations for operation 'like' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `db_virtuemart_products` as p LEFT JOIN `db_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `db_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `db_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `db_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ((`p`.created_on LIKE "%Р±%" OR `p`.product_sku LIKE "%Р±%" OR `product_price` LIKE "%Р±%" OR `p`.product_sales LIKE "%Р±%") AND ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0") AND ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0") AND `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "2" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering` ASC LIMIT 0, 9 Des anybody have any idea how to fix it ?Best Regards!

We have a website Joomla 3.4.4., VirtueMart 3.0.9 and PHP 5.6.13. MB does not. Web address: http://www.prirodni-budejovice.cz/prirodni/I write to dandruff word with a hook, for example TEPLOMĚR. He runs the following message:

Oops!1271 - Illegal mix of collations for operation 'like' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `jos_virtuemart_products` as p INNER JOIN `jos_virtuemart_products_cs_cz` as l using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` =

Write the word TEPLOMER without a hook, and find the right.

Author template he wrote this: "We provide support for the code that we developed (Template) Issue that you are reporting is generated by default Virtuemart script."

Check your settings if 'Creation Date' is an available search field. Virtuemart uses these fields to construct the select query using LIKE '%..%' but 'Creation date' is a datetime field which doesn't have collation.

Check your settings if 'Creation Date' is an available search field. Virtuemart uses these fields to construct the select query using LIKE '%..%' but 'Creation date' is a datetime field which doesn't have collation.

Yeah and therefore it cant be a mix of collations.Hmmm, I renamed cap against cäp and enabled any search fields