Infinite loop on setting exceptions to date repeating

Sorry, that last piece was "...UTC for everything, field is required".

Note: this works fine on my local dev environment, but the bug appears on the live server. Both are running the same versions of everything, except mysql on local is 5.0.45 and on live is 5.0.22. I also noticed that the dates get saved without the "T" on my local environment but they have the "T" on the live server. Both dev and live are on same timezone as well.

Hmm, grabbed latest version, but now I'm getting a WSOD. "Only variables can be passed by reference in ../sites/all/modules/date/date_copy/date_copy.module on line 193"

Just to test, I pushed just the date_popup.module fix (to get around the WSOD), but it is still ending in an infinite loop.

Interestingly, when I set the widget to use select list instead of the jquery popup, the date repeating fields still used the jquery popup.

Oh, I'm a retard. I'm checking out trunk, which is probably your 6.x development. Sorry! Let me try the right branch :P

Alright, I'm using the lastest from the 5.x branch. Now I'm getting this when viewing the node:

"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 ') AND (EXTRACT(MONTH FROM(node_data_field_date.field_date_value)) = ) AND (EXTRA' at line 1 query: SELECT DISTINCT(node.nid), node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node.title AS node_title, node.changed AS node_changed, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node_data_field_date.field_date_rrule AS node_data_field_date_field_date_rrule FROM node node LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid WHERE (node.status = '1') AND (node.type IN ('class')) AND (EXTRACT(YEAR FROM(node_data_field_date.field_date_value)) = ) AND (EXTRACT(MONTH FROM(node_data_field_date.field_date_value)) = ) AND (EXTRACT(DAY FROM(node_data_field_date.field_date_value)) = ) ORDER BY node_data_field_date_field_date_value ASC in /httpdocs/includes/database.mysqli.inc on line 151."

Also, adding exceptions is still causing an infinite loop.

The sql error looks like it's happening from a view in a block on the site that uses the date filters, not from viewing the node.

Hmm same sql error. Also still getting the infinite loop on the date exceptions. I know this is a separate issue, but just for the record, here is my view that is getting a sql error:

  $view = new stdClass();
  $view->name = 'classes_embed_today';
  $view->description = 'Schedule of today\'s fitness classes for embedding (since calendar breaks args)';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = '';
  $view->page_header = '';
  $view->page_header_format = '4';
  $view->page_footer = '';
  $view->page_footer_format = '4';
  $view->page_empty = '';
  $view->page_empty_format = '4';
  $view->page_type = 'list';
  $view->url = 'classes_embed_today';
  $view->use_pager = FALSE;
  $view->nodes_per_page = '0';
  $view->sort = array (
    array (
      'tablename' => 'node_data_field_date',
      'field' => 'field_date_value',
      'sortorder' => 'ASC',
      'options' => '',
    ),
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => '',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'nolink',
    ),
    array (
      'tablename' => 'node_data_field_date',
      'field' => 'field_date_value',
      'label' => '',
      'handler' => 'content_views_field_handler_ungroup',
      '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 => 'class',
),
    ),
    array (
      'tablename' => 'node_data_field_date',
      'field' => 'field_date_value_year',
      'operator' => '=',
      'options' => 'now',
      'value' => '',
    ),
    array (
      'tablename' => 'node_data_field_date',
      'field' => 'field_date_value_month',
      'operator' => '=',
      'options' => 'now',
      'value' => '',
    ),
    array (
      'tablename' => 'node_data_field_date',
      'field' => 'field_date_value_day',
      'operator' => '=',
      'options' => 'now - 6 hours',
      'value' => '',
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node_data_field_date, node);
  $views[$view->name] = $view;

Just to test everything out, I created a fresh new site, with just CCK and Date (latest code from cvs) installed. I set the site timezone to UTC and turned off user timezones. I'm still getting the problem. I've tried changing the "to" date field from optional to never, but that didn't help. Here is an export of the content type on the test site I set up:

$content[type]  = array (
  'name' => 'class',
  'type' => 'class',
  'description' => '',
  'title_label' => 'Title',
  'body_label' => 'Body',
  'min_word_count' => '0',
  'help' => '',
  'node_options' => 
  array (
    'status' => true,
    'promote' => false,
    'sticky' => false,
    'revision' => false,
  ),
  'comment' => '0',
  'old_type' => 'class',
  'orig_type' => '',
  'module' => 'node',
  'custom' => '1',
  'modified' => '1',
  'locked' => '0',
);
$content[fields]  = array (
  0 => 
  array (
    'widget_type' => 'date_popup',
    'label' => 'date',
    'weight' => '0',
    'default_value' => 'blank',
    'default_value_code' => '',
    'default_value2' => 'same',
    'default_value_code2' => '',
    'input_format' => 'd/m/Y h:i:sA',
    'input_format_custom' => '',
    'year_range' => '-3:+3',
    'increment' => '1',
    'advanced' => 
    array (
      'label_position' => 'above',
      'text_parts' => 
      array (
        'year' => 0,
        'month' => 0,
        'day' => 0,
        'hour' => 0,
        'minute' => 0,
        'second' => 0,
      ),
    ),
    'description' => '',
    'group' => false,
    'required' => '1',
    'multiple' => 1,
    'repeat' => 1,
    'todate' => '',
    'granularity' => 
    array (
      'year' => 'year',
      'month' => 'month',
      'day' => 'day',
      'hour' => 'hour',
      'minute' => 'minute',
    ),
    'output_format_date' => 'm/d/Y - g:ia',
    'output_format_custom' => '',
    'output_format_date_long' => 'l, F j, Y - g:ia',
    'output_format_custom_long' => '',
    'output_format_date_medium' => 'D, m/d/Y - g:ia',
    'output_format_custom_medium' => '',
    'output_format_date_short' => 'm/d/Y - g:ia',
    'output_format_custom_short' => '',
    'tz_handling' => 'none',
    'timezone_db' => 'UTC',
    'repeat_collapsed' => 0,
    'field_name' => 'field_date',
    'field_type' => 'date',
    'module' => 'date',
    'label_position' => 'above',
    'text_parts' => 
    array (
    ),
  ),
);

Thanks a lot for all of the help you are giving me KarenS :)

Will do. I'm going to be gone for the next week, but if I can get to the computer at all, I'll work on it. Thanks again for all your help!

KarenS, sorry I fell of the face of the planet with this. I'm super excited to try these new fixes!