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 ('color* ' 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 ('color* ' IN BOOLEAN MODE) ) OR a.id IN (544, 393, 523, 509, 425, 424, 421, 314, 716, 706, 700, 694, 682, 681, 1043, 1060, 1227, 1450, 1455, 1466, 1470, 1478, 1447, 1467, 1457, 1883) ) ) 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 ('color* ' IN BOOLEAN MODE) ) OR a.id IN (544, 393, 523, 509, 425, 424, 421, 314, 716, 706, 700, 694, 682, 681, 1043, 1060, 1227, 1450, 1455, 1466, 1470, 1478, 1447, 1467, 1457, 1883) ) )
error
