id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 1540,topic and message Trac links fail on postgresql,Kevin Thomas,Radek Bartoň,"The {{{topic}}} and {{{message}}} Trac links don't work on an installation of Trac using Postgresql. Any page that contains these links generates the following error: {{{ #!pytb Traceback (most recent call last): File ""C:\Python24\lib\site-packages\trac\web\main.py"", line 387, in dispatch_request dispatcher.dispatch(req) File ""C:\Python24\lib\site-packages\trac\web\main.py"", line 237, in dispatch resp = chosen_handler.process_request(req) File ""C:\Python24\lib\site-packages\trac\ticket\web_ui.py"", line 302, in process_request get_reporter_id(req, 'author')) File ""C:\Python24\lib\site-packages\trac\ticket\web_ui.py"", line 625, in _insert_ticket_data change['comment'] = wiki_to_html(comment, self.env, req, db) File ""C:\Python24\lib\site-packages\trac\wiki\formatter.py"", line 999, in wiki_to_html Formatter(env, req, absurls, db).format(wikitext, out, escape_newlines) File ""C:\Python24\lib\site-packages\trac\wiki\formatter.py"", line 822, in format result = re.sub(self.wiki.rules, self.replace, line) File ""C:\Python24\Lib\sre.py"", line 142, in sub return _compile(pattern, 0).sub(repl, string, count) File ""C:\Python24\lib\site-packages\trac\wiki\formatter.py"", line 768, in replace replacement = self.handle_match(fullmatch) File ""C:\Python24\lib\site-packages\trac\wiki\formatter.py"", line 764, in handle_match return internal_handler(match, fullmatch) File ""C:\Python24\lib\site-packages\trac\wiki\formatter.py"", line 342, in _shref_formatter return self._make_link(ns, target, match, match) File ""C:\Python24\lib\site-packages\trac\wiki\formatter.py"", line 369, in _make_link escape(label, False)) File ""build\bdist.win32\egg\tracdiscussion\wiki.py"", line 111, in _discussion_link File ""C:\Python24\lib\site-packages\trac\db\util.py"", line 50, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""C:\Python24\lib\site-packages\trac\db\util.py"", line 50, in execute return self.cursor.execute(sql_escape_percent(sql), args) ProgrammingError: column ""forum.subject"" must appear in the GROUP BY clause or be used in an aggregate function }}} I've given this a high priority and severity because this bug causes all pages containing these links to crash, and if these Trac links are used in a ticket comment, then there is no way to view that ticket again.",defect,closed,high,DiscussionPlugin,critical,fixed,,,0.10