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

[omid-entezar 13]

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

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

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

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

[محمدحسین میری 3,094]

درود بر شما

 

خوب مسلمن مشکل داره

از کامپوننت هایی که در جاهای دیگری برای دانلود قرار داده اند نصب کنید و ببینید همین مشکل هست؟

[مصطفی صفرعلی 2,891]

با سلام

 

collation جدول wk3wr_hwdms_media را بر روی utf8_general_ci تنظیم کنید

 

موفق و پیروز باشید

یا حق