Hi,
I got this user warning:

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 'IN ('147')) AND (.tid IN ('170')) AND (term_node.tid IS NULL) AND ((node.type NO' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, node.title AS node_title FROM Kiesje_node node LEFT JOIN Kiesje_term_node term_node ON node.nid = term_node.nid AND term_node.tid IN ('2266','2265','2262','2264','2263','2261') INNER JOIN Kiesje_term_node multidomain_tn ON multidomain_tn.nid = node.nid WHERE (multidomain_tn.tid = 1764) AND ( (node.status = '1') AND (.tid IN ('147')) AND (.tid IN ('170')) AND (term_node.tid IS NULL) AND ((node.type NOT IN ('page') OR node.type IS NULL)) ) GROUP BY node.nid, node_sticky, node_title ORDER BY node_sticky DESC, node_title ASC LIMIT 0, 10 in /home/public_html/includes/database.mysql.inc on line 172. 

It looks like a variable for .tid is somewhere not set. See: AND (.tid IN ('147')) AND (.tid IN ('170'))
I can't find though where to correct this.

Please assist!

Thanks in advance!
Greetings,
Martijn

Comments

summit’s picture

Status: Active » Closed (fixed)

Hi,
It looks like this error is a error which comes up with updating taxonomy_image to version 1.2. See this thread for following this error: http://drupal.org/node/239621. Sorry to disturb your module with this wrong error-issue.
Greetings,
Martijn