A feeds import that worked previously stopped working after enabling languages. I receive this error for every node failed to import: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lang_fr' in 'field list'.
The content type it's importing into is set to allow for translation, but also allows Language Neutral nodes.

Comments

danny_joris’s picture

danny_joris commented
Issue summary: View changes
danny_joris’s picture

danny_joris commented
Status: Active » Closed (fixed)

Resolved by setting the content type multilingual support from 'Enabled, with translation' to just 'Enabled'.

danny_joris’s picture

danny_joris commented
Status: Closed (fixed) » Active

... but this means I don't have a translation tab. I had to import my nodes and then switch the translation setting on the content type. That shouldn't be necessary.

Edit: That doesn't work either, actually. Clicking the translation tab throws this error:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lang_fr' in 'field list': INSERT INTO {translation_overview_priority} (tnid, lang_en, lang_fr) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 502 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 ) in drupal_write_record() (line 7194 of /home/mysite/mysite.com/includes/common.inc).
danny_joris’s picture

danny_joris commented
Title: Feeds import failing » Unable to translate nodes
Project: Feeds » Translation Overview
Version: 7.x-2.0-alpha8 » 7.x-2.0-beta1
Category: Support request » Bug report

It seems that translation_overview was the culprit. Everything works as expected after disabling this module. The error also happened when attempting to translate the node the normal way.

james.williams’s picture

james.williams
Location Coventry, UK
commented
Status: Active » Closed (duplicate)
Related issues: +#1403832: Error when trying to add an organic group - PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lang_hi' in 'f, +#350702: detect languages that were added when translation_overview was not active, +#925128: Columns are not created at translation_overview_priority when adding languages

Closing as a duplicate of the related issues.