Hi there,

I'm using Internationalization and Domain Access Module in Drupal 6 and was just upgrading to the newest version of the internationalization module. When I wanted to create new content, I came across the following error message:

user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM domain_1_locales_source s LEFT JOIN domain_1_i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.location = 'type:lic_book_histoflit:help' in .../modules/i18n/i18nstrings/i18nstrings.module on line 484.

So I checked my tables and saw that while updating the following tables were altered:
# ALTER TABLE {i18n_strings} ADD `objectindex` INT NOT NULL DEFAULT 0
# UPDATE {i18n_strings} SET objectindex = objectid
# ALTER TABLE {i18n_strings} CHANGE `objectid` `objectid` VARCHAR(255) NOT NULL DEFAULT ''
# ALTER TABLE {i18n_strings} ADD `format` INT NOT NULL DEFAULT 0
# ALTER TABLE {i18n_strings} CHANGE `property` `property` VARCHAR(255) NOT NULL DEFAULT

but my domain_XY_i18n_strings-tables are still "old", e.g. do not contain the format-column! I gather that the error message results from my non-compatible domain-access tables (that have not been updated) and that I just have to fire those sql-queries for all my domain_XY_i18n_strings-tables? Maybe you could confirm that, I would really appreciate that ... Anyway, I just wanted to drop the note because there may be other people having the same problem!

Regards,
Lara

Comments

nonsie’s picture

I am guessing you are using Domain Prefix to create different tables per domain? If that is the case please follow the instructions in section 4. Drupal Upgrades of README.txt. In that case there is no problem with i18n module, you simply haven't run updates from each domain.

BenK2’s picture

I think I have the same issues but I can't find any section 4 in the README.txt file of i18n module. Am i looking in the wrong place for the file? I have blank pages for all my multilingual content after upgrade...

nonsie’s picture

Section 4 I was referring to in #2 is in the README.txt of Domain Prefix module.

BenK2’s picture

I am not running that module just the i18n module. The issue is that although the ES content is still available, it is not being displayed when I use the language switcher. The URL of the ES page appears in the browser but the page is blank (this has happened after I upgraded)...
This is the error that my browser displayers when I switch to one of the ES pages.
"Undefined index: external in /var/www/html/includes/language.inc on line 109"
I can find my when around the file system but am no technical expert...do you have any ideas please?

jose reyero’s picture

Status: Active » Fixed

The answer seems to be #1
The post in #4 seems not related to this thread

Status: Fixed » Closed (fixed)

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