Download & Extend
Taxonomy menu » Issues

db_rewrite_sql tid ambiguos

Posted by gunzip on April 8, 2009 at 1:30pm
Project:Taxonomy menu
Version:6.x-2.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

hello when saving a node i get an error:

user warning: Column 'tid' in field list is ambiguous query: SELECT tid FROM term_node LEFT JOIN term_data tac_td ON t.tid = tac_td.tid WHERE (t.tid IN (0, 14) OR tac_td.vid NOT IN (4)) AND ( nid = 0) in /.../htdocs/sites/all/modules/taxonomy_menu/taxonomy_menu.database.inc on line 78.

function _taxonomy_menu_get_node_terms($nid) {
  $output = array();
  $result = db_query(db_rewrite_sql('SELECT tid FROM {term_node} WHERE nid = %d', 't', 'tid'), $nid);

should be

$result = db_query(db_rewrite_sql('SELECT t.tid FROM {term_node} WHERE nid = %d', 't', 'tid'), $nid);
Login or register to post comments

Comments

#1

Posted by gunzip on April 8, 2009 at 1:47pm
Title:db_rewrite_sql tid ambigue» db_rewrite_sql tid ambiguos
Version:master» 6.x-2.x-dev

sorry:

$result = db_query(db_rewrite_sql('SELECT t.tid FROM {term_node} t WHERE nid = %d', 't', 'tid'), $nid);

#2

Posted by indytechcook on April 8, 2009 at 6:48pm

Thanks gunzip. I'll patch this tonight along with the other db_rewrite_sql statements.

#3

Posted by indytechcook on April 8, 2009 at 10:20pm
Status:active» fixed

I committed this fix to DEV. The package should be available within the next 12 hours. Please test and let me know.

Thanks,
Neil

#4

Posted by System Message on April 22, 2009 at 10:30pm
Status:fixed» closed (fixed)

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