Opened 12 years ago
Last modified 9 years ago
#9976 assigned defect
Internal error with Postgresql database. — at Version 2
Reported by: | rzhidalgo@yahoo.com | Owned by: | Roberto Longobardi |
---|---|---|---|
Priority: | normal | Component: | FaqPlugin |
Severity: | normal | Keywords: | |
Cc: | Trac Release: | 0.12 |
Description (last modified by )
Clicking on the FAQ top menu option generates an Internal Server Error. The trac.log displays:
ProgrammingError: column "wiki.text" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT name, text, max(version) FROM wiki WHERE name LIKE 'F...
Note: See
TracTickets for help on using
tickets.
The solution is to modify a SQL statement in the macros.py file to be valid with Postgresql. Below is the new SQL statement (macros.py (line 246)):
current:
new: