By Johnson2 on

I am recieving this error whenever I click on the node from my frontpage and directs to

.com/node/12 <- Where the error appears.

user warning: 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 nid ASC' at line 1 query: SELECT n.nid, n.title FROM node n INNER JOIN term_node t ON n.nid = t.nid INNER JOIN term_data r ON t.tid = r.tid WHERE n.type = 'announcements' AND n.nid > 717 AND r.tid = AND n.status = 1 ORDER BY nid ASC in XXX/XXX/XXX/template.php on line 689.

Can you please tell me what am I doing wrong? thank you.

⋅ Categories: Drupal 6.x

Comments

Johnson2’s picture

Johnson2 commented

It's been 2 days, still no support.

davidredshaw’s picture

davidredshaw commented

You're missing a value for r.tid in your WHERE clause:

AND r.tid = SOMETHING AND

David

Johnson2’s picture

Johnson2 commented

Thank you.