Hi,
Fresh open atrium beta8 install, updated views to 3.alpha3.
Needed to change the following, because of this error:
PHP Fatal error: Call to undefined method views_plugin_display_block::get_cache_plugin() in /profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 97

Patch http://drupal.org/files/issues/nodecomment.module.cache_.patch needed because of same issue as http://drupal.org/node/908258
   $cache = !empty($view->live_preview) ? FALSE : $view->display_handler->get_plugin('cache');

But now I got following errors:

    * user warning: The used SELECT statements have a different number of columns query: SELECT COUNT(*) FROM (SELECT DISTINCT og_ancestry.nid AS og_ancestry_nid, spaces_node.type AS spaces_node_type, comments.cid AS comments_cid, node.nid AS nid, 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 portfolio_node node INNER JOIN portfolio_comments comments ON node.nid = comments.nid LEFT JOIN portfolio_og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN portfolio_node spaces_node ON node.nid = spaces_node.nid LEFT JOIN portfolio_node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN portfolio_history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.type IN ('blog', 'book', 'casetracker_basic_case', 'casetracker_basic_project')) AND (comments.timestamp > (1286223746 - 2592000)) GROUP BY comments_cid, og_ancestry_nid, spaces_node_type, nid, 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_1, og_ancestry.nid AS og_ancestry_nid, spaces_node.type AS spaces_node_type, NULL AS comments_cid, node.nid AS nid, node.title AS node_title, node_revisions.uid AS node_revisions_uid, NULL AS comments_uid, node.changed AS node_changed, node.created AS node_created, node.changed AS atrium_activity_sort, history_user.timestamp AS history_user_timestamp FROM portfolio_node node LEFT JOIN portfolio_og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN portfolio_node spaces_node ON node.nid = spaces_node.nid LEFT JOIN portfolio_node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN portfolio_history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.type IN ('blog', 'book', 'casetracker_basic_case', 'casetracker_basic_project')) AND (node.changed > (1286223746 - 2592000)) GROUP BY nid_1 ORDER BY atrium_activity_sort DESC ) ORDER BY atrium_activity_sort DESC ) AS count in /var/www/vhosts/portfolio-manager.nl/httpdocs/profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 187.
    * warning: Division by zero in /var/www/vhosts/portfolio-manager.nl/httpdocs/includes/pager.inc on line 73.
    * user warning: The used SELECT statements have a different number of columns query: SELECT DISTINCT og_ancestry.nid AS og_ancestry_nid, spaces_node.type AS spaces_node_type, comments.cid AS comments_cid, node.nid AS nid, 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 portfolio_node node INNER JOIN portfolio_comments comments ON node.nid = comments.nid LEFT JOIN portfolio_og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN portfolio_node spaces_node ON node.nid = spaces_node.nid LEFT JOIN portfolio_node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN portfolio_history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.type IN ('blog', 'book', 'casetracker_basic_case', 'casetracker_basic_project')) AND (comments.timestamp > (1286223746 - 2592000)) GROUP BY comments_cid, og_ancestry_nid, spaces_node_type, nid, 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_1, og_ancestry.nid AS og_ancestry_nid, spaces_node.type AS spaces_node_type, NULL AS comments_cid, node.nid AS nid, node.title AS node_title, node_revisions.uid AS node_revisions_uid, NULL AS comments_uid, node.changed AS node_changed, node.created AS node_created, node.changed AS atrium_activity_sort, history_user.timestamp AS history_user_timestamp FROM portfolio_node node LEFT JOIN portfolio_og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN portfolio_node spaces_node ON node.nid = spaces_node.nid LEFT JOIN portfolio_node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN portfolio_history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.type IN ('blog', 'book', 'casetracker_basic_case', 'casetracker_basic_project')) AND (node.changed > (1286223746 - 2592000)) GROUP BY nid_1 ORDER BY atrium_activity_sort DESC ) ORDER BY atrium_activity_sort DESC LIMIT 0, 0 in /var/www/vhosts/portfolio-manager.nl/httpdocs/profiles/openatrium/modules/atrium_features/atrium_activity/atrium_activity.views.inc on line 187.

Thanks a lot for your reply!
greetings,
Martijn

Comments

summit’s picture

summit’s picture

Hi, I think it has to do with something wrong in the count query in atrium_activity.views.inc, see: http://drupal.org/node/173947 for something similar. The count_query is in atrium_activity.views.inc, but may be not correctly coded?
greetings, Martijn

danielbeeke2’s picture

hey,

if you comment this line:

//$main = str_replace('ORDER BY', " UNION ALL ({$subquery}) ORDER BY ", $main);

it works

so the bug is in that line,.

mpotter’s picture

Version: » 6.x-1.2
Status: Active » Closed (won't fix)

Closing old D6 issues.