Here is the 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 '(15.nid) FROM url_alias a INNER JOIN node n ON a.src = CONCAT('
query: SELECT n.DISTINCT(15.nid) FROM url_alias a INNER JOIN node n ON a.src = CONCAT('node/', n.nid) WHERE n.status = 1 AND a.dst LIKE 'recipe/%' ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/lambert/public_html/civic2/includes/database.mysql.inc on line 66.

Home

The URL to the recipe itself works just fine. But when I click on "recipe," one level up in the breadcrumb trail, I get this error. What's going on?

I'm trying to get a site up that uses this terrific module, and so I have taken the liberty of marking this one critical. Thanks for any help anyone can give!

Comments

lambert-1’s picture

lambert-1 CreditAttribution: lambert-1 commented

I forgot to say that I am not using the taxonomy.dhtml module.

Thox’s picture

Thox CreditAttribution: Thox commented

Can you list which modules you are using on the site? The "15" in the SQL is the problem, and yet I have no idea how it can get there. There have been reports of similar (but all different) SQL problems. I can only assume that another Drupal module is changing the query and breaking it.

drawk’s picture

drawk CreditAttribution: drawk commented

Is this really still an issue? The original poster never responded, and it keeps showing up on the "release critical bugs" mailings.

marble’s picture

marble CreditAttribution: marble commented
Status: Active » Closed (fixed)

I'm unable to reproduce this either, so I think we should close it until/unless someone who can reproduce it can supply more information.