Warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT * FROM access WHERE status = 1 AND type = 'host' AND LOWER('10.0.0.20') LIKE LOWER(mask) in /var/www/drupal/includes/database.mysql.inc on line 118

Warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT * FROM access WHERE status = 0 AND type = 'host' AND LOWER('10.0.0.20') LIKE LOWER(mask) in /var/www/drupal/includes/database.mysql.inc on line 118

Comments

greggles’s picture

Priority: Critical » Normal

Was this an upgrade from a previous installation? If so, which version?

According to this comment thread this error message appears on the update screen and happens when upgrading from 4.7beta3 to 4.7beta4 (but would probably also be a problem going from 4.6.x to 4.7). It appears that the upgrade succeeds and sites work after getting past this error, but it should either be a "known problem" in the release or hopefully fixed.

I'm changing the priority to Normal because this does not block a site from working, it just throws a non-problematic error during upgrade. However, mgigirey, if this causes other problems or is more serious than I have characterized it, feel free to upgrade it to critical again.

greggles’s picture

Status: Active » Closed (duplicate)

After writing all that I happened on issue http://drupal.org/node/46934 which is the original of this one.

I'm marking this issue as a duplicate.