sql error after installing tac
| Project: | Taxonomy Access Control |
| Version: | 5.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Hi,
I just installed the module on my site and since then I have started getting sql errors. for example
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 'DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOI' at line 1 query: SELECT n.title, DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( tn.tid IN (8,9,11,12,13,39) AND n.status=1 ) ORDER BY n.created DESC LIMIT 0, 1 in /home/website/public_html/includes/database.mysql.inc on line 172
I need to fix this error urgently and am willing to pay to get this fixed.
Regards

#1
I have a very similar, if not the same problem. The only thing remotely relevant I found is this:
http://www.ubercart.org/issue/1854/view_file_downloads_sql_syntax_error#...
Did you manage to solve the problem? Thanks for any information.
#2
+1 on this. I get this error with both 5.x-1 and 5.x-2.
user warning: 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 'INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((n' at line 1 query: INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 7 AND na.realm = 'content_access_author') OR (na.gid = 2 AND na.realm = 'content_access_rid') OR (na.gid = 8 AND na.realm = 'content_access_rid') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 8 AND na.realm = 'term_access'))) LIMIT 0, 7 in /home/teamwebp/public_html/sandbox1/includes/database.mysql.inc on line 172.