In i18nstrings Module Missing Format Column in i18n_strings Table Triggers SQL Warning Message [#845624]

THE BACKGROUND
============

I had a website which ran a much older version of Drupal 6. I downloaded the live website to my localhost in order to perform an upgrade locally on the site. I used Drush to update the site modules. That went OK. I am currently upgrading to Drupal 6.17. I am using Eclipse to create the workspace locally.

My website is http://www.itwrite.com

The website supports English (Default), Hebrew, and Dutch. The other languages are accessed by the language switcher and only appear on the home page. The language switcher appears in the top right hand corner of the home page.

THE PROBLEM
===========

I have noticed the following behavior so far. When I try to add content or when I try to delete a vocabulary I have received the following error/warning messages. They both come from the same function.

The following error message was received when I tried to create a new page:

* user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'taxonomy' AND s.location = 'term:23:name' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
* user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'taxonomy' AND s.location = 'term:23:description' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
* user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'taxonomy' AND s.location = 'term:48:name' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
* user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'taxonomy' AND s.location = 'term:48:description' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.

The following warning message was received when I tried to delete a vocabulary:

Both problems seem to appear in the following i18nstrings.module module file.

and, come from the following function:

function i18nstrings_get_string($context, $langcode) { }

It appears that in table i18nstrings the format column is missing.

Any help resolving this would be appreciated.

Bye the way, I have noticed a few other sites with exactly the same problem but no solution so far.

Comments

Comment #1

damien tournoud commented 5 July 2010 at 17:23

Project:	Drupal core	» Internationalization
Version:	6.17	» 6.x-1.x-dev
Component:	language system	» Code

Doesn't look like a bug in Drupal core.

Comment #2

jose reyero commented 10 July 2010 at 11:41

Category:	bug	» support
Status:	Active	» Fixed

It seems you are missing some updates (update.php). Run that or renistall the module.

Comment #3

momo18 commented 11 July 2010 at 12:38

Category:	support	» bug
Status:	Fixed	» Active

To the best of my understanding when you update modules through drush you perform an update.php at the same time as well. But anyway, I wanted to reconfirm this so upon your suggestion I performed the following actions as you advised.

I executed the following clear cache command, and I received the subsequent output:

sudo drush cc
Enter a number to choose which cache to clear.
  [0] : Cancel
  [1] : all
  [2] : theme
  [3] : menu
  [4] : css+js
1
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.location = 'type:poll:name' in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM
locales_source s  LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.source = 'Poll' AND i.lid IS NULL in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 530.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.location = 'type:poll:title' in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM
locales_source s  LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.source = 'Question' AND i.lid IS NULL
in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 530.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.location = 'type:poll:body' in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.location = 'type:poll:description' in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM
locales_source s  LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.source = 'A poll is a question with a
set of possible responses. A poll, once created, automatically
provides a simple running count of the number of votes received for
each response.' AND i.lid IS NULL in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 530.
WD php: Unknown column 'i.format' in 'field list'                    [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = 'nodetype' AND s.location = 'type:poll:help' in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
'all' cache was cleared                                              [success]
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.location =
&#039;type:poll:name&#039; in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM
locales_source s  LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.source = &#039;Poll&#039;
AND i.lid IS NULL in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 530.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.location =
&#039;type:poll:title&#039; in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM
locales_source s  LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.source =
&#039;Question&#039; AND i.lid IS NULL in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 530.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.location =
&#039;type:poll:body&#039; in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.location =
&#039;type:poll:description&#039; in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM
locales_source s  LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.source = &#039;A
&lt;em&gt;poll&lt;/em&gt; is a question with a set of possible
responses. A &lt;em&gt;poll&lt;/em&gt;, once created, automatically
provides a simple running count of the number of votes received for
each response.&#039; AND i.lid IS NULL in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 530.
Unknown column &#039;i.format&#039; in &#039;field list&#039;        [error]
query: SELECT s.*, i.type, i.objectid, i.property, i.format  FROM
locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE
s.textgroup = &#039;nodetype&#039; AND s.location =
&#039;type:poll:help&#039; in
/opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module
on line 525.
An error occurred at function : drush_core_cache_clear               [error]
moses@moses-laptop:/opt/lampp/htdocs/testprojectl$

Then in order to reconfirm I executed an update.php and this is the output I received:

    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.location = 'type:poll:name' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.source = 'Poll' AND i.lid IS NULL in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 530.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.location = 'type:poll:title' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.source = 'Question' AND i.lid IS NULL in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 530.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.location = 'type:poll:body' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.location = 'type:poll:description' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.source = 'A <em>poll</em> is a question with a set of possible responses. A <em>poll</em>, once created, automatically provides a simple running count of the number of votes received for each response.' AND i.lid IS NULL in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 530.
    * user warning: Unknown column 'i.format' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property, i.format FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'nodetype' AND s.location = 'type:poll:help' in /opt/lampp/htdocs/testprojectl/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 525.

Meanwhile, it seems like the bug is still there.

Thanks!

Comment #4

Anonymous (not verified) commented 5 August 2010 at 19:52

EGUAL or similar problems with i18 new modules group for translate (at 5 - august - 2010 ) :

I have udate all (module plus core) the version is 6.17
Have a solution ? Thanks for all your help and collaborative response!!

Comment #5

momo18 commented 9 August 2010 at 15:44

Jose didn't provide a satisfying answer. If one runs update.php it doesn't trigger the required SQL scripts and make the required database changes. And if I disable and then reinstall the i18n module I stand to lose all of the valuable multi-language data that I already have in my database. Pity nobody can provide a satisfying answer.

I think there's a design flaw in Drupal especially when it comes to updating modules, which depend on other modules, which depend on other modules. It is not a problem to disable any number of modules if you don't have any data in the database. But if your database is populated, you stand to corrupt your data.

It seems to me that certain database changes need to be made by hand or by executing an SQL script in order to preserve the database integrity.

Comment #6

momo18 commented 26 August 2010 at 14:13

Status:

Active

» Fixed

I resolved the problem by _manually_ executing the following SQL commands through the Phpmyadmin interface:

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

I could not find any other solution suggested so far acceptable such as turning on and off modules, re-executing install scripts etc., because the database is already populated and turning on and off modules would have destroyed the existing database information.

The solution came from the following web address:

http://drupal.org/node/736252

PS: I had to remove the { } braces surrounding the table names for compatibility reasons.

As far as I can tell so far the problem seems to have gone away and this solution resolves it.

http://www.itwrite.com
Technical Writing & Website Development

Comment #7

9 September 2010 at 14:20

Status:

Fixed

» Closed (fixed)

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

Comment #8

avior commented 15 August 2011 at 03:52

Component:

Code

» Blocks

Same problem here
The sql code in #6 (http://drupal.org/node/845624#comment-3374840)
did not work for me

the solution i have comed with is
1. rename i18nstrings table (or delete it)
2. run update.php and manually select i18nstring 5900 update - this will build the i18nstrings table with the correct structure , before you do it you must change the i18nstrings_update_skip variable (variables table) value from i:1 to i:0

hope this will help someone

Good Luck

Comment #9

saml commented 27 August 2011 at 19:58

Thanks avion! #8 seems to have solved the problem for me!

So, i did, in a mysql console (or can be done in phpMyAdmin):

drop table i18n_strings;
update variable set value="i:0" where name="i18nstrings_update_skip";

... then went to update.php and ran the 5900 update (and then the 6006 one).

Comment #10

avior commented 28 August 2011 at 20:58

Happy this helped you, because i have wasted a lot of time on it
:-)

In i18nstrings Module Missing Format Column in i18n_strings Table Triggers SQL Warning Message

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

Comment #10

News items

Our community

Documentation

Drupal code base

Governance of community