[SAC] [OSGeo] #2765: Some OSGeoLive reports broken as result of upgrade

[OSGeo]

#2765: Some OSGeoLive reports broken as result of upgrade
---------------------------+---------------------------------------
 Reporter:  robe           |      Owner:  sac@…
     Type:  task           |     Status:  new
 Priority:  normal         |  Milestone:  Sysadmin Contract 2022-II
Component:  Systems Admin  |   Keywords:
---------------------------+---------------------------------------
 Just noting this in case others using trac reports run into the same
 issue.

 As a result of the upgrade 4 of the OSGeoLive reports were broken.  I
 think this is result of trac in newer version adding the description field
 to other tables.  Before I think it was only on the tickets table.

 Easy fix.

 The error it gives is something to the effect


 {{{
 ambiguous column description
 }}}

 The fix is to prefix the description column with the alias for tickets
 which is usually t.

 So


 {{{

 SELECT .., description AS _description
 ...
 }}}


 becomes

 {{{

 SELECT .., t.description AS _description
 ...
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2765>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.