Posted by kpm on November 16, 2007 at 2:21am
Jump to:
| Project: | OG Galleries |
| Version: | 5.x-1.7 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (won't fix) |
Issue Summary
I am using OG_Galleries, and read the install instructions...
I enabled the og_galleries view and under the 'fields' section I added node 'display image' and edited the Filters section for 'node type' 'is one of' and then highlighted only 'image'.
But I can't seem to get beyond this error each time I click on the 'galleries' link:
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 '13,11,21,59,61))) )' at line 1 query: SELECT count(DISTINCT(og_galleries.gid)) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN vocabulary vocabulary ON term_data.vid = vocabulary.vid LEFT JOIN og_galleries og_galleries ON vocabulary.vid = og_galleries.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 8 AND na.realm = 'og_subscriber') OR (na.gid = 13 AND na.realm = 'og_subscriber') OR (na.gid = 11 AND na.realm = 'og_subscriber') OR (na.gid = 21 AND na.realm = 'og_subscriber') OR (na.gid = 59 AND na.realm = 'og_subscriber') OR (na.gid = 61 AND na.realm = 'og_subscriber'))) AND ( (node.status = '1') AND (node.type IN ('image')) AND ((og_galleries.gid IN (0,8,,13,11,21,59,61))) ) in C:\www\drupal\includes\database.mysql.inc on line 172.
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 '13,11,21,59,61))) ) GROUP BY og_galleries.gid, node_sticky, node_created_created' at line 1 query: SELECT og_galleries.gid, og_galleries.gid AS gid, count( DISTINCT(node.nid)) AS num_nodes, node.sticky AS node_sticky, node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN vocabulary vocabulary ON term_data.vid = vocabulary.vid LEFT JOIN og_galleries og_galleries ON vocabulary.vid = og_galleries.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 8 AND na.realm = 'og_subscriber') OR (na.gid = 13 AND na.realm = 'og_subscriber') OR (na.gid = 11 AND na.realm = 'og_subscriber') OR (na.gid = 21 AND na.realm = 'og_subscriber') OR (na.gid = 59 AND na.realm = 'og_subscriber') OR (na.gid = 61 AND na.realm = 'og_subscriber'))) AND ( (node.status = '1') AND (node.type IN ('image')) AND ((og_galleries.gid IN (0,8,,13,11,21,59,61))) ) GROUP BY og_galleries.gid, node_sticky, node_created_created ORDER BY node_sticky DESC, node_created_created DESC LIMIT 0, 10 in C:\www\drupal\includes\database.mysql.inc on line 172. I am sure I am missing something in the configuration, can any one clue me in?
Thanks
Comments
#1
I also have this error, but it only happens in the main gallery view. Sub-gallery views are fine. It has to do with the arguments of the view somehow. When you edit the View, go to Arguements and if you set the "Og Galleries: Group nid" Default to "Display All Values" (or anything but Summary
), the error does not come up.
#2
Thanks! That solved it for me to.
#3
I am using the subgroups module. I don't know if that has any impact on this issue.
#4
Old issue. This version is no longer being maintained. We are moving to Views Gallery for D6.