In the file rsvp.functions.inc, function rsvp_function_load_guests, lines 403 & 406 the queries being generated don't work with PostgreSQL (version 8.4.1). The query being generated is (one example):

SELECT SUM(totalguests) 
FROM rsvp r LEFT JOIN rsvp_invite u ON r.rid = u.rid 
            LEFT JOIN users us ON u.uid = us.uid 
	            LEFT JOIN rsvp_realname n ON u.email = n.email  
WHERE u.rid = 1 AND u.response='none' 
ORDER BY u.email

PostgreSQL chokes on the 'ORDER BY' clause with the error:

Query failed: ERROR: column "u.email" must appear in the GROUP BY clause or be used in an aggregate function

This is because in the context of a single, global aggregate of all results the order by is contradictory. If you're going to sort by email, you need to have some distinction by email or what is the purpose of the sort, right?

Comments

ulf1’s picture

Assigned: Unassigned » ulf1
Status: Active » Fixed

Thanks for reporting.

The next dev version contains the bugfix

~
Ulf

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.