1270: Illegal mix of collations (utf8_unicode_ci,IMPLICIT), (utf8_unicode_ci,IMPLICIT), (latin1_swedish_ci,IMPLICIT) for operation 'match'<br />SELECT a.*, MATCH (a.`name`,a.`keywords`,a.`item_description`) AGAINST ('irlanda* ' IN BOOLEAN MODE) as `relevance` FROM `pro_items` a
WHERE a.`enabled`=1 AND a.`visible`=1 AND ( ((1 AND MATCH (a.`name`,a.`keywords`,a.`item_description`) AGAINST ('irlanda* ' IN BOOLEAN MODE) ) OR a.id IN (771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787) ) ) GROUP BY a.id ORDER BY `relevance` DESC, a.name limit 0,15
1270: Illegal mix of collations (utf8_unicode_ci,IMPLICIT), (utf8_unicode_ci,IMPLICIT), (latin1_swedish_ci,IMPLICIT) for operation 'match'<br />SELECT COUNT(DISTINCT(a.`id`)) as `total` FROM `pro_items` a
WHERE
a.`enabled`=1 AND a.`visible`=1 AND ( ((1 AND MATCH (a.`name`,a.`keywords`,a.`item_description`) AGAINST ('irlanda* ' IN BOOLEAN MODE) ) OR a.id IN (771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787) ) )
error
