Hello!

My site uses GMT+0300 timezone, configurable time zones are not allowed.

My CCK node type contains Datestamp field:

$content[type]  = array (
  'name' => 'Test',
  'type' => 'test',
  'description' => '',
  'title_label' => 'Header',
  'body_label' => 'Body',
  'min_word_count' => '0',
  'help' => '',
  'node_options' => 
  array (
    'status' => true,
    'promote' => false,
    'sticky' => false,
    'revision' => false,
  ),
  'old_type' => 'test',
  'orig_type' => '',
  'module' => 'node',
  'custom' => '1',
  'modified' => '1',
  'locked' => '0',
);
$content[fields]  = array (
  0 => 
  array (
    'widget_type' => 'date_js',
    'label' => 'Test',
    'weight' => '-4',
    'description' => '',
    'required' => '1',
    'multiple' => '0',
    'granularity' => 
    array (
      'Y' => 'Y',
      'M' => 'M',
      'D' => 'D',
      'H' => 'H',
      'N' => 'N',
    ),
    'todate' => '',
    'input_format' => 'site-wide',
    'input_format_custom' => 'd.m.y - H:i',
    'output_format_date' => 'd.m.Y - H:i',
    'output_format_zone' => '',
    'output_format_custom' => 'd.m.y - H:i',
    'output_format_date_long' => 'd.m.Y',
    'output_format_zone_long' => '',
    'output_format_custom_long' => 'l, j F Y г. - H:i',
    'output_format_date_medium' => 'd.m.Y',
    'output_format_zone_medium' => '',
    'output_format_custom_medium' => 'D, d.m.y - H:i',
    'output_format_date_short' => 'd.m.Y',
    'output_format_zone_short' => '',
    'output_format_custom_short' => 'd.m.y - H:i',
    'tz_handling' => 'none',
    'field_timezone' => 'Europe/Moscow',
    'field_name' => 'field_test',
    'field_type' => 'datestamp',
    'module' => 'date',
  ),
);

I have several nodes of this type.
When I look at this view page:

  $view = new stdClass();
  $view->name = 'test';
  $view->description = '';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Test';
  $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 = 'test';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '99';
  $view->menu = TRUE;
  $view->menu_title = 'Test';
  $view->menu_tab = FALSE;
  $view->menu_tab_default = FALSE;
  $view->menu_tab_weight = '0';
  $view->block = TRUE;
  $view->block_title = 'Test';
  $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 = '99';
  $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 (
  );
  $view->argument = array (
    array (
      'type' => 'calendar_year',
      'argdefault' => '2',
      'title' => '',
      'options' => '',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
    array (
      'type' => 'calendar_month',
      'argdefault' => '2',
      'title' => '',
      'options' => '',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
    array (
      'type' => 'calendar_day',
      'argdefault' => '2',
      'title' => '',
      'options' => '',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
  );
  $view->field = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => '',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array (
      'tablename' => 'node_data_field_test',
      'field' => 'field_test_value',
      'label' => '',
      'handler' => 'content_views_field_handler_group',
      'options' => 'default',
    ),
  );
  $view->filter = array (
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node, node_data_field_test);
  $views[$view->name] = $view;

I see my nodes, but all time values are shifted on +3 hours (equal to my timezone shift).

When I click on some busy day's number I see the page with no results (look at the breadcrumb! nice?). Click 'next >>' : here are my nodes from previous day with _correct_ time values!

Where is a trick?

P.S. Any week links refers to first week of 1970, but this is another issue ;-)

Comments

KarenS’s picture

Please double check with very latest versions of both Calendar and Date modules to see if this is now fixed.

tema’s picture

Fatal error: Call to undefined function date_sql() in <...>\modules\calendar\calendar.module on line 928

KarenS’s picture

Did you install the Date API?

tema’s picture

Status: Active » Fixed

Thank You! Now everything is fine :)
Status: fixed

P.S.: My upgrade path to this release was too hard:
UPDATE `system` SET `status` = '0' WHERE CONVERT( `filename` USING utf8 ) = 'modules/calendar/calendar.module' LIMIT 1 ;
I believe You should check status of required modules.

Anonymous’s picture

Status: Fixed » Closed (fixed)