مشکل با کامپوننت hwd media share

[omid-entezar 10]

سلام دوستان

من این کامپوننت رو نصب کردم ولی وقتی میخوام تو صفحه ی مدیاهای کامپوننت برم فقط این ارور نشون داده میشه:

500 - یک خطا رخ داده است

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.thumbnail, a.duration, a.type, a.hits, a.published, a.featured,a.status, a.publish_up, a.publish_down, a.ordering, a.created, a.access,a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,CASE WHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type END AS media_type FROM wk3wr_hwdms_media AS a LEFT JOIN `wk3wr_languages` AS l ON l.lang_code = a.language LEFT JOIN wk3wr_users AS uc ON uc.id=a.checked_out LEFT JOIN wk3wr_viewlevels AS ag ON ag.id = a.access LEFT JOIN wk3wr_hwdms_ext AS ext ON ext.id = a.ext_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.created DESC<br />Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.thumbnail, a.duration, a.type, a.hits, a.published, a.featured,a.status, a.publish_up, a.publish_down, a.ordering, a.created, a.access,a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,CASE WHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type END AS media_type FROM wk3wr_hwdms_media AS a LEFT JOIN `wk3wr_languages` AS l ON l.lang_code = a.language LEFT JOIN wk3wr_users AS uc ON uc.id=a.checked_out LEFT JOIN wk3wr_viewlevels AS ag ON ag.id = a.access LEFT JOIN wk3wr_hwdms_ext AS ext ON ext.id = a.ext_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.created DESC LIMIT 0, 100<br />Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.thumbnail, a.duration, a.type, a.hits, a.published, a.featured,a.status, a.publish_up, a.publish_down, a.ordering, a.created, a.access,a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,CASE WHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type END AS media_type FROM wk3wr_hwdms_media AS a LEFT JOIN `wk3wr_languages` AS l ON l.lang_code = a.language LEFT JOIN wk3wr_users AS uc ON uc.id=a.checked_out LEFT JOIN wk3wr_viewlevels AS ag ON ag.id = a.access LEFT JOIN wk3wr_hwdms_ext AS ext ON ext.id = a.ext_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.created DESC

ولی توی بقیه صفحات کامپوننت هیچ مشکلی نداره و درست باز میشه و کار میکنه

اگه کسی میدونه راهنمایی کنه که بد لنگم...

[saber 208]

چک کنید collation جداول کامپوننت در دیتابیستون همشون utf8_general_ci باشن الان این رو هم دارید utf8_unicode_ci پیدا کنید و به utf8_general_ci تغییر بدید