#2765 closed task (fixed)
Some OSGeoLive trac reports broken as result of trac upgrade
| Reported by: | robe | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | Sysadmin Contract 2022-II |
| Component: | SysAdmin | Keywords: | |
| Cc: |
Description ¶
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 ...
Change History (4)
comment:1 by , 3 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
comment:2 by , 3 years ago
| Summary: | Some OSGeoLive reports broken as result of upgrade → Some OSGeoLive trac reports broken as result of trac upgrade |
|---|
comment:3 by , 3 years ago
Note:
See TracTickets
for help on using tickets.
just in case someone is searching for the error, the exact error was