Anyone out there?

I was having problems getting the view to work--return rows for my events that had invitations/RSVP. I looked at the SQL generated for the view in Live Previous while editing the View and got this SQL:

SELECT node.nid AS nid,
node.title AS node_title,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
COUNT(DISTINCT rsvp.rid) AS rsvp_total_rsvps,
COUNT(rsvp_invite.hash) AS rsvp_invite_total_invites,
node.uid AS node_uid,
node.type AS node_type
FROM node node
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN rsvp rsvp ON node.nid = rsvp.nid
LEFT JOIN rsvp_invite rsvp_invite ON rsvp.rid = rsvp_invite.rid
WHERE (node.type in ('event', 'jammii_event')) AND (users.uid = 7)
GROUP BY nid, rsvp.nid, node_title, node_revisions_body, node_revisions_format, rsvp_total_rsvps, rsvp_invite_total_invites, node_uid, node_type

I tried running this directly off the datas using PHPAdmin tool and got the error that can't group on rsvp_total_rsvps, rsvp_invite_total_invites fields. If I remove those from the group by clause, the query works and I get my rows. This kind of makes sense to me as this query uses GROUP BY to get the counts of total RSVPs and total Invites so they should not be in the GROUP BY clause.

THanks in advance for your help.