I just installed the recipe mod and get this 3 times on the /recipe main page. Kinda new to drupal.org so not sure if I'm doing something wrong.
user 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 'AND n.type = 'recipe' AND r.tid = '4' ORDER BY n.changed DESC L
query: SELECT n.nid, n.title, n.type, u.uid, u.name FROM term_node r LEFT JOIN node n ON r.nid = n.nid LEFT JOIN users u ON n.uid = u.uid WHERE AND n.type = 'recipe' AND r.tid = '4' ORDER BY n.changed DESC LIMIT 0, 50 in C:\!WEB\sites\seniorbachelorettes.com\httpdocs\includes\database.mysql.inc on line 66.
user 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 'AND n.type = 'recipe' AND r.tid = '3' ORDER BY n.changed DESC L
query: SELECT n.nid, n.title, n.type, u.uid, u.name FROM term_node r LEFT JOIN node n ON r.nid = n.nid LEFT JOIN users u ON n.uid = u.uid WHERE AND n.type = 'recipe' AND r.tid = '3' ORDER BY n.changed DESC LIMIT 0, 50 in C:\!WEB\sites\seniorbachelorettes.com\httpdocs\includes\database.mysql.inc on line 66.
user 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 'AND n.type = 'recipe' AND r.tid = '5' ORDER BY n.changed DESC L
query: SELECT n.nid, n.title, n.type, u.uid, u.name FROM term_node r LEFT JOIN node n ON r.nid = n.nid LEFT JOIN users u ON n.uid = u.uid WHERE AND n.type = 'recipe' AND r.tid = '5' ORDER BY n.changed DESC LIMIT 0, 50 in C:\!WEB\sites\seniorbachelorettes.com\httpdocs\includes\database.mysql.inc on line 66.
Comments
Comment #1
jasonwhat commentedI second this.
Comment #2
tdog commentedI'm using the CVS version and noted the same behavior. I believe that the issue lies somewhere in a conflict with the taxonomy_dhtml module. When this module is turned off the error goes away.
Comment #3
Thox commentedAFAIK, the problem is not the SQL in the module. It seems db_rewrite_sql() is breaking the SQL. I'll look into this some more.
Comment #4
shyam2053 commentedI am getting the same errors but lots more about 7 or 8 of them.
Comment #5
marble commentedAnyone able to reproduce this with the current CVS code?
Comment #6
green monkey commentedclosed on age - if request still active - please resubmit
Comment #7
green monkey commented