I Installed a new (6.9) english drupal, installed "http://drupal.org/project/he" (hebrew translator) and then installed i18n in the "all module directory".
When I enable the block.module in i18n I get:

user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta LEFT JOIN i18n_blocks i18n ON b.module = i18n.module AND b.delta = i18n.delta WHERE (i18n.language ='he' OR i18n.language ='' OR i18n.language IS NULL) AND ( b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) )ORDER BY b.region, b.weight, b.module in /home/ozgil/public_html/tickforall/modules/block/block.module on line 407.

Comments

jose reyero’s picture

jose reyero commented
Priority: Critical » Normal
Status: Active » Fixed

It seems some fields were created with different utf8 collations, no idea why this may happen (switching versions, settings from drupal core installation to i18n installation?).

Fix i18n_blocks table manually, I guess its the 'module field' and set it to the very same parameters than the 'module' field in blocks table.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.