NodeReference and NodeAccess generates "user warning: Column 'nid' in where clause is ambiguous query" [#865354]

Here are the specific conditions that generated the error:

- User is not administrator
- Page includes a block view consisting of full nodes that use a CCK NodeReference field
- NodeAccess is enabled

Updating the following function:

function nodereference_field_formatter($field, $item, $formatter, $node) {
..
  if (!isset($titles[$item['nid']])) {
    if ($title = db_result(db_query(db_rewrite_sql("SELECT title FROM {node} WHERE nid=%d"), $item['nid']))) {
      $titles[$item['nid']] = $title ? $title : '';
    }
  }
..
}

to use table aliases as follows:

    if ($title = db_result(db_query(db_rewrite_sql("SELECT n.title FROM {node} n WHERE n.nid=%d"), $item['nid']))) {

removes the error message.

Comment	File	Size	Author
#4	cck-ambiguous_column-865354-4.patch	595 bytes	agileware

Comments

Comment #1

jread commented 3 August 2010 at 18:03

Thanks! Works for me.

Comment #2

yktdan commented 15 August 2010 at 12:13

Priority:

Normal

» Critical

Works for me too, but changing it to critical as I really don't like running with a patched module.

Comment #3

masipila commented 17 August 2010 at 16:42

I can confirm that the problem arises in other (much simpler) scenarios as well and that the same table alias fix works for me too.

I have the following case:

- I have several content types that have nodereferences to other node types. For example, a "team" has references to "players". A "club" has references to "players" as well.

- When viewing a node of the type that has references ("team, club") the problem is triggered. It doesn't take block views for me, it's enough to view any team or club node.

- I have NodeAccess enabled as well.

The table alias fix provided works for me.

I second the request for an official release.