Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
DamienMcKennaThat 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.