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

jasonwhat’s picture

I second this.

tdog’s picture

I'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.

Thox’s picture

Assigned: Unassigned » Thox

AFAIK, 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.

shyam2053’s picture

I am getting the same errors but lots more about 7 or 8 of them.

marble’s picture

Anyone able to reproduce this with the current CVS code?

green monkey’s picture

closed on age - if request still active - please resubmit

green monkey’s picture

Status: Active » Closed (fixed)