Blocks disappear

Check the multilingual section for each block to see what language the block will be shown in.

"All Languages".

In fact, I have tried "All languages (Translatable)" and "English", but when I clicked save, the changes are not saved. Other fields are save-able.

That "changes not saved" looks like you may have some upgrade issue. Is everything up to date? (update.php) No errors in the logs? (Reports, log entries)

I am running Drupal 6.14.

There are no upgrade issues. (Upgraded from Drupal 5.20 to Drupal 6.14)

Unknown column 'i18n.language' in 'where clause' 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 ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( b.theme = 'framework' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) )ORDER BY b.region, b.weight, b.module in /Users/jack/Sites/blue/modules/block/block.module on line 407.

After I disabled "Block translation" and "Menu translation", blocks reappeared.

Here is the error message from log.

I need block translation and menu translation modules.

I have added the missing column, language in i18i_block. Alas, that did not solve the problem.

Yipee ... I got this issue resolved.

Here's how:

1. Disable all components under "Multilanguage" (i18n)
2. Uninstall
3. Remove all tables with prefix i18n (with phpmyadmin)
4. Reinstall the i18n
6. update.php

p.s: remember to backup your database.

Thank you, Jose and others for this module. Keep up the good work.

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