Hello,

When I enable the Taxonomy Block I get the following 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.status = 1 ORDER BY sticky DESC, created DESC LIMIT 5'
query: SELECT DISTINCT(n.nid), n.title, n.body FROM main_term_node t INNER JOIN main_node n ON t.nid = n.nid WHERE t.tid IN () AND n.status = 1 ORDER BY sticky DESC, created DESC LIMIT 5 in /home/www/00/act.greens.org.au/www/public_site/includes/database.mysql.inc on line 66.

Does anyone know what might be causing this, and how to fix it?

Thanks,
sam.

Comments

jjcambefort’s picture

jjcambefort commented

hello
have you created some taxonomy items?
regards
jjc

samwilson’s picture

samwilson commented

I figured it out: I was pointing it to a vocabulary that didn't have any terms in it. That's all. I put a few terms in it, and voila, it works. Still seems like a funny error though...

samwilson’s picture

samwilson commented

Thanks to jjcambefort: that was the problem. :-) All works now...

Anonymous’s picture

(not verified) commented