fergbrain

Gayatriom,

I also have this issue, so I don’t think your formatting is an issue.

I resolved the issue by making the following changes to rsvp_frontend.inc.php:

Replace lines 197-201 with:

$sql = "SELECT id, firstName, lastName FROM ".ATTENDEES_TABLE."
 	WHERE (
 			id IN (SELECT attendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE associatedAttendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d))
		)
		 AND id <> %d
		 AND rsvpStatus <> 'NoResponse'";
$associations = $wpdb->get_results($wpdb->prepare($sql, $attendeeID, $attendeeID,$attendeeID, $attendeeID ));

and replace lines 212-217 with:

$sql = "SELECT id, firstName, lastName personalGreeting FROM ".ATTENDEES_TABLE."
 	WHERE (
 			id IN (SELECT attendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE associatedAttendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d))
		)
		 AND id <> %d
		 AND rsvpStatus = 'NoResponse'";
$associations = $wpdb->get_results($wpdb->prepare($sql, $attendeeID, $attendeeID,$attendeeID, $attendeeID ));