mirror of
https://github.com/go-vikunja/vikunja.git
synced 2026-03-09 07:13:35 -05:00
Saved filter with assignees doesn't work since 0.22.1 #187
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @mvalois on GitHub (Jan 29, 2024).
Description
I had a saved filter that shows me every tasks where I am assigned on. For that I just created a saved filter with assignees "myusername". It worked well on 0.22.0 until I upgraded to 0.22.1.
Since then the API call to the endpoint '/projects/-5/tasks' returns an empty list (and therefore the board is empty too).
If I filter by another field like label, it works as expected. I tried filtering with other usernames and still didn't get any result.
I observe the same behaviour using Firefox or the desktop app.
Vikunja Frontend Version
0.22.1
Vikunja API Version
0.22.1
Browser and version
Firefox
Can you reproduce the bug on the Vikunja demo site?
No
Screenshots
@kolaente commented on GitHub (Jan 29, 2024):
I'm unable to reproduce this with the latest unstable build.
Does your filter only contain the assignee? Or other attributes as well? Does it work if you recreate the same filter?
@mvalois commented on GitHub (Jan 30, 2024):
The filter only contains the assignee. It does not work if I recreate the same filter.
BTW we have migrated users from local auth to OpenID auth so we may have messed up with something. We only changed
issuerfromlocalto our SSO URL. But we done this before migrating to 0.22.1 where it worked well and it also returns empty list with assignees that have a local account.@kolaente commented on GitHub (Jan 30, 2024):
Can you check the actual filter json? Does it contain the correct username? Does it work if you filter on a project (not with a saved filter)
@mvalois commented on GitHub (Jan 30, 2024):
the actual filter json is :
When I filter my username on a project, it also returns an empty list (reproducible with other usernames).
@kolaente commented on GitHub (Jan 30, 2024):
And your username is
mvaloison the Vikunja instance? And it is empty with all usernames?@mvalois commented on GitHub (Jan 30, 2024):
Yes my username is
mvalois:Yes it is empty with every username.
@kolaente commented on GitHub (Jan 31, 2024):
It's not really reproducible for me. Can you enable database logging and share the queries being done when you access the filter?
@mvalois commented on GitHub (Feb 1, 2024):
here are the queries :
I also noticed there is an error in the stderr when accessing the filter:
@kolaente commented on GitHub (Feb 1, 2024):
That probably is the cause.
I've just pushed a change (
8efdc96d02) which adds more logging to that case. Please pull the next unstable build (ready in ~45min) and check the log message again.@mvalois commented on GitHub (Feb 1, 2024):
here is the log
@mvalois commented on GitHub (Feb 2, 2024):
Weird, I reimported the database (mysql) in my other test instance and the filter is working as expected.
I tried to reimport it in another database on the same mysql server but the filters do not work. So it looks it is due to the server itself. However they look to be utf8 compatible:
@kolaente commented on GitHub (Feb 5, 2024):
Should be fixed in
b95b92a23a. Please check with the next unstable build (ready in ~45min) if the problem went away.@mvalois commented on GitHub (Feb 6, 2024):
Yes, the problem went away with your fix. Thank you =)