When attempting to upload an image (node/add/image) without assigning it to a gallery I get this SQL 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 node.status=1 ORDER BY node.created DESC' at line 1 query: SELECT node.nid, node.title, node.created FROM node INNER JOIN term_node ON node.nid = term_node.nid AND term_node.tid= AND node.status=1 ORDER BY node.created DESC in /usr/local/lcds/includes/database.mysql.inc on line 66.

The image is still uploaded, and available for use, for instance it shows up in the popup for img_assist. If I assign it to a Gallery, there is also no problem. However if i go to /node/nid I get the sql error.

This likely has something to do with: "term_node.tid=" as term_node.tid has not been set, causing an improper sql query.

Comments

gnat’s picture

gnat commented
Status: Active » Closed (fixed)

Upon looking more closely, I realized this was something I had done, which only presented itself under the situation described above and had nothing to do with module.