Most projects inaccessible (ambitious column) in most recent unstable release

Just upgraded to the latest unstable release, most projects are no longer accessible with the following error message. It happens when using the List or Table view, the Kanban view does seem to work.

vikunja-1  | 2024-06-09T11:17:54.426949644Z: ERROR      ▶ handler/ReadAllWeb 3c9 Error 1052 (23000): Column 'id' in order clause is ambiguous
vikunja-1  | 2024-06-09T11:25:14.839510936Z: WEB        ▶ xxxx  GET 500 /api/v1/projects/52/views/215/tasks?sort_by[]=index&order_by[]=desc&filter=&filter_include_nulls=false&filter_timezone=Europe%2FBerlin&s=&expand=subtasks&page=1 2.147971ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.1.15

It might be something similar to this issue?

This is a Kanban request that’s working fine:

vikunja-1  | 2024-06-09T11:25:16.0822754Z: WEB  ▶ xx.xx.xx.xx  GET 200 /api/v1/projects/52/views/216/tasks?filter=&filter_include_nulls=false&s=&per_page=25&page=1 9.096072ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.1.15

Edit: it’s also happening on try, using the default “Inbox” project of the demo user.

1 Like

Well, that’s a bug. I’ll take a look.

1 Like