Closed (duplicate)
Project:
Image
Version:
6.x-1.0-beta6
Component:
image_gallery
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
25 Sep 2010 at 14:48 UTC
Updated:
27 Sep 2010 at 12:34 UTC
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
Comment #1
joachim commentedThanks 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.)
Comment #2
awelch commentedHi 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).
Comment #3
joachim commented> 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.