sn00ze
New Member
Hi,
I have turned Extended search all = YES
Now the SQL query is AND -ing the search terms...as required, but I get this error:
#1271 - Illegal mix of collations for operation 'match'
the SQL that's the problem is:
FROM `new_entry`
WHERE ( ( (`new_entry`.`category` = '10' OR `new_entry`.`category` LIKE '[\"10\"%' OR `new_entry`.`category` LIKE '%\"10\"%' OR `new_entry`.`category` LIKE '%\"10\"]') AND MATCH(`new_entry`.`business_name`, `new_entry`.`category`, `new_entry`.`suburb_city`, `new_entry`.`meals_served`, `new_entry`.`type_of_cuisine`, `new_entry`.`other1`) against ('Belconnen*' IN BOOLEAN MODE)) ) LIMIT 0, 5
is this a BUG?
PS: i'm using fabrik 3.1rc2
I have turned Extended search all = YES
Now the SQL query is AND -ing the search terms...as required, but I get this error:
#1271 - Illegal mix of collations for operation 'match'
the SQL that's the problem is:
FROM `new_entry`
WHERE ( ( (`new_entry`.`category` = '10' OR `new_entry`.`category` LIKE '[\"10\"%' OR `new_entry`.`category` LIKE '%\"10\"%' OR `new_entry`.`category` LIKE '%\"10\"]') AND MATCH(`new_entry`.`business_name`, `new_entry`.`category`, `new_entry`.`suburb_city`, `new_entry`.`meals_served`, `new_entry`.`type_of_cuisine`, `new_entry`.`other1`) against ('Belconnen*' IN BOOLEAN MODE)) ) LIMIT 0, 5
is this a BUG?
PS: i'm using fabrik 3.1rc2