id summary reporter owner description type status priority component severity resolution keywords cc release 9038 error in wiki.getRecentChanges() Olivier ANDRE osimons "Hello, Context : * debian squeeze * trac 0.12 * postgres 8.4 Problem : * the call to wiki.getRecentChanges() return this error : {{{ 'column ""wiki.author"" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT name, max(time), author, version, comment FROM wiki W... }}} the problem come from the wiki.py file, line 69 {{{ cursor.execute('SELECT name, max(time), author, version, comment FROM wiki' ' WHERE time >= %s GROUP BY name ORDER BY max(time) DESC', (since,)) }}} Postgres is unableto perform this request. {{{ cursor.execute('SELECT name, time, author, version, comment FROM wiki w1 WHERE time >= %s AND (name,version) = (SELECT w2.name, MAX(version) FROM wiki w2 WHERE w2.name=w1.name GROUP BY w2.name) ORDER BY time DESC', (since,)) }}} do the same (even if less elegantly) and work in both mysql and postgres. i attach a patch to this ticket. " defect closed normal XmlRpcPlugin major fixed Olemis Lang 0.12