Problem with repeat events

KarenS,

The problem exists whether 'distinct' is used or not.

This is the view export:

$view = new stdClass();
  $view->name = 'upcoming_events';
  $view->description = '';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = '';
  $view->page_header = '';
  $view->page_header_format = '3';
  $view->page_footer = '';
  $view->page_footer_format = '3';
  $view->page_empty = '';
  $view->page_empty_format = '3';
  $view->page_type = 'table';
  $view->url = 'upcoming/events';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->block = TRUE;
  $view->block_title = '';
  $view->block_header = '';
  $view->block_header_format = '3';
  $view->block_footer = '';
  $view->block_footer_format = '3';
  $view->block_empty = '';
  $view->block_empty_format = '3';
  $view->block_type = 'table';
  $view->nodes_per_block = '7';
  $view->block_more = '1';
  $view->block_use_page_header = FALSE;
  $view->block_use_page_footer = FALSE;
  $view->block_use_page_empty = FALSE;
  $view->sort = array (
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Event',
      'handler' => 'views_handler_field_nodelink',
    ),
    array (
      'tablename' => 'event',
      'field' => 'event_start',
      'label' => 'Start',
      'handler' => 'views_handler_field_date_small',
    ),
    array (
      'tablename' => 'event',
      'field' => 'event_end',
      'label' => 'End',
      'handler' => 'views_handler_field_date_small',
    ),
    array (
      'tablename' => 'term_node_4',
      'field' => 'name',
      'label' => 'Pathways',
    ),
    array (
      'tablename' => 'node',
      'field' => 'type',
      'label' => 'Stage',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'event',
      'field' => 'event_start',
      'operator' => '>',
      'options' => '',
      'value' => 'now',
    ),
    array (
      'tablename' => 'node',
      'field' => 'distinct',
      'operator' => '=',
      'options' => '',
      'value' => array (
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node, event, term_node_4);
  $views[$view->name] = $view;

With regard to repeated events; they have the same title but have different nid's.

As far as I can see, the eventrepeat module adds three tables to the database: event_repeat, event_repeat_calendar_map, event_repeat_nodes. The relationship between the event table and the repeat event seems to be via the nid which then maps to an rid (in the event_repeat table). See the attached jpg.

OS = Linux (Fedora Core 4)
PHP = 5.0.4
DB = MySQL 4.1.1

In the settings for repeat event module, I do not have the keep in sequence box ticked.

The dates for the view are well in the future (more than 30 days) so the '>now' filter should not exclude them.

Well, using the devel module is a bit scary. My site shows up loads of notices about "undefined indexes" and "undefined properties". Is that normal?

Anyway, these are the two page_query calls that showed up:

3.26 0 pager_query SELECT count(DISTINCT(node.nid)) FROM node node LEFT JOIN event event ON node.nid = event.nid WHERE (event.event_start > (1157406597 + 0))

2 0 pager_query SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, event.event_start AS event_event_start, event.event_end AS event_event_end, node.type AS node_type FROM node node LEFT JOIN event event ON node.nid = event.nid WHERE (event.event_start > (1157406597 + 0)) LIMIT 0, 10

Also, when I plug the second query into phpMyAdmin, I still get the incorrect output. It is skipping things between the first date of the repeat and the second date of the repeat.

Just to let you know, I had been using a fairly heavily patched Event module. So, I just swapped this out for a copy of the most recent Event module and Event Repeat.

But, the problem persists.

Thanks, again, for your assistance.

I've checked the database tables.

The nodes (nid's) are all there. They match up between the node table and event table. All of the nodes have start times that are after 1157406597.

This is very odd.

If it would help, I could email you some access information so you could look at things more directly. For all I know, I might be reading something wrong (my PHP & SQL skills are still quite novice like).

Check out this page: http://www.baade.org/node/425

This is using this snippet:

<?php

function list_ongoing_and_upcoming_events($limit=10) {
global $user;
  // For events coming up in two hours or ongoing events, we display "ongoing now"
  $time = time()  - (2 * 60 * 60);
 // select events that have not yet ended
  $result = db_query_range(db_rewrite_sql("SELECT n.nid, n.title, n.type, n.status, n.moderate, e.event_start, e.event_end FROM {node} n INNER JOIN {event} e USING (nid) WHERE n.status = 1 AND n.moderate = 0 AND e.event_end >= %d ORDER BY event_start"), $time, 0, $limit);

  while ($node = db_fetch_object($result)) {
    $links[] = $node;
  }

  if (is_array($links) && (sizeof($links) > 0)) {
    foreach ($links as $node) {
      $minutesleft = floor(($node->event_start - time()) / 60);

      if ($minutesleft < 0) {
        $timeleft = t('ongoing now');
      }
      else if ($minutesleft < 60) {
        $timeleft = t('today');
      }
      else if ($minutesleft >= 60 && $minutesleft < (24 * 60)) {
        $timeleft = t('today');
      }
      else if ($minutesleft >= (24 * 60)) {
        $days = floor($minutesleft / (24 * 60));
        // hours remainder
        $hours = ($minutesleft % (24 * 60)) / 60;
        // hours left in the day
        $hours_left = ((time() / 60) % (24 * 60)) / 60;
        // see if the remainder of hours on the event date is greater than the hours left in today, if so increase the days by one so that the days remaining mimics the date rather than how many 24 hour periods there are between now and then.
        if ($hours>$hours_left) {
          $days++;
        }
        $timeleft = format_plural($days, 'tomorrow', 'in %count days');
      }

      $node->timeleft = $timeleft;
      $ctype = module_invoke('flexinode', 'load_content_type', substr($node->type, 10));
      $node->typename = ($ctype->name ? $ctype->name : $node->type);

      //$event_line .= "<div class='upcoming_events'><strong>";
      $event_line .= "<tr><td><strong>" . date('M d', $node->event_start) . "</strong></td>\n";
      $event_line .= "<td>". date('H:i',$node->event_start) ."</td>\n";
      $event_line .= "<td>". date('H:i',$node->event_end) ."</td>\n";
      $event_line .= "<td>". date('O',$node->event_start) ."</td>\n";
      $event_line .= "<td>".l($node->title, "node/$node->nid", array('title' => $node->title))."</td>";
      $event_line .= "<td> (" . $node->timeleft .  ")</td>\n";
      $event_line .= "<td>" .node_get_name($node->type). "</td>";
	 $event_line .= "</tr>\n";
      //$event_line .= "</div>";

    }

  }
  return $event_line;
}

$listlength="20";
  print "<table class='upcoming_events'>".list_ongoing_and_upcoming_events($limit = $listlength)."</table>";
?>

As you can see, it is getting the events in the right sequence, including repeats.

Given, this, I wonder if there isn't something related to the query or handling the results of the query coming from Views.

Thanks

Have you had a chance to look into this any further? Thanks