user warning: Column: 'nid' in field list is ambiguous query: SELECT nid,type,title,uid,created,src,dst FROM drupal_node LEFT JOIN drupal_url_alias ON CONCAT('node/', nid) = src

Change line 203 from:

  $query = 'SELECT nid,type,title,uid,created,src,dst FROM {node} '.
    "LEFT JOIN {url_alias} ON CONCAT('node/', nid) = src";

to:

	$query = 'SELECT n.nid, type, title, uid, created, src, dst'
		. ' FROM {node} n'
		. "LEFT JOIN {url_alias} ON CONCAT('node/', n.nid) = src";

petermoulding.com/web_architect

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented

I assume you are talking about pathauto_node.inc, right?

It took a little searching to see what you were talking about, but your suggested fix makes sense. Care to provide a patch?

Thanks

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Closed (fixed)

I'm going to fix this in http://drupal.org/node/69789 since it hits that same query. Thanks for the report.