Using:
d6.6
Views 6.x-2.1
Views Calc 6.x-1.0-rc
Calendar: 6.x-2.0-rc6
Date:6.x-2.0-rc6
Mysql5.0.51a
php 5.2.6
Server: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

I have a Calendar view working as expected. I have made a display of that view of the style= "Views Calc Table".
This too works fine, that is when I browse to the path of this display it loads and displays the results I expect as a table.

Until I attempt to get a calculation, as follows:

When I go in and edit the basic settings of the display to calculate any of the columns I hope to be able to calculate, a cck field of type=decimal, save the display and view and then visit the url I get:

Fatal error: Call to a member function get_option() on a non-object in (truncated by poster)/sites/all/modules/views/includes/view.inc on line 1772

Thanks for any help,
TV

Comments

karens’s picture

karens commented
Status: Active » Postponed (maintainer needs more info)

I'm totally confused about why you would be mixing Views calc tables with calendars, that doesn't make any sense to me. Irregardless, all the affected modules have had updates that could affect what you're trying to do. You'll need the latest -dev code for Date and Calendar and Views Calc, and for Views Calc you'll have to either get it directly from cvs now or wait until tomorrow to get the -dev tarball that has today's fixes.

Toddv’s picture

Toddv commented

I just mentioned the calendar to state that the view was working properly and as expect for other displays. The view I want to calculate is just a table, it has nothing to do with my calendar view... I have content type="event", which displays in a calendar, and associated blocks (upcoming, etc). But we also track statistics associated with the events in cck fields. I later total these cck fields in a views calc view.

I'll look at which are out of date - the status page in my installation states that I'm up to date but I may have a dev version here or there. I figured this would get straightened out w/ updates, just wanted to report. So - let's keep this open for a week or two, I'll have a chance to look at updates and settings, and clarify if there's still an issue.

Thanks very much for your work on these projects!
TV

Toddv’s picture

Toddv commented

Still having a problem.

I have updated all my modules.

I tried both views_calc-6.x-1.x-dev.tar and views_calc-6.x-1.0.tar, both from January 16, 2009
I have a simple test views.calc view with the following columns:
node title
node start date (cck field)
Number of adults present

Start date is an exposed field and the visitor can filter by year. When the page is first loaded the error message occurs but if I then choose a date filter the view refreshes as expected, without error, filtered to the year (but erroneously calculated as reported in #362268). In other words, if the filter is set to all years, I get the sql error. But if I filter by any of the year options, no error.

I'm trying to calculate the total number of adults (which produces another problem which I will post separately (http://drupal.org/node/362268)

Both module versions produce this error (a Date error? ((if so, sorry for posting in the wrong place))):

warning: implode() [function.implode]: Invalid arguments passed in /home/foi/public_html/foi/sites/all/modules/olddate/date/date_handler_field_multiple.inc on line 65.
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 'ORDER BY node.nid ASC, node_data_field_date.delta ASC' at line 1 query: SELECT node.vid AS _vid, node_data_field_date.delta as _delta, node.nid AS _nid, node_data_field_date.field_date_value AS value, node_data_field_date.field_date_value2 AS value2, node_data_field_date.field_date_rrule AS rrule FROM content_field_date node_data_field_date LEFT JOIN node node ON node.vid = node_data_field_date.vid WHERE node.vid IN (truncated by poster, lengthy set of numbers...) AND ORDER BY node.nid ASC, node_data_field_date.delta ASC in /home/foi/public_html/foi/sites/all/modules/olddate/date/date_handler_field_multiple.inc on line 67.

Thanks very much for any help on this-
TV

Toddv’s picture

Toddv commented
Status: Postponed (maintainer needs more info) » Active
Toddv’s picture

Toddv commented
Status: Active » Closed (fixed)