Hi,

when I edit or add a node as admin there are no problems. But when I do so as any other user I get the following error message - the node is tagged although:

user warning: Column 'tid' in field list is ambiguous query: SELECT tid FROM term_lowername t LEFT JOIN forum_access fa ON t.tid = fa.tid LEFT JOIN acl acl_fa ON acl_fa.name = t.tid AND acl_fa.module = 'forum_access' LEFT JOIN acl_user aclu_fa ON aclu_fa.acl_id = acl_fa.acl_id AND aclu_fa.uid = 5 WHERE ((fa.grant_view >= 1 AND fa.rid IN (2, 8, 20)) OR fa.tid IS NULL OR aclu_fa.uid = 5) AND ( ( lowername LIKE 'almased%1%' ) AND tid NOT IN (SELECT parent FROM term_hierarchy) ) UNION SELECT DISTINCT tid FROM term_synonym t LEFT JOIN forum_access fa ON t.tid = fa.tid LEFT JOIN acl acl_fa ON acl_fa.name = t.tid AND acl_fa.module = 'forum_access' LEFT JOIN acl_user aclu_fa ON aclu_fa.acl_id = acl_fa.acl_id AND aclu_fa.uid = 5 WHERE ((fa.grant_view >= 1 AND fa.rid IN (2, 8, 20)) OR fa.tid IS NULL OR aclu_fa.uid = 5) AND ( ( LOWER(t.name) LIKE 'almased%1%' ) AND tid NOT IN (SELECT parent FROM term_hierarchy) ) in C:\wamp\www\mysite\sites\all\modules\autotag\autotag.ahah.inc on line 213.

Any idea what can cause this error?

Best,
Tobias

Comments

sdrycroft’s picture

The issue is with the autotag module, although, in your case, it is being caused by a hook_rewrite in the forum access module. I'll look at fixing this for the next release. A quick fix will be to change "tid" on lines 202, 209, 218, 222 of autotag.ahah.inc to "t.tid".

sdrycroft’s picture

Issue summary: View changes
Status: Active » Closed (won't fix)

This issue has been fixed in the 7.x version of the module, no further development will be carried out on the 6.x version.