After I enabled this i18n module, all blocks disappear on all pages.

I have switched to default theme, Garland, same issue.

After I disabled this i18i module, my blocks came back.

Any idea what's going on?

Comments

brucepearson’s picture

brucepearson commented

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

jessicakoh’s picture

jessicakoh commented

"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.

jose reyero’s picture

jose reyero commented

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)

jessicakoh’s picture

jessicakoh commented

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.

jessicakoh’s picture

jessicakoh commented

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

jessicakoh’s picture

jessicakoh commented
Status: Active » Fixed

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.

Status: Fixed » Closed (fixed)

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

lumbric’s picture

lumbric commented

I had a similar issue and found this thread via Google. It turned out that my issue was not at all connected to this bug.

For some reason there was an empty file named "block.tpl.php" in my theme folder. Maybe I generated the time long time ago, forgot about it and now after clearing the block cache all blocks suddenly disappeared. The solution was quite easy of course: simply rename or delete this file. But it took me some time to locate the cause...

If you are suffering similar troubles: try to change youre theme temporarily. If the blocks reapear using a different theme, your problems are theme related. I also tried to apply an old DB backup. Since this didn't help at all, I started searching the files in the my theme folder.