Issue Type: Bug Bug
Assignee: Unassigned
Components: www
Created: 16/Apr/13 2:06 PM
Description:

The /images url is broken, and filled with a lot's of PgSQL error:

warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky D... ^ in /usr/share/drupal6/includes/database.pgsql.inc on line 139.
user warning: query: SELECT DISTINCT n.nid from node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( tn.tid IN (21) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 1 OFFSET 0 in /etc/drupal/6/sites/default/modules/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 164.
warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky D... ^ in /usr/share/drupal6/includes/database.pgsql.inc on line 139.
user warning: query: SELECT DISTINCT n.nid from node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( tn.tid IN (21) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 1 OFFSET 0 in /etc/drupal/6/sites/default/modules/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 164.
warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky D... ^ in /usr/share/drupal6/includes/database.pgsql.inc on line 139.
user warning: query: SELECT DISTINCT n.nid from node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( tn.tid IN (22) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 1 OFFSET 0 in /etc/drupal/6/sites/default/modules/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 164.
warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky D... ^ in /usr/share/drupal6/includes/database.pgsql.inc on line 139.
user warning: query: SELECT DISTINCT n.nid from node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( tn.tid IN (22) AND n.type = 'image' AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 1 OFFSET 0 in /etc/drupal/6/sites/default/modules/image/contrib/image_gallery/views/image_gallery_handler_field_gallery_cover.inc on line 164.

Project: Jenkins
Labels: www postgresql
Priority: Minor Minor
Reporter: Adam PAPAI
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira

--
You received this message because you are subscribed to the Google Groups "Jenkins Issues" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
 
 

Reply via email to