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
Comment #1
intu.cz commentedI 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.
Comment #2
wonder95 commented+1 on this. I get this error with both 5.x-1 and 5.x-2.
Comment #3
xjmMarked #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.
Comment #4
xjmClosing 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.