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
Comment #1
summit commentedMay be something to do with: http://stackoverflow.com/questions/3655708/the-used-select-statements-ha... and things like: http://drupal.org/node/457034
greetings, Martijn
Comment #2
summit commentedHi, 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
Comment #3
danielbeeke2 commentedhey,
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,.
Comment #4
mpotter commentedClosing old D6 issues.