For more info, see

http://drupal.org/node/702176#comment-2626490

I have cross-linked with the original post.

Hope to get views-calc to work nicely with views-group-by bounty of aggregation at query level.

Regards
Bakr

CommentFileSizeAuthor
#5 Capture-view_calc-1.JPG79.52 KBcashwilliams
#1 Capture-vc3.JPG39.79 KBbakr

Comments

bakr’s picture

bakr commented
StatusFileSize
new Capture-vc3.JPG39.79 KB

I have faced another issue:

A fresh installation of drupal and latest views and cck

whereby the views-group-by is disabled.

kartelusm’s picture

kartelusm commented

Hi again,
Yes, I forgot to mention that in views_groupby patch thread, it happened to me also while I was testing for that issue. It appears that if you don't check any of the "display calculation" fields you get a bunch of warnings. This is also an issue with views 2.6 version.

bakr’s picture

bakr commented

Hmm,

Very true.

In addition - as a follow up, I've checked the "display calculation fields". ... still though .... the last footer row(s), which views-calc shout append to the html table does not show up!!

It could it be some version incompatibility issue due to some recent code rewrite !

I am facing the issue on:

views 2.8
cck 2.6
dupal 6.15

(tested on a fresh installation as well as on a beefed drupal site)

bakr’s picture

bakr commented

Any feedback from community about compatibility issues between:

Views 2.8
ViewsCalc 6.x-1.3

???

cashwilliams’s picture

cashwilliams commented
StatusFileSize
new Capture-view_calc-1.JPG79.52 KB

I think I'm experiencing the same bug.

I have view_groupby producing a column for me, and when I enable views_calc, it blows up.

Below is the error.

--->
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid), MAX('SUM') AS TOTAL_SUM, MAX('') AS node_title, SUM' at line 1 query: SELECT MAX('') AS DISTINCT(node.nid), MAX('SUM') AS TOTAL_SUM, MAX('') AS node_title, SUM(track_hours_entry.duration) AS track_hours_entry_duration, MAX('') AS node_created, MAX('') AS unknown FROM node node INNER JOIN content_type_nis_task node_data_field_question_project ON node.vid = node_data_field_question_project.vid LEFT JOIN track_hours_entry track_hours_entry ON node.nid = track_hours_entry.nid WHERE (node.status <> 0) AND (node.type in ('nis_task')) AND (node_data_field_question_project.field_question_project_nid = '22') in /websites/drupal/drupal-6.x/sites/all/modules/views/includes/view.inc on line 759.
warning: Invalid argument supplied for foreach() in /websites/drupal/drupal-6.x/sites/all/modules/views_calc/theme.inc on line 180.
warning: Invalid argument supplied for foreach() in /websites/drupal/drupal-6.x/sites/all/modules/views_calc/theme.inc on line 180.
warning: Invalid argument supplied for foreach() in /websites/drupal/drupal-6.x/sites/all/modules/views_calc/theme.inc on line 180.

Jukebox’s picture

Jukebox commented

I have simply given up on views calc for the moment. From the description on the module page, it seemed like it provided the functionality I was looking for. However I have wrestled with both the stable and dev releases and both of them were error prone. Both releases haven't been updated for months...I am hoping that the maintainers haven't forgotten about this module.

miro_dietiker’s picture

miro_dietiker
Location Switzerland
commented
Status: Active » Closed (works as designed)

Fixed many issues.
This post is not about a clear single issue, pleas focus for maintainability.

Specific topics are present in separate issues, please update there.

In order to make things work, participate development instead.