Hi i'm getting

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/andrewwe/public_html/step/sites/all/modules/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 162.

on a standard view:-

Image gallery: Latest image Latest image

Node: Type = Catalogue item
Node: Published Yes

Comments

joachim’s picture

Status: Active » Closed (duplicate)

Thanks for taking the time to report this issue.

However, I am marking this as a duplicate of #919988: SQL error in image gallery view.

It sounds like you've made changes to the view which may be responsible for the error. Could you give more details over on that other issue please?

(BTW: no need to tag issues in general.)

awelch’s picture

Hi there, I got round this issue by using

Content: Gallery thumbnail2 image linked to node

rather than

image: image

(or any other image related fields).

joachim’s picture

> Content: Gallery thumbnail2 image linked to node

Is that even an image module field? It sounds like you may be using several different image systems together.