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

Comments

intu.cz’s picture

intu.cz commented

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.

wonder95’s picture

wonder95 commented
Version: 5.x-1.1 » 5.x-2.x-dev

+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.
xjm’s picture

xjm
she/her
Primary language English
commented
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Marked #198135: TAC with SQL code in theme - does not work as duplicate of this issue.

If this is still an issue in the latest version of 5.x-2.x-dev with the latest version of core, please indicate exactly which pages show this error, or give some steps to reproduce.

xjm’s picture

xjm
she/her
Primary language English
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Closing issue since there is no evidence it exists in D6. Please open a new issue with steps to reproduce this error, database version information, version of Drupal core, and installed modules if you see a query error similar to those listed here.