I'm having a rather strange problem. Views Calc does not sum correctly unless a user has the "administer node" permission enabled. It adds more, as if it's including additional values. I first noticed this problem with version Views Calc 6.x-1.3. I updated to the dev version and am still having this issue.

I suspect there's a conflict with another module, but haven't pinpointed it yet. I have Views: 6.x-2.12 running on Drupal 6.20.

I've been banging my head looking for a solution but can't seem to find one other than enabling administer node permission for everyone, which I'm not going to do. Any idea what's going on here?

Comments

solemanus’s picture

solemanus CreditAttribution: solemanus commented

I disabled the content access module. This seemed to solve the problem.

Francewhoa’s picture

Francewhoa
he/him
Primary language French
Location Sept-Îles, Québec, 🇨🇦
CreditAttribution: Francewhoa commented

Views Calc does not sum correctly unless a user has the "administer node" permission enabled.

Confirming this issue with Views Calc 1.3. Details and steps to reproduce at:
http://drupal.org/node/340334#comment-4955242
http://drupal.org/node/340334#comment-4970704

dpatte’s picture

dpatte CreditAttribution: dpatte commented

I am not using content access, but I am using organic groups. Inconsistantly I see sums that include doubling of some of the columns values. Stangely, if I update the nodes being totalled, the problem often corrects itself.

This is using the latest released version. Should I try the dev version?

JCB’s picture

JCB CreditAttribution: JCB commented

Seems like there was a core problem with Node Module.

I applied the patch at comment #127
(http://drupal.org/node/681760#comment-4371188)

Here is link to patch:
http://drupal.org/files/issues/681760_node_access-127-D6.patch

Solved my problem

pvanerk’s picture

pvanerk CreditAttribution: pvanerk commented

The patch mentioned in #4 solved the double (or triple) sum in combination with OG.

pvanerk’s picture

pvanerk CreditAttribution: pvanerk commented
Status: Active » Closed (duplicate)
eclauset’s picture

eclauset CreditAttribution: eclauset commented

I am seeing the same issue (views calc sum is doubled) but for all users. The patch linked above does not change the result.

ashzade’s picture

ashzade CreditAttribution: ashzade commented

Is there a patch for D7? Views Calc is summing x4.

P.Selfin’s picture

P.Selfin CreditAttribution: P.Selfin commented

subscribe. Some problem in 7.x-1.0