MySQL Error

Post Reply
swim
Posts: 302
Joined: Mon Nov 19, 2012 8:34 pm

MySQL Error

Post by swim »

Build 201303181758
после последнего аппа появилось на хоуме
Mysql error:: 1267 (Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=') in query SELECT thumbs FROM rot_gallery_info as gi LEFT JOIN rot_galleries as g ON g.gallery_md5 = gi.gallery_md5 WHERE status = 5.OKMysql error:: 1267 (Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=') in query SELECT thumbs FROM rot_gallery_info as gi LEFT JOIN rot_galleries as g ON g.gallery_md5 = gi.gallery_md5 WHERE status = 5.OK
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: MySQL Error

Post by admin »

Это у вас мускл поменялся за время между апдейтами либо дефолтные установки.

Надо пойти в мускл и сделать что б у таблиц

rot_gallery_info as и rot_galleries

поля gallery_md5 имели одинаковый collation.
Don't forget to run script update
Post Reply