Feed + Date iCal creating nodes with no end time value

Created on 11 November 2014, almost 11 years ago
Updated 22 September 2025, 14 days ago

I'm honestly not sure where to post this bug as I'm not sure if the issue belongs to feeds, Date ical, Calendar or some other interwoven component. Any advice in this matter is appreciated.

What I can report is that after I import a Google calendar using a Feeds importer, I get all the nodes I expect created, but it seems that events that have the same start and end time are imported with the field_data_field_event_date_time.field_event_date_time_value2 (the end time) set to null. So maybe this is a feeds issue or maybe this is a Date iCal issue...

The practical implication of this is that the calendar views don't pick up nodes joined to the field_data_field_event_date_time table where the field_event_date_time_value2 column is null, leaving out these all important event on my site, so perhaps this is a calendar issue? I have the faulty query in hand, but I'm at a loss as as to how the query gets generated, with a combination of views, calendar and date modules acting in a recombinant manner to construct the query (AFAIK)

Anyways, here's the query:


SELECT 
    field_data_field_event_date_time.delta AS field_data_field_event_date_time_delta,
    field_data_field_event_date_time.entity_id AS date_id_field_event_date_time,
    field_data_field_event_date_time.delta AS date_delta_field_event_date_time,
    node.title AS node_title,
    node.nid AS nid,
    field_data_field_event_date_time.language AS field_data_field_event_date_time_language,
    field_data_field_event_date_time.bundle AS field_data_field_event_date_time_bundle,
    field_data_field_event_date_time.field_event_date_time_value AS field_data_field_event_date_time_field_event_date_time_value,
    field_data_field_event_date_time.field_event_date_time_value2 AS field_data_field_event_date_time_field_event_date_time_value_1,
    field_data_field_event_date_time.field_event_date_time_rrule AS field_data_field_event_date_time_field_event_date_time_rrule,
    'node' AS field_data_field_event_date_time_node_entity_type
FROM
    node node
        LEFT JOIN
    field_data_field_event_date_time field_data_field_event_date_time ON node.nid = field_data_field_event_date_time.entity_id
        AND (field_data_field_event_date_time.entity_type = 'node'
        AND field_data_field_event_date_time.deleted = '0')
WHERE
    (((node.status = '1'))
        AND ((DATE_FORMAT(ADDTIME(field_data_field_event_date_time.field_event_date_time_value2,
                    SEC_TO_TIME(- 18000)),
            '%Y-%m') >= '2014-11'
        AND DATE_FORMAT(ADDTIME(field_data_field_event_date_time.field_event_date_time_value,
                    SEC_TO_TIME(- 14400)),
            '%Y-%m') <= '2014-11')))
ORDER BY field_data_field_event_date_time_field_event_date_time_value ASC

and devel says its coming from views_plugin_query_default::execute

πŸ› Bug report
Status

Closed: outdated

Version

3.5

Component

iCal Import

Created by

πŸ‡ΊπŸ‡ΈUnited States jakemonO

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