نقل قول:
500 - یک خطا رخ داده است
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM ra8oy_phocagallery_user AS a LEFT JOIN ra8oy_languages AS l ON l.lang_code = a.language LEFT JOIN ra8oy_users AS ua ON ua.id=a.userid LEFT JOIN ra8oy_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM ra8oy_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM ra8oy_phocagallery AS i LEFT JOIN ra8oy_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN ra8oy_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM ra8oy_phocagallery_user AS a LEFT JOIN ra8oy_languages AS l ON l.lang_code = a.language LEFT JOIN ra8oy_users AS ua ON ua.id=a.userid LEFT JOIN ra8oy_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM ra8oy_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM ra8oy_phocagallery AS i LEFT JOIN ra8oy_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN ra8oy_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM ra8oy_phocagallery_user AS a LEFT JOIN ra8oy_languages AS l ON l.lang_code = a.language LEFT JOIN ra8oy_users AS ua ON ua.id=a.userid LEFT JOIN ra8oy_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM ra8oy_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM ra8oy_phocagallery AS i LEFT JOIN ra8oy_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN ra8oy_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc
برگشت به کنترل پنل
ضمناً بنده این افزونه رو توی نت و لوکال تست کردم و در هر دو مورد با این مشکل مواجه شدم