addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1launch-new-window--smalllight-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

here is the garbage I am seeing

From: Wolf H.
Sent on: Friday, July 29, 2011 1:44 PM
When I am logged in, this is the first block with a closure 'x' at top right corner
==========
  • warning: pg_query(): Query failed: ERROR: column reference "nid" is ambiguous LINE 19: GROUP BY comments_cid, nid, og_ancestry_nid, spaces_node_ty... ^ in /var/www/html/includes/database.pgsql.inc on line 138.
  • user warning: query: SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid, og_ancestry.nid AS og_ancestry_nid, spaces_node.type AS spaces_node_type, comments.cid AS comments_cid, node.title AS node_title, node_revisions.uid AS node_revisions_uid, comments.uid AS comments_uid, node.changed AS node_changed, node.created AS node_created, comments.timestamp AS atrium_activity_sort, history_user.timestamp AS history_user_timestamp FROM node node INNER JOIN comments comments ON node.nid = comments.nid LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node spaces_node ON node.nid = spaces_node.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (og_ancestry.group_nid = 2) AND (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case', 'casetracker_basic_project')) AND (comments.timestamp > [masked] -[masked])) GROUP BY comments_cid, nid, og_ancestry_nid, spaces_node_type, node_title, node_revisions_uid, comments_uid, node_changed, node_created, atrium_activity_sort, history_user_timestamp UNION ALL (SELECT DISTINCT(node.nid) AS nid, FIRST(og_ancestry.nid) AS og_ancestry_nid, FIRST(spaces_node.type) AS spaces_node_type, FIRST(NULL) AS comments_cid, FIRST(node.title) AS node_title, FIRST(node_revisions.uid) AS node_revisions_uid, FIRST(NULL) AS comments_uid, FIRST(node.changed) AS node_changed, FIRST(node.created) AS node_created, FIRST(node.changed) AS atrium_activity_sort, FIRST(history_user.timestamp) AS history_user_timestamp FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node spaces_node ON node.nid = spaces_node.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (og_ancestry.group_nid = 2) AND (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case', 'casetracker_basic_project')) AND (node.changed > [masked] -[masked])) GROUP BY nid ORDER BY atrium_activity_sort DESC ) ORDER BY atrium_activity_sort DESC ) AS count in /var/www/html/profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 186.
  • warning: pg_query(): Query failed: ERROR: column reference "nid" is ambiguous LINE 19: GROUP BY comments_cid, nid, og_ancestry_nid, spaces_node_ty... ^ in /var/www/html/includes/database.pgsql.inc on line 138.
  • user warning: query: SELECT DISTINCT node.nid AS nid, og_ancestry.nid AS og_ancestry_nid, spaces_node.type AS spaces_node_type, comments.cid AS comments_cid, node.title AS node_title, node_revisions.uid AS node_revisions_uid, comments.uid AS comments_uid, node.changed AS node_changed, node.created AS node_created, comments.timestamp AS atrium_activity_sort, history_user.timestamp AS history_user_timestamp FROM node node INNER JOIN comments comments ON node.nid = comments.nid LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node spaces_node ON node.nid = spaces_node.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (og_ancestry.group_nid = 2) AND (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case', 'casetracker_basic_project')) AND (comments.timestamp > [masked] -[masked])) GROUP BY comments_cid, nid, og_ancestry_nid, spaces_node_type, node_title, node_revisions_uid, comments_uid, node_changed, node_created, atrium_activity_sort, history_user_timestamp UNION ALL (SELECT DISTINCT(node.nid) AS nid, FIRST(og_ancestry.nid) AS og_ancestry_nid, FIRST(spaces_node.type) AS spaces_node_type, FIRST(NULL) AS comments_cid, FIRST(node.title) AS node_title, FIRST(node_revisions.uid) AS node_revisions_uid, FIRST(NULL) AS comments_uid, FIRST(node.changed) AS node_changed, FIRST(node.created) AS node_created, FIRST(node.changed) AS atrium_activity_sort, FIRST(history_user.timestamp) AS history_user_timestamp FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node spaces_node ON node.nid = spaces_node.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (og_ancestry.group_nid = 2) AND (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case', 'casetracker_basic_project')) AND (node.changed > [masked] -[masked])) GROUP BY nid ORDER BY atrium_activity_sort DESC ) ORDER BY atrium_activity_sort DESC LIMIT 15 OFFSET 0 in /var/www/html/profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 186.


--
This Apt Has Super Cow Powers - http://sourcefreedom.com

Our Sponsors

  • Mediacurrent

    2016 Diamond Sponsorship, supporting ADUG and DrupalCamp ATL.

  • Sevaa Group

    2016 Diamond Sponsorship, supporting ADUG and DrupalCamp ATL.

  • Paramount Software

    Diamond Sponsor, because they are awesome!

  • Pantheon

    2016 Platinum Sponsorship, supporting ADUG and DrupalCamp ATL.

  • SiteGround

    2016 Platinum Sponsorship, supporting ADUG and DrupalCamp ATL.

  • Acquia

    2016 Silver Sponsorship, supporting ADUG and DrupalCamp ATL.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy