I'm working with Format: Views Calc Table in Views so I can't calculate AVG of some fields and I don't understand this error. Can any one help me please.


TreyeDesigns’s picture

I am having the same problem. Looking for a solution / work around. Let me know if you come up with anything.

Karimh’s picture

I found what was the problem: the views_calc 7.x-1.x-dev can't be used with views 3, it's consist with views 2 so you have to install views 2 first and empty all sql filds table and then install views_calc 7.x-1.x-dev . It works well now. I want to calculate SUM, AVG... by group in views but grouping_by module does not exist yet in drupal 7.

TreyeDesigns’s picture

Are you talking about grouping by inside views. You can use "Use aggregation" and set it to "yes" this will group the fields though I personally have not had much luck using this.

You said that Views Calc can only be used with Views 2. However There is only Views 3 for D7, what version of Views are you using to get the Calc module to work properly?

Karimh’s picture

Hi, I'm sorry! I want to say views_calc 7.x-1.x-dev (http://drupal.org/node/67344/release) works properly with Views 7.x-3.0-beta3 ( http://drupal.org/node/1107716).

Karimh’s picture

I can't see "Use aggregation" in views to group the fields to calculate SUM or AVG. In which place can I find it?

sashkernel’s picture

Same problem. I use views 3.1 downgrading to beta is not a good solution for me. Does anyone know any other workaround?


CarbonPig’s picture

I'm having the same error issue. Tried testing for a few hours, but can't get it to work. Looking forward to ideas.

KarenS’s picture

Status: Active » Fixed

This part of the code should be working now.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

makkon’s picture

i try dev and 1.0 ->
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_commerce_price.commerce_price_amount' in 'field list'

commerce_price - relationship for content view (drupal commerce)

makkon’s picture

Status: Closed (fixed) » Active
quickly’s picture

I am having this issue only if I use global fields and try to apply aggregation functions on them... any solution?

Matt Habermehl’s picture

This problem appears to happen when trying to calculate fields that have been brought into the view via relationships.

spessex’s picture

I'm having exactly the same problem on both recommend release and dev version (D7). Keep getting:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_quote_total_ex_vat_.field_quote_total_ex_vat__value' in 'field list'

As Matt suggests above I have a complicated view with many relationships.

This is module is integral to my whole site unfortunately!

Yuri’s picture

Any updates on this issue?

skorzh’s picture

Issue summary: View changes
Status: Active » Needs review

Test please my patch, perhaps it will fix the problem.

mgifford’s picture

Status: Needs review » Postponed (maintainer needs more info)

Ok, there was a change that was committed 11 months ago that might fix this. Let's mark this postponed until we can confirm that this is still a problem.