[SAC] [OSGeo] #2805: trac making bogus SQL queries

[OSGeo]

#2805: trac making bogus SQL queries
---------------------------+------------------------------
 Reporter:  strk           |      Owner:  sac@…
     Type:  task           |     Status:  new
 Priority:  normal         |  Milestone:  Unplanned
Component:  Systems Admin  |   Keywords:  trac, postgresql
---------------------------+------------------------------
 I found these errors in the PostgreSQL 12 log, on tracsvn machine:
 {{{
 2022-09-14 05:46:09 GMT ERROR:  column reference "description" is
 ambiguous at character 176
 2022-09-14 05:46:09 GMT STATEMENT:  SELECT p.value AS __color__,
            id AS ticket, summary, component, version, milestone, t.type AS
 type,
            owner, status,
            time AS created,
            changetime AS _changetime, description AS _description,
            reporter AS _reporter
           FROM ticket t
           LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
           WHERE status <> 'closed'
           ORDER BY ticket DESC, milestone, t.type, time
 }}}

 The logs do not contain the name of the database (HINT: we should add
 that) but it does sound like coming from trac. I don't know if it's a
 custom query or a core query, but it is bogus.
-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2805>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.