Not showing Content: some-date-field. [#1616574]

As discussed with Tim on IRC just now, I'm opening up an issue.

I create a content type, add a Date to it, then create a FullCalendar using that Date. It wont show any entries on the calendar, though they show up in the view when I use unfomatted list. Here is the exported view as requested by Tim.

$view = new view;
$view->name = 'events_calendar';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'events calendar';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'events calendar';
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'none';
$handler->display->display_options['style_plugin'] = 'fullcalendar';
$handler->display->display_options['style_options']['weekMode'] = 'variable';
$handler->display->display_options['style_options']['fields']['date_field'] = array(
  'field_date_time' => 'field_date_time',
);
$handler->display->display_options['style_options']['fields']['date'] = TRUE;
$handler->display->display_options['style_options']['fullcalendar_options']['firstHour'] = 0;
$handler->display->display_options['style_options']['fullcalendar_options']['dayClick'] = TRUE;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: date time */
$handler->display->display_options['fields']['field_date_time']['id'] = 'field_date_time';
$handler->display->display_options['fields']['field_date_time']['table'] = 'field_data_field_date_time';
$handler->display->display_options['fields']['field_date_time']['field'] = 'field_date_time';
$handler->display->display_options['fields']['field_date_time']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_date_time']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_date_time']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_date_time']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_date_time']['element_type'] = '0';
$handler->display->display_options['fields']['field_date_time']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_date_time']['element_wrapper_type'] = '0';
$handler->display->display_options['fields']['field_date_time']['element_default_classes'] = 0;
$handler->display->display_options['fields']['field_date_time']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_date_time']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_date_time']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['field_date_time']['settings'] = array(
  'format_type' => 'short',
  'fromto' => 'both',
  'multiple_number' => '',
  'multiple_from' => '',
  'multiple_to' => '',
  'show_repeat_rule' => 'show',
);
$handler->display->display_options['fields']['field_date_time']['group_rows'] = 1;
$handler->display->display_options['fields']['field_date_time']['delta_offset'] = '0';
$handler->display->display_options['fields']['field_date_time']['delta_reversed'] = 0;
$handler->display->display_options['fields']['field_date_time']['delta_first_last'] = 0;
$handler->display->display_options['fields']['field_date_time']['field_api_classes'] = 1;
/* Sort criterion: Content: Post date */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'events-calendar';
$translatables['events_calendar'] = array(
  t('Master'),
  t('events calendar'),
  t('more'),
  t('Apply'),
  t('Reset'),
  t('Sort by'),
  t('Asc'),
  t('Desc'),
  t('date time'),
  t('Page'),
);

Comments

Comment #1

onefang CreditAttribution: onefang commented 4 June 2012 at 15:52

This might be useful to.

mysql> explain field_data_field_date_time;
+-----------------------+------------------+------+-----+---------+-------+
| Field                 | Type             | Null | Key | Default | Extra |
+-----------------------+------------------+------+-----+---------+-------+
| entity_type           | varchar(128)     | NO   | PRI |         |       |
| bundle                | varchar(128)     | NO   | MUL |         |       |
| deleted               | tinyint(4)       | NO   | PRI | 0       |       |
| entity_id             | int(10) unsigned | NO   | PRI | NULL    |       |
| revision_id           | int(10) unsigned | YES  | MUL | NULL    |       |
| language              | varchar(32)      | NO   | PRI |         |       |
| delta                 | int(10) unsigned | NO   | PRI | NULL    |       |
| field_date_time_value | datetime         | YES  |     | NULL    |       |
| field_date_time_rrule | text             | YES  |     | NULL    |       |
+-----------------------+------------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

mysql> select * from field_data_field_date_time;
+-------------+--------+---------+-----------+-------------+----------+-------+-----------------------+-----------------------+
| entity_type | bundle | deleted | entity_id | revision_id | language | delta | field_date_time_value | field_date_time_rrule |
+-------------+--------+---------+-----------+-------------+----------+-------+-----------------------+-----------------------+
| node        | page   |       0 |        13 |          15 | und      |     0 | 2012-12-12 02:12:00   | NULL                  |
| node        | event  |       0 |      2132 |        2134 | und      |     0 | 2012-06-06 17:00:00   | NULL                  |
+-------------+--------+---------+-----------+-------------+----------+-------+-----------------------+-----------------------+

Comment #2

onefang CreditAttribution: onefang commented 4 June 2012 at 17:28

Status:

Active

» Closed (works as designed)

For some reason the production server defaulted to a whole bunch of different style settings for the date field. Putting it back to "Add default classes" solved this problem. Closing this as "works as designed", but perhaps that style thing is a different issue? Or might have been a glitch.

Comment #3

rsgracey CreditAttribution: rsgracey commented 6 June 2012 at 14:19

I'm having terribly frustrating variations of this issue, I think. If I create a new FullCalendar view, then add the date, but remove the content title (because I don't want it to be there), it still shows up, no matter how many times I clear the cache or save the view. I try to add new fields, but they also don't appear, even when saved and the cache cleared.

Even when creating a new view, it remembers the settings from a view that I've already deleted.

I've cleared caches repeatedly, but it doesn't seem to have any effect, with Drush, too.