I received this today - I onlly have two recipes in and had just completed a test.
I wanted verify admin could "edit" a members recipe
I only receive this error when clicking on "recipes" from Nav menu.
if I go through catagories then the recipes - I do not receive error
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 = '18' ORDER BY n.changed DESC
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 = '18' ORDER BY n.changed DESC LIMIT 0, 50 in /hsphere/local/home/myaccount/mywebsite.com/includes/database.mysql.inc on line 66.
please advise
Comments
Comment #1
green monkey commentedI'm still learing this stuff and sometimes I don't know the difference between a template error an a module code error, I'm just learned about "redeclare" today
If I messed up and this is a tempalte error could you please send me a msg
Comment #2
moshe weitzman commentedare you using an old version of this module? please use latest for your drupal release and empty your cache table as well.
Comment #3
moshe weitzman commentedoops. i should add that the module you need to update is taxonomy_dhtml, not recipe