We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' | Forum

UTAN
UTAN Jul 19 '14
Hi guys,

So I had this issue when trying to install from 1.5 to 1.7 it didn't matter if I had 1.5 then 1.6 to 1.7 same issue..

So what I end up doing, is get a new fresh backup of my site...

save to my computer then in my Mysql server , created a new DB specifying the COLLATION of the database -> utf8_general_ci

you get an empty DATA BASE, then just import your backup, go to website url/ow_updates and update your site..

In my case was successful ..

Hope it helps someone.
ross Team
ross Jul 20 '14
or you will just need to find the table or row with the wrong collation and change it to UTf8_general_ci
UTAN
UTAN Jul 20 '14
Indeed, but they were lots of them till i hit the problematic one, which its too much work..


Easiest and fastes was doing the process i have stated here.

ross Team
ross Jul 20 '14
Alright, thanks for sharing
ross Team
ross Jul 21 '14