Hello,

I am having this warning when editing custom content types:

user warning: Unknown column 'status' in 'field list' query: UPDATE locales_target SET status = 1 WHERE lid = 2590 in /htdocs/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 448.

Could anyone tell me what does that mean and how to solve it? I've performed a search in drupal.org but didn't find any information.

Thank you very much

Comments

Rar9’s picture

Got the same Problem... any hint what to do your that?

user warning: Unknown column 'status' in 'field list' query: UPDATE locales_target SET status = 1 WHERE lid = 2850 in httpdocs/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 448.

the lid goes from 2850 to 2853 :-)

By what I notice that taxonomies aren´t synced correctly anymore

wuh’s picture

Title: What does this warning means? » Unknown column 'status' in 'field list' query

* This is a poor issue title - can someone please update it to something more relevant?

Problem:

On updating i18n strings using the Translate Interface tool, the following warning is displayed twice:

user warning: Unknown column 'status' in 'field list' query: UPDATE locales_target SET status = 0 WHERE lid = 1986 AND language = 'fi' in /home/wuh/public_html/ecobohemia.rootsydev.co.uk/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 216.

This does not seem to affect the usability of the module, but it could be having an adverse effect somewhere that I haven't spotted.

pluess’s picture

Component: Miscellaneous » Code
Category: support » bug

Same here.

It tries to update a column in the table . But this column does not exist.

j0nathan’s picture

Same warning message with different lid when running update.php.

jim005’s picture

same problem for me ! any solution ?

c-c-m’s picture

Is there something that can be done to solve this behaviour? I have not found any pattern to reproduce: this warning still appears randomly (at least for me), mostly when I edit content.

Vote_Sizing_Steve’s picture

Subscribing.

Vote_Sizing_Steve’s picture

I successfully ran ALTER TABLE locales_target CHANGE `status` `i18n_status` INT NOT NULL DEFAULT 0 in my navicat sql - perhaps the brackets part of the broken update.php's ALTER TABLE {locales_target} CHANGE `status` `i18n_status` INT NOT NULL DEFAULT 0 are causing the error?

jasom’s picture

Component: Code » Blocks

I just update i18n from 6.x-1.7 to 6.x-1.9 and have this message after update.php script was done:


user warning: Unknown column 'status' in 'locales_target' query: ALTER TABLE locales_target CHANGE `status` `i18n_status` INT NOT NULL DEFAULT 0 in /www/includes/database.mysql-common.inc on line 528.

castawaybcn’s picture

Version: 6.x-1.7 » 6.x-1.10

Same error, does not seem to have any other side effects, but I am not entirely sure.

diond’s picture

This issue also affected my fresh install of 7.x i18n module in D7. There's a chance it may affect the updating of certain strings on the site. Try changing the display name of one of your Content Types and see if you are successful. This field that is missing in the {locales_target} table is responsible for telling the i18n & i18n_status modules as to what translations need updating (nice feature to have).

BTW the brackets {} around the table name are supposed to be there and a good feature. Those brackets allow Drupal to automatically affix any "DB table prefixes" that may be used on a site.

SOLUTION: I just went into my PHPMyAdmin, opened the {locales_target} table, and manually added the missing DB field (Added an INT field with Default value 0, NOT NULL, and 11 long). All my translations and updates have worked since ;) Hope this helps.

Pascal.s’s picture

I had the same problem after updating i18n module to the last version in D6. I went to my database, select all tables and "repare table". Seems to have fix the problem for me so far!

joseph.olstad’s picture

Issue summary: View changes
Status: Active » Closed (outdated)