Hello, again...

This is showing up on my system, so I thought I'd report it here:

When I go to the page:

my/events

I get the list of MyEvents. It all shows up correctly EXCEPT the name, date and times are showing up incorrectly for the table section:

"Future events I've RSVP'd for"

For this section, the name / date /time is consistently:

01.01.70
12:00am

without a functional link. This is related to the SQL query in gjg.module line 704. [Below is some of the relevant code:]

 foreach (array(
    '>' => array(t("Events I'm Hosting"), t("Future events I've RSVP'd for")),
    '<=' => array(t("Events I've Hosted"), t("Past events I've RSVP'd for"))) as $op => $headers) {
    $result = pager_query("SELECT n.nid FROM {node} n INNER JOIN {event} e ON n.nid = e.nid WHERE event_end $op %d AND uid = %d AND type = 'gjg_event'", 10, $i, NULL, time(), $user->uid);
    $nodes = array();
    while ($node = db_fetch_object($result)) {
      $nid = $node->nid;
      $node = node_load(array('nid' => $node->nid));
      $nodes[] = $node;

It is possible that the code is working but the Future RSVP's are not getting appropriately stored. If I figure out more, I'll let you know.

Good luck!

Albert
www.ithou.org

Comments

ajwwong’s picture

BTW,

This bug shows up also at GSC at the page:

http://connect.goodstorm.com/my/events

when the user has RSVP'd to a future event. The only difference is that in this case the event name/date/time is:

31.12.69
04:00pm

Good luck!

ajwwong’s picture

More information in the bug squash hunt:

The problem also occurs with... my/events page for the Table heading:

"Past events I've RSVP'd for"

ie.:

Empty header field and incorrect dates.

The SQL itself appears to be fine. That is, it returns the correct nodes.

However, I'm not sure about the "foreach(" part of this.... it seems like it cuts off the "second part" of the loop.

I'm definitely out of my league, but still futzing around.

Good luck!