Hi,

I installed the module to use it with a text field in a custom content type. I changed the widget of the text field to this module and the field formatter in Panels (I'm using panels to change how the fields are shown to the user) and I get the following error:

   * user warning: Unknown column 'n.language' in 'where clause' query: SELECT nid FROM node WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL) AND ( title = 'Tertulia Bar' AND type IN ('local')) in /home/vitanocturna.com/public/sites/all/modules/text_noderef/text_noderef.module on line 288.
   * user warning: Unknown column 'n.language' in 'where clause' query: SELECT nid FROM node WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL) AND ( title = 'Open Trole' AND type IN ('local')) in /home/vitanocturna.com/public/sites/all/modules/text_noderef/text_noderef.module on line 288.

being "Tertulia Bar" and "Open Trole" the nodes titles and "local" the custom content type. My site is using i18n to manage multilanguage and is working in spanish (es) and english (en)

Is there something I missed?

Thanks,

Diego

CommentFileSizeAuthor
#1 text-noderef-i18n.patch732 bytesdrifter

Comments

drifter’s picture

drifter commented
Status: Active » Needs review
StatusFileSize
new text-noderef-i18n.patch732 bytes

Had the same issue, the node table doesn't get the "n" alias in row 288, see attached patch.

BTW thanks for the module Boobaa, saved me lots of work today :)

boobaa’s picture

boobaa
he/him
commented
Status: Needs review » Fixed

Though neither of you described how to reproduce the issue, the patch seems to be fine, applied for the 6.x-1.x branch. Kudos for drifter--submit proper git patches next time, please!

Anyway, this issue seems to be related to #1094898: User warning: Column 'nid' in field list is ambiguous query

Status: Fixed » Closed (fixed)

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