#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.
#2765: Some OSGeoLive reports broken as result of upgrade
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Changes (by robe):
* status: new => closed
* resolution: => fixed
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2765#comment:1>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2765: Some OSGeoLive trac reports broken as result of trac upgrade
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Changes (by robe):
* summary: Some OSGeoLive reports broken as result of upgrade => Some
OSGeoLive trac reports broken as result of trac upgrade
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2765#comment:2>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2765: Some OSGeoLive trac reports broken as result of trac upgrade
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):
just in case someone is searching for the error, the exact error was
{{{
ProgrammingError: column reference "description" is ambiguous
}}}
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2765#comment:3>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2765: Some OSGeoLive trac reports broken as result of trac upgrade
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Comment (by kalxas):
Thank you for the fix!
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2765#comment:4>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.