No Integration with Views Custom Field

Same problem here. I got this error when trying to load the view where I was trying to calculate the total of a custom field:

• user warning: Unknown column 'customfield.phpcode' in 'field list' query: SELECT MAX('') AS node_title, MAX('SUM') AS TOTAL_SUM, MAX('') AS node_data_field_project_assigned_field_project_assigned_uid, MAX('') AS node_data_field_assignee_payed_field_project_bounty_value, MAX('') AS node_data_field_assignee_payed_field_project_manager_uid, MAX('') AS node_data_field_assignee_payed_field_project_price_value, MAX('') AS workflow_states_state, MAX('') AS node_data_field_assignee_payed_field_assignee_payed_value, MAX('') AS node_data_field_assignee_payed_field_project_billable_value, SUM(customfield.phpcode) AS customfield_phpcode_8, MAX('') AS node_data_field_assignee_payed_field_sold_by_uid, SUM(customfield.phpcode) AS customfield_phpcode_10 FROM node node LEFT JOIN content_type_y_project node_data_field_assignee_payed ON node.vid = node_data_field_assignee_payed.vid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN content_field_project_assigned node_data_field_project_assigned ON node.vid = node_data_field_project_assigned.vid LEFT JOIN workflow_states workflow_states ON workflow_node.sid = workflow_states.sid LEFT JOIN content_type_y_project node_data_field_project_bounty ON node.vid = node_data_field_project_bounty.vid LEFT JOIN content_type_y_project node_data_field_project_manager ON node.vid = node_data_field_project_manager.vid LEFT JOIN content_type_y_project node_data_field_project_price ON node.vid = node_data_field_project_price.vid LEFT JOIN content_type_y_project node_data_field_project_billable ON node.vid = node_data_field_project_billable.vid LEFT JOIN content_type_y_project node_data_field_sold_by ON node.vid = node_data_field_sold_by.vid WHERE ((node_data_field_assignee_payed.field_assignee_payed_value) = ('Not Payed')) AND ((node_data_field_assignee_payed.field_project_billable_value) = ('Billed')) AND (node.type in ('y_project')) AND (workflow_node.sid = 6) in /public_html/modules/views/includes/view.inc on line 769.
• warning: Invalid argument supplied for foreach() in /public_html/modules/views_calc/theme.inc on line 180.

This is the code I have to determine the value of the custom field:

<?php $pm_bounty = (($data->node_data_field_assignee_payed_field_project_price_value) * 0.15);
$pm_bounty_final = round($pm_bounty, 2);
echo "$" . $pm_bounty_final; ?>

Basically I'm calculating another value based off of another field. I'm wondering if Views Calc is trying to calculate the php rather than the resulting value?
I thought that it may also be that in this custom field I am adding a $ sign which may be messing up the calculation also but when I removed it I had the same result.

Any help here?

Thanks!

I just noticed that the first error I listed above does not appear to have anything to do with views calc. However I never had this appear before I tried using views calc and when I switched back to the normal table style the error went away. So what might be the relation here?

I'd like to confirm this error.

I use Custom Fields to add two PHP generated columns to my view. Those two columns I try to make a SUM of via the Calc module.

The results is the error below :

# user warning: Unknown column 'customfield.phpcode' in 'field list' query: SELECT MAX('') AS node_data_field_rekening_wouter_field_type_value, MAX('SUM') AS TOTAL_SUM, MAX('') AS node_data_field_rekening_wouter_field_rekening_wouter_value, MAX('') AS node_data_field_rekening_wouter_field_date_value, MAX('') AS node_data_field_rekening_wouter_field_date_invoice_value, MAX('') AS node_title, SUM(customfield.phpcode) AS customfield_phpcode_6, SUM(customfield.phpcode) AS customfield_phpcode_7 FROM node node LEFT JOIN content_type_transactie node_data_field_rekening_wouter ON node.vid = node_data_field_rekening_wouter.vid WHERE (node.type in ('transactie')) AND (node_data_field_rekening_wouter.field_rekening_wouter_value IS NOT NULL) AND (node.nid IN (520,519,518,513,507,517)) ORDER BY node_data_field_rekening_wouter_field_date_value DESC LIMIT 0, 10 in /Users/wvdbosch/Development/MAMP/dough_finances/sites/all/modules/views/includes/view.inc on line 755.

# user warning: Unknown column 'customfield.phpcode' in 'field list' query: SELECT MAX('') AS node_data_field_rekening_wouter_field_type_value, MAX('SUM') AS TOTAL_SUM, MAX('') AS node_data_field_rekening_wouter_field_rekening_wouter_value, MAX('') AS node_data_field_rekening_wouter_field_date_value, MAX('') AS node_data_field_rekening_wouter_field_date_invoice_value, MAX('') AS node_title, SUM(customfield.phpcode) AS customfield_phpcode_6, SUM(customfield.phpcode) AS customfield_phpcode_7 FROM node node LEFT JOIN content_type_transactie node_data_field_rekening_wouter ON node.vid = node_data_field_rekening_wouter.vid LEFT JOIN content_type_transactie node_data_field_type ON node.vid = node_data_field_type.vid LEFT JOIN content_type_transactie node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_type_transactie node_data_field_date_invoice ON node.vid = node_data_field_date_invoice.vid WHERE (node.type in ('transactie')) AND (node_data_field_rekening_wouter.field_rekening_wouter_value IS NOT NULL) in /Users/wvdbosch/Development/MAMP/dough_finances/sites/all/modules/views/includes/view.inc on line 759.

The PHP generated columns work just fine without the calculations.

Best regards,
Wouter

subscribing

subscribing

subscribing

I had the same problem as deggertson (reply nr 2):
1. disabled and uninstalled views calc.
2. update core to 6.15
3. downgrade views 3.0 dev version to stable 2.8
4. ran cron
5 reinstalled patched views calc ie theme.inc is patched (there's a 'line 178' patch around that seems to do something)

Error went away. I still have logic errors I haven't got to the bottom of yet. Still working on those.

Hope this helps

PS there was no particular logic to why I cleaned up drupal, as above, just intuition!

UPDATE: Error only 'appeared' to go away!

I tried the above steps, no luck.

having the same problem with this php

<?php
$total = $data->uc_orders_order_total;
$cost = $data->uc_order_products_cost;

$profit = $total - $cost;
print ($profit);
?>

I just changed the code to 4 and got the same error, and then I tried a views global text with just 4 again and that also returns the same problem?
It has to be a views calc issue.

Hello,
I have the same problem.
When i remove the [Sort criteria], it's works fine.
I was try other version views ,and Views Calc module,but also erro~
I think the Sort criteria with the Views Calc Table - Sortable 《Conflict》
Hope it will help you
Sorry for my broken english.
Good luck

I´ve been looking to be able to set a specific field with the difference between two views calc result, and not just two fields.

I´ve read that this code

<?php
$total = $data->uc_orders_order_total;
$cost = $data->uc_order_products_cost;

$profit = $total - $cost;
print ($profit);
?>

Won´t work (using Views Custom Field).

How can I sum all post with the field X and rest all posts with the field Y?

Thanks in advance for your help!

Rosamunda

simpler problem here.

I'm using Views Custom Field to output a series of integer numbers (one per row), then adding such numbers with Views Calc. it returns an error, even with my code checking to see if they're all integers.

anyway..... subscribing. o/

user warning: Unknown column 'customfield.phpcode' in 'field list' query: SELECT MAX('') AS

I'm still having this exact same problem. Has no one found a fix yet?

Try dev release once and report result.

Note that views custom field calculates all data on the theming layer using PHP. Views Calc uses SQL to build the result.

It is absolutely impossibly to consider view custom field php code during the rendering process of Views Calc - since it is executed much before Views Custom Field does its calculations. We architecturally won't be able to fix this.

If you need more custom calculations, add them by SQL using the views calc fields.

Miro, what you said makes sense, altough it would be nice to have custom field and views calc compatible.

My problem with views calc is this. I need to preproces field value before i can make calculation. From what i see I can't use PHP code in views calc field to do this, right? Can i make some custom function in "Allowable functions and operators:" to do this preprocessing?

What i want to do is to get a simple Avarage AGE from my users, to get age i need to preprocess their date od birth which is not hard when using custom field. Maybe a custom field for views calc field would be a good idea to solve this problem?