Please tell me any additional information you need so we can understand the problem. This is the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT IN ('38') OR .tid IS NULL)) ORDER BY node_created_created DESC LIMIT 0, 6' at line 1 query: SELECT DISTINCT(node.nid), node.created AS node_created_created FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.type IN ('image')) AND (node.status = '1') AND (term_node.tid IN ('21','16','22','17','18','19','23','20')) AND ((.tid NOT IN ('38') OR .tid IS NULL)) ORDER BY node_created_created DESC LIMIT 0, 6 in /home/cleabcom/public_html/includes/database.mysql.inc on line 172.
I am running views for my homepage only. I have 3 vocabularies with one of the being free tagging. One of the vocabularies is set to only show for a selected role. When a new node (image) is created by anyone, I receive the error. However, if I disable the module and then re-enable the module, everything is fine again.
Thank you.
Mark
Comments
Comment #1
cpugeniusmv commentedI'm not sure if this is a bug in TAC, but it is weird that disabling/reenabling this module will solve your problem.
What happens when you disable TAC, rebuild permissions (admin/content/node-settings/rebuild), and then create an image node? If that causes an error, it's not TAC.
The problem is that the table name is being left out of part of the query generated by Views. I can't imagine what would cause that, we may need to move this over to their issue queue to see if anyone over there might have an idea.
Comment #2
xjmTAC is broken with freetag vocabularies:
#676176: Caching in tac_db_rewrite_sql results in duplicate tags for freetaging vocabularies
#198773: Free tag vocabularies do not respect TAC and may cause duplicate term insertion
So, another thing to test would be whether the problem still occurs when the freetag vocabulary is disabled.
Also, does this still occur with the latest version of views?
Comment #3
xjmClosing issue, since I imagine this has long since been resolved or become irrelevant. Please open a new issue if the bug exists in a current (6.x) release of TAC. Drupal 5 is not long for this world.