Hi,

I'm trying to realize on my website a 2-level navigation with a primary horizontal menu at the top and a secondary vertically to the left of the screen. I don't want the 1st-level entries to appear on the 2nd-level menu. So I found this useful page http://drupal.org/node/49720#comment-94151 and did it like this.

my problem is that i get, after enabling some taxonomy_blocks in the administer -> blocks an sql 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 0' 
query: SELECT DISTINCT(n.nid), n.title, n.body FROM term_node t INNER JOIN node n ON t.nid = n.nid WHERE t.tid IN () AND n.status = 1 ORDER BY sticky DESC, created DESC LIMIT 0 in /srv/www/htdocs/web58/html/netzwerk-nicaragua/includes/database.mysql.inc on line 66.

The blocks that the website shows has links "more" and this sql-error occurs just with the blocks where the "more"-link is http://url.com/?q=taxonomy/term/
without numbers for the terms. the "more"-link of the first block (without error) has all term numbers http://url.com/?q=taxonomy/term/1+3+4+6+9+7+8+10
so i think it must have something to do with that errror, but i'm not really shure.
Another wierd thing was, that in the "more"-link above with all the term numbers, there is no number 2. and i looked in the url aliases and found there as well no number two, so has my problem something to do with the pathauto?? i deleted all aliases and it is still the same problem.

i'm pretty new in using drupal and hope you guys can help me out.
Thanks!

Comments

Anonymous’s picture

i got it to work with drupal 4.7.1
no problems