Errors using multiple Dates in Views

Created on 7 January 2009, almost 16 years ago
Updated 3 December 2023, 12 months ago

I have the following problems with Date Fields in Views. I am using PHP 5.2.6, Date Module 6.x-2.0-rc6, CCK Module 6.x-2.1.

1. I have a Content Type containing a Date Field, with "Number of Values" set to Unlimited, and "To Date" set to Never. I am not using the "Repeat Options widget. I have a View which only filters on the Node Type, and outputs the Node Title, Body and the Date field.

*** If I configure the Date field to "Group Multiple Values" (there are multiple values present), then it gives the following error when run:

 warning: implode() [function.implode]: Invalid arguments passed in C:\wamp\www\test\sites\all\modules\date\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 FROM content_field_date node_data_field_date LEFT JOIN node node ON node.vid = node_data_field_date.vid WHERE node.vid IN (1,2) AND ORDER BY node.nid ASC, node_data_field_date.delta ASC in C:\wamp\www\test\sites\all\modules\date\date\date_handler_field_multiple.inc on line 67.  

Clearly the "WHERE ... AND ORDER BY ..." near the end is wrong.

*** If I turn off "Group Multiple Values" then I get no error and (I think the correct output) one entry listed for each date line in each node selected.

2. If I change the configuration of the Date field to use the Repeat Options Widget to create a series of dates, I get the same error when I also set "Group Multiple Values" on the output Date field.

3. (Using the Repeat Options Widget) If I add a Filter to the View to select only certain Dates (e.g. > now) then I no longer get the error above, but:

*** Setting the "Group Multiple Values" option has no effect. All the entries are still listed separately. Adding Distinct=Yes to the Basic Settings makes no difference, unlike the effect if I do the same using simple text fields instead of Dates.

*** Setting "Group Multiple Values" with "Show 1 value(s)" suppresses the display of the Date field in the second and subsequent iterations, but I still get a number of separate entries with other fields displayed.

4. What I am trying to do is:
a) set a Node to have a number of Dates, probably using the Repeat Options Widget,
b) filter a View to only select current dates (e.g. > now)
c) display each date separately in one View (e.g. as basis for a Calendar)
d) display a single entry for each Node in another View (with the initial Date plus Repeat Rule style of display)

With thanks,
Tony

🐛 Bug report
Status

Fixed

Component

Date CCK Field

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024