// $Id: node.inc,v 1.1.2.7 2008/02/20 11:04:18 ax Exp $

On adding node context an SQL error appears:
user warning: Unknown column 'n.nid' in 'where clause' query: SELECT * FROM node WHERE n.nid = 7 in .....\includes\database.mysql.inc on line 172.

There's an n missing in the FROM part

File panels\contexts\node.inc, line 67 was:

    $info = db_fetch_object(db_query("SELECT * FROM {node} WHERE n.nid = %d", $conf['nid']));

Changed to:

    $info = db_fetch_object(db_query("SELECT * FROM {node} n WHERE n.nid = %d", $conf['nid']));

Comments

sdboyer’s picture

Status: Active » Closed (duplicate)

This issue has already been fixed in -dev: #243844: Fix query in node context.