Download & Extend

function rsvp_function_load_guests creating invalid SQL for PostgreSQL

Project:RSVP
Version:6.x-2.0-rc3
Component:Code
Category:bug report
Priority:normal
Assigned:ulf1
Status:closed (fixed)

Issue Summary

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

#1

Assigned to:Anonymous» ulf1
Status:active» fixed

Thanks for reporting.

The next dev version contains the bugfix

~
Ulf

#2

Status:fixed» closed (fixed)

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

nobody click here