News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Search products showing a mistake VirtueMart

Started by Edwardocz, October 06, 2015, 17:42:28 PM

Previous topic - Next topic

Edwardocz

We have a website Joomla 3.4.4., VirtueMart 3.0.10 and PHP 5.6.13. 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."

Thank you for your help and eliminating errors in the code Virtuemart

Milbo

As far as I know, we use always the same collation for our tables. Your tables have different collations. We could solve that maybe per sql, but the right way is imho to use always the same collation.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/