momaabd
08-16-2012, 12:18 PM
سلام
وقتي مجموعه ميسازم و ذخيره و جديد رو ميزنم اين ارور رو ميده
يک خطا رخ داده است 500
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=INSERT INTO `f5jy3_finder_tokens_aggregate` (`term_id`, `term`, `stem`, `common`, `phrase`, `term_weight`, `context`, `context_weight`) SELECT t.term_id, t1.term, t1.stem, t1.common, t1.phrase, t1.weight, t1.context, ROUND( t1.weight * COUNT( t2.term ) * 1.700000, 8 ) AS context_weight FROM ( SELECT DISTINCT t1.term, t1.stem, t1.common, t1.phrase, t1.weight, t1.context FROM `f5jy3_finder_tokens` AS t1 WHERE t1.context = 1 ) AS t1 JOIN `f5jy3_finder_tokens` AS t2 ON t2.term = t1.term LEFT JOIN `f5jy3_finder_terms` AS t ON t.term = t1.term WHERE t2.context = 1 GROUP BY t1.term ORDER BY t1.term DESC
البته بعد که بر ميگردم به پنل اصلي و وارد مجموعه ها ميشم مجموعه ذخيره شده ولي هر بار که بخوام مجموعه بسازم همين ارور رو ميده.
هم توی لوکال این اتفاق افتاده هم توی هاست!!!!!!!!!
ممنون از راهنماييتون
وقتي مجموعه ميسازم و ذخيره و جديد رو ميزنم اين ارور رو ميده
يک خطا رخ داده است 500
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=INSERT INTO `f5jy3_finder_tokens_aggregate` (`term_id`, `term`, `stem`, `common`, `phrase`, `term_weight`, `context`, `context_weight`) SELECT t.term_id, t1.term, t1.stem, t1.common, t1.phrase, t1.weight, t1.context, ROUND( t1.weight * COUNT( t2.term ) * 1.700000, 8 ) AS context_weight FROM ( SELECT DISTINCT t1.term, t1.stem, t1.common, t1.phrase, t1.weight, t1.context FROM `f5jy3_finder_tokens` AS t1 WHERE t1.context = 1 ) AS t1 JOIN `f5jy3_finder_tokens` AS t2 ON t2.term = t1.term LEFT JOIN `f5jy3_finder_terms` AS t ON t.term = t1.term WHERE t2.context = 1 GROUP BY t1.term ORDER BY t1.term DESC
البته بعد که بر ميگردم به پنل اصلي و وارد مجموعه ها ميشم مجموعه ذخيره شده ولي هر بار که بخوام مجموعه بسازم همين ارور رو ميده.
هم توی لوکال این اتفاق افتاده هم توی هاست!!!!!!!!!
ممنون از راهنماييتون