hananils/subsectionmanager — Issue #185: MySQL Error (1271): Illegal mix of collations for operation 'UNION' in query
Author: tonyarnold
Created: 2012-02-17 04:47:37+00:00
State: open

```

MySQL Error (1271): Illegal mix of collations for operation 'UNION' in query "(SELECT t1.`subsection_id`, t1.field_id
FROM `sym_fields_subsectionmanager` AS t1
INNER JOIN `sym_fields` AS t2
WHERE t2.`element_name` = 'sidebar-image'
AND t2.`parent_section` = '38'
AND t1.`field_id` = t2.`id`
LIMIT 1)
UNION
(SELECT t1.`subsection_id`, t1.field_id
FROM `sym_fields_subsectiontabs` AS t1
INNER JOIN `sym_fields` AS t2
WHERE t2.`element_name` = 'sidebar-image'
AND t2.`parent_section` = '38'
AND t1.`field_id` = t2.`id`
LIMIT 1)
LIMIT 1"
```

I'm seeing this when querying a datasource containing an subsection that only allows a single entry. What information can I provide to help track this down (and potentially fix it myself). I don't know enough about SSM at this point to make an educated guess :(