Mailing List Archive

ProgrammingError: column reference "id" is ambiguous
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.

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/0e80219d-a7c7-437d-9075-7b67a1550204%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: ProgrammingError: column reference "id" is ambiguous [ In reply to ]
On Wed, Jun 26, 2019 at 3:11 AM Mo <burcheri.massimo@gmail.com> wrote:

> 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.
>

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

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CA%2BBGpn-Bp%2BasOBtPbjGUzbK8UpTGs4rvLF7--2Zyd5DjaU%2BtXw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Re: ProgrammingError: column reference "id" is ambiguous [ In reply to ]
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.

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/9f0bb62d-320b-4dd8-b84c-e9dc02ff992f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: ProgrammingError: column reference "id" is ambiguous [ In reply to ]
On Thu, Jul 11, 2019 at 5:47 AM Mo <burcheri.massimo@gmail.com> wrote:

> 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.
>

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

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CA%2BBGpn8bkotxwC7hxtpXR1zhYdXBRtU9uu-XKWYUgPy5mabi2g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.