ProgrammingError: column reference "id" is ambiguous

[Mo]

Hello,

after a big upgrade we encounter an error when sorting tickets by column:

ProgrammingError: column reference "id" is ambiguous

The Upgrade included updates of all tickets like TracHours, SimpleMultiProject, TracSubTicketsPlugin to mention a few.
Postgres was migrated from 9.3 to 11.

Searching for this kind of error message I find some Postgres threads, is something on Trac or Plugins not ready for Postgres 11?

Best regards.

[Ryan Ollos]

It might be this issue:

https://trac.edgewall.org/ticket/13068

I hope to find time to release 1.2.4 soon. 

You could try 1.2.2, or install from 1.2-stable.

- Ryan

[Mo]

Am Mittwoch, 26. Juni 2019 20:02:44 UTC+2 schrieb RjOllos:

I hope to find time to release 1.2.4 soon. 

You could try 1.2.2, or install from 1.2-stable.

We just finished our 1.2.3 migration. So a downgrade is not an option. Did I get that correct, the bugfix is already in 1.2.4? When will 1.2.4 be released?
This bug is major and happened on a stable release, as it prevents from listing bug tickets here. We have some custom reports that only work once, then fail. Using another report and switching back, makes it work again, but every reload makes it fail. This is blocking the team a lot..

Best regards.

[Ryan Ollos]

1.2.4 should be released by end-of-weekend. The fix is included in 1.2.4.