I have a number of views (page & blocks) on my site where repeating events do not display the date & time any instances other than the first. For example, if I have a "Study" each Wednesday at 12:00 when I load the date corresponding to the first instance of that event the date & time appear, if I go forward a week to the event appears but the date and time are blank. Below are exports of a view that does not display date & time correctly (first view) and one that does display date & time correctly (second view.) Can someone help me understand why this has changed and if there is an easy solution? Recreating these views would take a significant amount of time (about 10 custom views for displaying events in specialized categories.)
VIEW THAT DOES NOT DISPLAY DATE & TIME
==================================
$view = new stdClass();
$view->name = 'upChildrenVol';
$view->description = 'Volunteer Opportunties: Children';
$view->access = array (
);
$view->view_args_php = '';
$view->page = FALSE;
$view->page_title = '';
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = '';
$view->page_empty_format = '1';
$view->page_type = 'node';
$view->url = '';
$view->use_pager = TRUE;
$view->nodes_per_page = '10';
$view->block = TRUE;
$view->block_title = 'Upcoming Events';
$view->block_header = '';
$view->block_header_format = '1';
$view->block_footer = '';
$view->block_footer_format = '1';
$view->block_empty = '';
$view->block_empty_format = '1';
$view->block_type = 'list';
$view->nodes_per_block = '3';
$view->block_more = FALSE;
$view->block_use_page_header = FALSE;
$view->block_use_page_footer = FALSE;
$view->block_use_page_empty = FALSE;
$view->sort = array (
array (
'tablename' => 'node_data_field_priority',
'field' => 'field_priority_value',
'sortorder' => 'ASC',
'options' => '',
),
array (
'tablename' => 'node_data_field_date_and_time',
'field' => 'field_date_and_time_value',
'sortorder' => 'ASC',
'options' => '',
),
);
$view->argument = array (
);
$view->field = array (
array (
'tablename' => 'node',
'field' => 'title',
'label' => '',
'handler' => 'views_handler_field_nodelink',
'options' => 'link',
),
array (
'tablename' => 'node_data_field_date_and_time',
'field' => 'field_date_and_time_value',
'label' => '',
'handler' => 'date_views_field_handler_ungroup',
'options' => 'default',
),
);
$view->filter = array (
array (
'tablename' => 'node',
'field' => 'type',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => 'volunteer',
),
),
array (
'tablename' => 'node_data_field_date_and_time',
'field' => 'field_date_and_time_value_default',
'operator' => '>=',
'options' => 'now',
'value' => '',
),
array (
'tablename' => 'term_node_1',
'field' => 'tid',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => '66',
1 => '70',
2 => '68',
3 => '67',
4 => '69',
),
),
);
$view->exposed_filter = array (
);
$view->requires = array(node_data_field_priority, node_data_field_date_and_time, node, term_node_1);
$views[$view->name] = $view;
VIEW THAT DOES DISPLAY DATE & TIME CORRECTLY
==========================================
$view = new stdClass();
$view->name = 'events';
$view->description = 'Calendar view of any date field, add a date field to the view to use it.';
$view->access = array (
);
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = 'Calendar';
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = '';
$view->page_empty_format = '1';
$view->page_type = 'calendar';
$view->url = 'events';
$view->use_pager = FALSE;
$view->nodes_per_page = '0';
$view->block = TRUE;
$view->block_title = 'Calendar';
$view->block_header = '';
$view->block_header_format = '1';
$view->block_footer = '';
$view->block_footer_format = '1';
$view->block_empty = '';
$view->block_empty_format = '1';
$view->block_type = 'calendar';
$view->nodes_per_block = '999';
$view->block_more = TRUE;
$view->block_use_page_header = FALSE;
$view->block_use_page_footer = FALSE;
$view->block_use_page_empty = FALSE;
$view->sort = array (
array (
'tablename' => 'node_data_field_date_and_time',
'field' => 'field_date_and_time_value',
'sortorder' => 'ASC',
'options' => '',
),
);
$view->argument = array (
array (
'type' => 'calendar_year',
'argdefault' => '2',
'title' => '%1',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
array (
'type' => 'calendar_month',
'argdefault' => '2',
'title' => '%2',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
array (
'type' => 'calendar_day',
'argdefault' => '2',
'title' => '%3',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
array (
'type' => 'calendar_ical',
'argdefault' => '2',
'title' => '%4',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array (
array (
'tablename' => 'node_data_field_date_and_time',
'field' => 'field_date_and_time_value',
'label' => 'Time',
'handler' => 'date_views_field_handler_ungroup',
'options' => 'default',
),
array (
'tablename' => 'node',
'field' => 'title',
'label' => 'Event',
'handler' => 'views_handler_field_nodelink',
'options' => 'link',
),
array (
'tablename' => 'node_data_field_location',
'field' => 'field_location_value',
'label' => 'Location',
'handler' => 'content_views_field_handler_group',
'options' => 'default',
),
);
$view->filter = array (
array (
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array (
'tablename' => 'node',
'field' => 'type',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => 'calendar_event',
),
),
array (
'tablename' => 'term_node_1',
'field' => 'tid',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => '8',
1 => '64',
2 => '63',
3 => '65',
4 => '10',
5 => '100',
6 => '80',
7 => '84',
8 => '85',
9 => '83',
10 => '81',
11 => '82',
12 => '66',
13 => '70',
14 => '68',
15 => '67',
16 => '69',
17 => '105',
18 => '16',
19 => '2',
20 => '76',
21 => '79',
22 => '77',
23 => '78',
24 => '60',
25 => '22',
26 => '102',
27 => '20',
28 => '3',
29 => '101',
30 => '21',
31 => '1',
32 => '17',
33 => '93',
34 => '14',
35 => '18',
36 => '13',
37 => '99',
38 => '15',
39 => '9',
40 => '7',
41 => '94',
42 => '59',
43 => '98',
44 => '11',
45 => '23',
46 => '104',
47 => '5',
48 => '72',
49 => '75',
50 => '74',
),
),
array (
'tablename' => 'node_data_field_location',
'field' => 'field_location_value_default',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => 'Outdoor Worship Area',
1 => 'Outdoor Amphitheater',
2 => 'Parking Lot',
3 => 'Retreat Center',
4 => 'Lord of Life',
5 => 'Great Hall',
6 => 'Worship Center',
7 => 'Family Life Center',
8 => 'Chapel',
9 => 'Conference Room',
10 => 'Music Room',
11 => 'Quiet Room',
12 => 'Small Kitchen',
13 => 'Faith Walk Café',
14 => 'Room 101',
15 => 'Room 102',
16 => 'Room 103',
17 => 'Room 104',
18 => 'Room 105',
19 => 'Room 106',
20 => 'Room 107',
21 => 'Room 108',
22 => 'Room 109',
23 => 'Room 110',
24 => 'Room 111',
25 => 'Room 113',
26 => 'Room 114',
27 => 'Room 115',
28 => 'Room 116',
29 => 'Room 117',
30 => 'Other',
),
),
array (
'tablename' => 'term_node_3',
'field' => 'tid',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => '54',
1 => '56',
2 => '55',
3 => '57',
),
),
array (
'tablename' => 'term_node_4',
'field' => 'tid',
'operator' => 'NOR',
'options' => '',
'value' => array (
0 => '87',
1 => '92',
2 => '90',
3 => '89',
4 => '91',
5 => '88',
),
),
);
$view->exposed_filter = array (
array (
'tablename' => 'term_node_1',
'field' => 'tid',
'label' => 'Category',
'optional' => '1',
'is_default' => '0',
'operator' => '1',
'single' => '1',
),
array (
'tablename' => 'node_data_field_location',
'field' => 'field_location_value_default',
'label' => 'Location',
'optional' => '1',
'is_default' => '0',
'operator' => '1',
'single' => '1',
),
);
$view->requires = array(node_data_field_date_and_time, node, node_data_field_location, term_node_1, term_node_3, term_node_4);
$views[$view->name] = $view;
Comments
Comment #1
karens commentedI can't reproduce any problem in the latest code. See http://drupal.org/project/calendar for troubleshooting tips and a links to the latest code.
Comment #2
jeggen commentedKaren,
Seems that this MAY be a duplicate of http://drupal.org/node/352753. I have tested in Date 2.6 w/ Calendar 2.6 as well as the current dev release of both and still am experiencing the same issue. I have updated the Calendar Event content type, definitely run update.php w/ each module update and have even run db_query("DELETE FROM {cache};"); which I have read will delete the Drupal cache. I still have the same problem with different results in different views. See links below:
Not working: http://sandbox.sheridanlutheran.org/events/today
Working: http://sandbox.sheridanlutheran.org/events/2009/03/27
You will also notice that in many blocks events that are repeated (see upcoming events on this page)
http://sandbox.sheridanlutheran.org/learn/children
Comment #3
jeggen commentedComment #4
jeggen commentedAny updates on this issue? I think it should still be active since I do not see a resolution to this in the latest Calendar/Date releases.
Comment #5
jeggen commentedI have retested this issue again and still find that the date/time do not appear for many repeating events in certain views. Aside from recreating the views (43 views w/ custom lists) I cannot find any resolution to this issue. Opening a view and editing the fields does not resolve the issue nor does editing the fields for the Calendar content type.
Comment #6
karens commentedThe D5 versions are end of life now, no longer supported. Sorry.