After Upgrade from Version 1.4.2 to Version 1.5.1 every User has the following Error after login:
Query failed with message 'Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=''
Error params:
File: /var/www/web38/html/opentest/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 386
Error number: 1267
Sql: SELECT DISTINCT `t`.`tag` AS `name`, count(`t`.`tag`) AS `count` FROM `og_tags` `t`, (SELECT 'ProjectMessages' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_messages` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectMessages' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMessages' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMessages' AND `xx_pu`.can_read_messages = true ) ) ) ) UNION SELECT 'ProjectEvents' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_events` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectEvents' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectEvents' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectEvents' AND `xx_pu`.can_read_events = true ) ) ) ) UNION SELECT 'ProjectFiles' AS `object_manager_value`, `id` as `oid`, `updated_on` AS `order_value` FROM `og_project_files` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectFiles' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectFiles' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectFiles' AND `xx_pu`.can_read_files = true ) ) ) ) UNION SELECT 'ProjectTasks' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_tasks` `co` WHERE `is_template` = false AND `completed_by_id` = 0 AND `trashed_by_id` = 0 AND `is_template` = false AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectTasks' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectTasks' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectTasks' AND `xx_pu`.can_read_tasks = true ) ) ) ) UNION SELECT 'ProjectMilestones' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_milestones` `co` WHERE `trashed_by_id` = 0 AND `is_template` = false AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectMilestones' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMilestones' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMilestones' AND `xx_pu`.can_read_milestones = true ) ) ) ) UNION SELECT 'ProjectWebPages' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_webpages` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectWebpages' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectWebpages' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectWebpages' AND `xx_pu`.can_read_weblinks = true ) ) ) ) UNION SELECT 'MailContents' AS `object_manager_value`, `id` AS `oid`, `sent_date` AS `order_value` FROM `og_mail_contents` `co` WHERE `trashed_by_id` = 0 AND `is_deleted` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'MailContents' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'MailContents' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'MailContents' AND `xx_pu`.can_read_mails = true ) ) ) ) UNION SELECT 'Companies' AS `object_manager_value`, `id` as `oid`, `updated_on` AS `order_value` FROM `og_companies` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'Companies' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( true) UNION SELECT 'Contacts' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_contacts` `co` WHERE `trashed_by_id` = 0 AND ( true)) `o` WHERE `t`.`rel_object_manager` = `o`.`object_manager_value` AND `t`.`rel_object_id` = `o`.`oid` GROUP BY `t`.`tag` ORDER BY `count` DESC, `t`.`tag`
