The following error is produced when saving an image to the gallery. It also appears when selecting (clicking on) the image node from the gallery. However, when the image thumbnail itself is then selected the image displays correctly.

* 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.type = 'image' AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIM' at line 1 query: SELECT n.nid from node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid = AND n.type = 'image' AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 1 in /home/content/04/6716304/html/sites/all/modules/image-6.x-1.0/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 164.
* 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.type = 'image' AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIM' at line 1 query: SELECT n.nid from node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid = AND n.type = 'image' AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 1 in /home/content/04/6716304/html/sites/all/modules/image-6.x-1.0/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 164.

Comments

joachim’s picture

Status: Active » Closed (duplicate)

I've seen this empty tid problem before in the issue queue -- could you search for the original issue please?