Hello guys,
I just installed JUX real estate extension and when I tried to add types I got the following messages. I don't know how to solve it, please, help me!
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM egnmq_re_types AS a LEFT JOIN `egnmq_languages` AS l ON l.lang_code = a.language LEFT JOIN egnmq_users AS uc ON uc.id=a.checked_out LEFT JOIN egnmq_viewlevels AS ag ON ag.id = a.access WHERE (a.published IN (0, 1)) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level FROM egnmq_re_types AS a LEFT JOIN `egnmq_languages` AS l ON l.lang_code = a.language LEFT JOIN egnmq_users AS uc ON uc.id=a.checked_out LEFT JOIN egnmq_viewlevels AS ag ON ag.id = a.access WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM egnmq_re_types AS a LEFT JOIN `egnmq_languages` AS l ON l.lang_code = a.language LEFT JOIN egnmq_users AS uc ON uc.id=a.checked_out LEFT JOIN egnmq_viewlevels AS ag ON ag.id = a.access WHERE (a.published IN (0, 1))
and when I try to add realties
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT r.*, r.cat_id , d.sign AS `currency`, t.title AS `type`, c.title AS `category`, CONCAT_WS(" ", a.username) AS `agentname`, u.name AS `username`,c.title AS category_title,uc.name AS editor,l.title AS language_title,ag.title AS access_level FROM egnmq_re_realties AS r LEFT JOIN egnmq_re_types AS t ON t.id = r.type_id LEFT JOIN egnmq_categories AS c ON c.id = r.cat_id LEFT JOIN egnmq_re_currencies AS d ON d.id = r.currency_id LEFT JOIN egnmq_re_agents AS a ON a.id = r.agent_id LEFT JOIN egnmq_users AS u ON u.id = r.user_id LEFT JOIN egnmq_users AS uc ON uc.id=r.checked_out LEFT JOIN `egnmq_languages` AS l ON l.lang_code = r.language LEFT JOIN egnmq_viewlevels AS ag ON ag.id = r.access WHERE (r.published = 0 OR r.published = 1) AND (r.approved = -1 OR r.approved = 1 OR r.approved = 0) AND (r.featured = 0 OR r.featured = 1) GROUP BY r.id ORDER BY r.ordering asc Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT r.*, r.cat_id , d.sign AS `currency`, t.title AS `type`, c.title AS `category`, CONCAT_WS(" ", a.username) AS `agentname`, u.name AS `username`,c.title AS category_title,uc.name AS editor,l.title AS language_title,ag.title AS access_level FROM egnmq_re_realties AS r LEFT JOIN egnmq_re_types AS t ON t.id = r.type_id LEFT JOIN egnmq_categories AS c ON c.id = r.cat_id LEFT JOIN egnmq_re_currencies AS d ON d.id = r.currency_id LEFT JOIN egnmq_re_agents AS a ON a.id = r.agent_id LEFT JOIN egnmq_users AS u ON u.id = r.user_id LEFT JOIN egnmq_users AS uc ON uc.id=r.checked_out LEFT JOIN `egnmq_languages` AS l ON l.lang_code = r.language LEFT JOIN egnmq_viewlevels AS ag ON ag.id = r.access WHERE (r.published = 0 OR r.published = 1) AND (r.approved = -1 OR r.approved = 1 OR r.approved = 0) AND (r.featured = 0 OR r.featured = 1) GROUP BY r.id ORDER BY r.ordering asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT r.*, r.cat_id , d.sign AS `currency`, t.title AS `type`, c.title AS `category`, CONCAT_WS(" ", a.username) AS `agentname`, u.name AS `username`,c.title AS category_title,uc.name AS editor,l.title AS language_title,ag.title AS access_level FROM egnmq_re_realties AS r LEFT JOIN egnmq_re_types AS t ON t.id = r.type_id LEFT JOIN egnmq_categories AS c ON c.id = r.cat_id LEFT JOIN egnmq_re_currencies AS d ON d.id = r.currency_id LEFT JOIN egnmq_re_agents AS a ON a.id = r.agent_id LEFT JOIN egnmq_users AS u ON u.id = r.user_id LEFT JOIN egnmq_users AS uc ON uc.id=r.checked_out LEFT JOIN `egnmq_languages` AS l ON l.lang_code = r.language LEFT JOIN egnmq_viewlevels AS ag ON ag.id = r.access WHERE (r.published = 0 OR r.published = 1) AND (r.approved = -1 OR r.approved = 1 OR r.approved = 0) AND (r.featured = 0 OR r.featured = 1) GROUP BY r.id ORDER BY r.ordering asc
trying to add fields
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM egnmq_re_fields AS a LEFT JOIN egnmq_users AS uc ON uc.id=a.checked_out LEFT JOIN `egnmq_languages` AS l ON l.lang_code = a.language WHERE (a.published = 0 OR a.published = 1) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,uc.name AS editor,l.title AS language_title FROM egnmq_re_fields AS a LEFT JOIN egnmq_users AS uc ON uc.id=a.checked_out LEFT JOIN `egnmq_languages` AS l ON l.lang_code = a.language WHERE (a.published = 0 OR a.published = 1) ORDER BY a.ordering asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM egnmq_re_fields AS a LEFT JOIN egnmq_users AS uc ON uc.id=a.checked_out LEFT JOIN `egnmq_languages` AS l ON l.lang_code = a.language WHERE (a.published = 0 OR a.published = 1)
Illegal mix of collations
Topic Author
