Active
Project:
GoJoinGo
Version:
4.6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
4 Apr 2006 at 01:45 UTC
Updated:
4 Apr 2006 at 03:20 UTC
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
Comment #1
ajwwong commentedBTW,
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!
Comment #2
ajwwong commentedMore 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!