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
Comment #1
sdrycroft commentedThe 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".
Comment #2
sdrycroft commentedThis issue has been fixed in the 7.x version of the module, no further development will be carried out on the 6.x version.