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 ('ianra* ' 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 ('ianra* ' IN BOOLEAN MODE) ) OR a.id IN (566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583) ) ) 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 ('ianra* ' IN BOOLEAN MODE) ) OR a.id IN (566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583) ) )
error
