HI! I've tried to update metatag, but when doing the database update it gives the following error:

Update #7011
Failed: PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '<>': SELECT n.nid, n.language FROM {node} n INNER JOIN {metatag} m ON n.nid = m.entity_id WHERE m.entity_type = 'node' AND n.language != m.language ORDER BY nid; Array ( ) in metatag_update_7011() (line 475 of sites/all/modules/metatag/metatag.install).

Comments

DamienMcKenna’s picture

Category: bug » support
Status: Active » Closed (works as designed)

That isn't something that Metatag is in charge of, it doesn't control which collation method is used for the tables. I suggest examining your site's database and changing the tables so that they all have the same collation, i.e. either utf8_swedish_ci or utf8_general_ci.