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.

Comments

TreyeDesigns’s picture

TreyeDesigns commented

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

Karimh’s picture

Karimh commented

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

TreyeDesigns commented

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

Karimh commented

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

Karimh commented

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

sashkernel’s picture

sashkernel commented

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

Cheers.

CarbonPig’s picture

CarbonPig commented

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

karens commented
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

makkon commented

reopen
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

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

quickly commented

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

Matt Habermehl commented

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

spessex’s picture

spessex commented

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

Yuri commented

Any updates on this issue?

skdrupal88’s picture

skdrupal88
Primary language Russian
Location Belarus
commented
Issue summary: View changes
Status: Active » Needs review

Test please my patch, perhaps it will fix the problem.
https://drupal.org/comment/8342915#comment-8342915

mgifford’s picture

mgifford
he/him
Primary language English
commented
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.