Unknown column 'n.language' in 'where clause' [#1151514]

when I try to create a feature i keep getting this error

user warning: Unknown column 'n.language' in 'where clause' query: SELECT DISTINCT * FROM filefield_paths WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) in public_html/sites/all/modules/filefield_paths/modules/features.inc on line 46.

Comment	File	Size	Author
#2	filefield_paths-1151514-1-6x1x20110703-D6.patch	578 bytes	kndr
#2

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

FiNeX CreditAttribution: FiNeX commented 4 July 2011 at 13:21

This is like: http://drupal.org/node/941668... the solution is the same. You've to change the filefield_paths_features_export_options() function on file filefield_paths/modules/features.inc:

From:

  $sql = db_rewrite_sql("SELECT * FROM {filefield_paths}");

To:

  $sql = db_rewrite_sql("SELECT * FROM {filefield_paths}","filefield_paths");

Comment #2

kndr

he/him

Polish

Rybnik, Poland

CreditAttribution: kndr commented 20 October 2011 at 09:06

Status:

Active

» Needs review

File	Size
filefield_paths-1151514-1-6x1x20110703-D6.patch	578 bytes

I can confirm this warning. In my opinion, db_rewrite_sql() is useless here. Unfortunatelly #1 doesn't work with "junk" module, which tries to join on nid field. I propose to get rid of this piece of code.