بیش*تر بحث من روی کالکشن*های utf8_general_ci و utf8_unicode_ci بود
اینم از اروری که موقع دسترسی به بعضی قسمت*های جوملا گالری نشون داده میشه (وقتی موقع ساخت دیتابیس کالکشن utf8_general_ci هست)
کد:
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 ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `umi8n_phocagallery_votes` AS a LEFT JOIN `umi8n_languages` AS l ON l.lang_code = a.language LEFT JOIN umi8n_users AS ua ON ua.id=a.userid LEFT JOIN umi8n_users AS uc ON uc.id=a.checked_out LEFT JOIN umi8n_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.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 ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `umi8n_phocagallery_votes` AS a LEFT JOIN `umi8n_languages` AS l ON l.lang_code = a.language LEFT JOIN umi8n_users AS ua ON ua.id=a.userid LEFT JOIN umi8n_users AS uc ON uc.id=a.checked_out LEFT JOIN umi8n_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 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 ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `umi8n_phocagallery_votes` AS a LEFT JOIN `umi8n_languages` AS l ON l.lang_code = a.language LEFT JOIN umi8n_users AS ua ON ua.id=a.userid LEFT JOIN umi8n_users AS uc ON uc.id=a.checked_out LEFT JOIN umi8n_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc
اینم اروری که وقتی موقع ساخت دیتابیس کالکشن utf8_unicode_ci هست (با ارور بالایی فرق میکنه)
کد:
Table 'joomlafarsi.qkd6q_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `qkd6q_phocagallery_votes` AS a LEFT JOIN `qkd6q_languages` AS l ON l.lang_code = a.language LEFT JOIN qkd6q_users AS ua ON ua.id=a.userid LEFT JOIN qkd6q_users AS uc ON uc.id=a.checked_out LEFT JOIN qkd6q_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'joomlafarsi.qkd6q_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `qkd6q_phocagallery_votes` AS a LEFT JOIN `qkd6q_languages` AS l ON l.lang_code = a.language LEFT JOIN qkd6q_users AS ua ON ua.id=a.userid LEFT JOIN qkd6q_users AS uc ON uc.id=a.checked_out LEFT JOIN qkd6q_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Table 'joomlafarsi.qkd6q_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `qkd6q_phocagallery_votes` AS a LEFT JOIN `qkd6q_languages` AS l ON l.lang_code = a.language LEFT JOIN qkd6q_users AS ua ON ua.id=a.userid LEFT JOIN qkd6q_users AS uc ON uc.id=a.checked_out LEFT JOIN qkd6q_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc
- با آخرین نسخه ومپ سرور تست شده.
- این ارورها در جوملاهای منتشر شده در بقیه جاها، وجود نداره.
- با تغییر کالکشن تمامی جداول به utf8_general_ci مشکل حل میشه.
موفق باشید
دلیل استفاده از utf8_unicode_ci به جای utf8_general_ci در جوملا فارسی 2.5 ؟!
نوشته اصلی توسط safajuy
[مهمان/کاربر گرامی برای دیدن لینک ها ابتدا باید عضو سایت شوید و لاگین کنید 
راه حل پیشنهادی تست شده
علاقه مندی ها (Bookmarks)