Доброе время суток, у меня возникла проблема с OpenAtrium. Установил я его на веб сервер, и сразу же
при первом запуске он выдает ошибку:
<?phpwarning: 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/dr6_atr/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 (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case',
'casetracker_basic_project')) AND (comments.timestamp > (1319425587 - 2592000)) 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 (node.type IN ('blog', 'book', 'event',
'casetracker_basic_case', 'casetracker_basic_project')) AND (node.changed > (1319425587 - 2592000)) GROUP BY nid ORDER BY
atrium_activity_sort DESC ) ORDER BY atrium_activity_sort DESC ) AS count in
/var/www/dr6_atr/profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 187.
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/dr6_atr/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 (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case', 'casetracker_basic_project')) AND
(comments.timestamp > (1319425587 - 2592000)) 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 (node.type IN ('blog', 'book', 'event', 'casetracker_basic_case', 'casetracker_basic_project')) AND (node.changed > (1319425587
- 2592000)) GROUP BY nid ORDER BY atrium_activity_sort DESC ) ORDER BY atrium_activity_sort DESC LIMIT 15 OFFSET 0 in
/var/www/dr6_atr/profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 187.?>
Может кто сталкивался с таким? Гугл мало какой инфы выдает
CMS: Drupal6
БД: Postgres
Комментарии
А кто сказал, что на Postgress оно будет работать?
А нигде и не написано что оно не работает с Postgress. Меня интересует, что может быть кто нибудь сталкивался с подобным
Как это - "нигде не написано"? У них в Issue tracker есть открытые баги.
Как бы да - ни разу не вижу, что здесь написана поддержка PostgressSQL https://community.openatrium.com/documentation-en/node/2238#server
Да я не спорю, что есть баги. Меня как раз таки и интересует, что может быть кто то сталкивался с этой багой.
Если есть в трекере, значит сталкивались. И как я вижу, их разработчики даже не решали.