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

Re: [drupal-4] here is the garbage I am seeing

From: Ben C.
Sent on: Friday, July 29, 2011 2:30 PM
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 7/29/2011 1:45 PM, Wolf Halton wrote:
> When I am logged in, this is the first block with a closure 'x' at
> top right cornern ==========
> 
> * 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/includ­es/database.pgsql.in­c 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.timesta­mp AS
> history_user_timesta­mp 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_n­id = 2) AND (node.type IN ('blog', 'book',
> 'event', 'casetracker_basic_c­ase', 'casetracker_basic_p­roject')) 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_timesta­mp UNION ALL (SELECT
> DISTINCT(node.nid) AS nid, FIRST(og_ancestry.ni­d) AS og_ancestry_nid,
> FIRST(spaces_node.ty­pe) 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.t­imestamp) AS 
> history_user_timesta­mp 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_n­id = 2) AND (node.type IN
> ('blog', 'book', 'event', 'casetracker_basic_c­ase', 
> 'casetracker_basic_p­roject')) 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/profil­es/openatrium/module­s/atrium_features/at­rium_activity/atrium­_activity.views.inc
>
> 
on line 186.

It's not garbage, it's an error message.  Looks like you're running
OpenAtrium with PostgreSQL, and you're running into code in OpenAtrium
that isn't PostgreSQL-compatibl­e.  I have no problem with PostgreSQL
(we're a PostgreSQL shop here, and try to avoid MySQL when we can), but
as most people running Drupal use MySQL, Drupal doesn't get as well
tested on PostgreSQL as it does on Drupal.  Occasionally, you're going
to run into PostgreSQL incompatibilities.  You need to report this to
the community forums at OpenAtrium, and see if you can get someone there
to help with getting a patch to make the code PostgreSQL-compatibl­e.

Ben
- -- 
Ben Coleman  <[address removed]>
CTO, Accelerated Design, Inc.
(770)[masked]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (MingW32)
Comment: Gnu Privacy Tools
Comment: Download at http://www.gnupt....­
Comment: Using GnuPG with Mozilla - http://enigmail.m...­

iEYEARECAAYFAk4y/E0A­CgkQMnVileOE5KPKEQCg­qzK8MkKZnwEil8SpELtM­XA4h
+YAAn3sLKYtQo4/CEcz1­c60D7c+GONvS
=nmIh
-----END PGP SIGNATURE-----

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