vikunja
/
vikunja
6
43
Fork 71
Code Issues 150 Pull Requests 14 Packages Releases 32 Activity

[Unstable] Navigating to "upcoming" tab causes 500 response #1636

New Issue
Closed
opened 2023-11-03 19:30:08 +00:00 by perfectra1n · 8 comments
perfectra1n commented 2023-11-03 19:30:08 +00:00
Copy Link

Description

Hi Konrad,

I was trying out the latest unstable images for both frontend and api. Upon a fresh install and setting up a user, I get the following API errors:

2023-11-03T05:14:31.060496023Z: ERROR	▶ models/convertFilterValues 12f8 Unknown search type for value 2023-11-10 05:14:31.014 +0000 UTC
2023-11-03T05:14:31.060541619Z: ERROR	▶ models/convertFilterValues 12f9 Unknown search type for value 2023-11-03 05:14:31.014 +0000 UTC
2023-11-03T05:14:31.070769983Z: ERROR	▶ handler/ReadAllWeb 12fa status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."}

Vikunja Frontend Version

unstable@sha256:6a21f2e73e5fdbf9b102b1d329f1d3e0eb68f660e5d58460ccda98cf1b4ef620

Vikunja API Version

unstable@sha256:a4d258bf526f104406e163e234d1021e286ac544b0f2f63bbc76a3a91ca7c5bd

Browser and version

No response

Can you reproduce the bug on the Vikunja demo site?

No

Screenshots

image (5)

### Description Hi Konrad, I was trying out the latest `unstable` images for both frontend and api. Upon a fresh install and setting up a user, I get the following API errors: ``` 2023-11-03T05:14:31.060496023Z: ERROR ▶ models/convertFilterValues 12f8 Unknown search type for value 2023-11-10 05:14:31.014 +0000 UTC 2023-11-03T05:14:31.060541619Z: ERROR ▶ models/convertFilterValues 12f9 Unknown search type for value 2023-11-03 05:14:31.014 +0000 UTC 2023-11-03T05:14:31.070769983Z: ERROR ▶ handler/ReadAllWeb 12fa status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."} ``` ### Vikunja Frontend Version unstable@sha256:6a21f2e73e5fdbf9b102b1d329f1d3e0eb68f660e5d58460ccda98cf1b4ef620 ### Vikunja API Version unstable@sha256:a4d258bf526f104406e163e234d1021e286ac544b0f2f63bbc76a3a91ca7c5bd ### Browser and version _No response_ ### Can you reproduce the bug on the Vikunja demo site? No ### Screenshots ![image (5)](/attachments/7361b5b9-dbcf-419d-9357-7ff2e82d48a6)
image (5).png
190 KiB
perfectra1n added the
kind/bug
 label 2023-11-03 19:30:08 +00:00
perfectra1n commented 2023-11-03 19:30:40 +00:00
Author
Copy Link

Let me know if there's any additional information I can provide or if there's a test you would like me to do!

Let me know if there's any additional information I can provide or if there's a test you would like me to do!
konrad commented 2023-11-06 16:27:18 +00:00
Owner
Copy Link

Did you set a saved filter for the home page?

Did you set a saved filter for the home page?
perfectra1n commented 2023-11-06 20:48:33 +00:00
Author
Copy Link

No, I hadn't set a saved filter as/for the home page. The only thing I had done was create the Jon user, and then create the Atvik Security project.

No, I hadn't set a saved filter as/for the home page. The only thing I had done was create the `Jon` user, and then create the `Atvik Security` project.
konrad commented 2023-11-07 14:44:28 +00:00
Owner
Copy Link

Which browser are you using?

Can you share the request path (you can remove the domain) from the logs (it should start with /api/v1/tasks/all)

Which Vikunja version are you using? You can get this in the user menu on the top right, then "about".

Which browser are you using? Can you share the request path (you can remove the domain) from the logs (it should start with `/api/v1/tasks/all`) Which Vikunja version are you using? You can get this in the user menu on the top right, then "about".
👍 1
perfectra1n commented 2023-11-09 06:41:26 +00:00
Author
Copy Link

Browser:

Google Chrome 119.0.6045.105

Request path:

https://tasks-testing.domain.com/api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_by[]=due_date&filter_by[]=due_date&filter_value[]=false&filter_value[]=2023-11-16T06:40:03.101Z&filter_value[]=2023-11-09T06:40:03.101Z&filter_comparator[]=equals&filter_comparator[]=less&filter_comparator[]=greater&filter_concat=and&filter_include_nulls=false&page=1

2023-11-09T06:37:36.042115894Z: WEB 	▶ 10.233.114.192 f3601cf5784d0da1dcbb3b54a45acf13 GET 200 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&filter_include_nulls=false&page=1 160.44963ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:37.924343089Z: ERROR	▶ models/convertFilterValues 27e Unknown search type for value 2023-11-16 06:37:37.854 +0000 UTC
2023-11-09T06:37:37.924474988Z: ERROR	▶ models/convertFilterValues 27f Unknown search type for value 2023-11-09 06:37:37.854 +0000 UTC
2023-11-09T06:37:38.076239087Z: ERROR	▶ handler/ReadAllWeb 280 status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."}
2023-11-09T06:37:38.076635575Z: WEB 	▶ 10.233.114.192 6e5f7d558689d05a15fdbce2a06261c7 GET 500 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_by[]=due_date&filter_by[]=due_date&filter_value[]=false&filter_value[]=2023-11-16T06:37:37.854Z&filter_value[]=2023-11-09T06:37:37.854Z&filter_comparator[]=equals&filter_comparator[]=less&filter_comparator[]=greater&filter_concat=and&filter_include_nulls=false&page=1 163.498789ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:40.750040249Z: WEB 	▶ 10.233.114.192 8747151bf3f357ec67e789216ec1408f POST 200 /api/v1/user/token 3.829386ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:40.766872141Z: WEB 	▶ 10.233.114.192 e9cf3c5f3a80a41b4180eae61741cb71 GET 200 /api/v1/user 2.569921ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:40.768402333Z: WEB 	▶ 10.233.114.192 b5195663b226c69d5ad7c24cc019e26d GET 200 /api/v1/avatar/Jon?size=50&=1699511860725 3.598547ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:40.783904166Z: WEB 	▶ 10.233.114.192 aee3000548b0aa736c0bd6cc82f47d50 GET 200 /api/v1/avatar/Jon?size=50&=1699511860739 3.947246ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:40.794835863Z: ERROR	▶ models/convertFilterValues 28c Unknown search type for value 2023-11-16 06:37:37.854 +0000 UTC
2023-11-09T06:37:40.794987309Z: ERROR	▶ models/convertFilterValues 28d Unknown search type for value 2023-11-09 06:37:37.854 +0000 UTC
2023-11-09T06:37:40.799956188Z: ERROR	▶ handler/ReadAllWeb 28e status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."}
2023-11-09T06:37:40.800101657Z: WEB 	▶ 10.233.114.192 8958e5a65d2d03dbea156ca63dfbb192 GET 500 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_by[]=due_date&filter_by[]=due_date&filter_value[]=false&filter_value[]=2023-11-16T06:37:37.854Z&filter_value[]=2023-11-09T06:37:37.854Z&filter_comparator[]=equals&filter_comparator[]=less&filter_comparator[]=greater&filter_concat=and&filter_include_nulls=false&page=1 19.381403ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:45.752948067Z: WEB 	▶ 10.233.114.192 478e29b4cbec51e732b1be8f3f81745e GET 200 /api/v1/notifications?page=1 3.8518ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36
2023-11-09T06:37:46.500273794Z: ERROR	▶ models/convertFilterValues 296 Unknown search type for value 2023-11-16 06:37:46.397 +0000 UTC
2023-11-09T06:37:46.500448014Z: ERROR	▶ models/convertFilterValues 297 Unknown search type for value 2023-11-09 06:37:46.397 +0000 UTC
2023-11-09T06:37:46.505233779Z: ERROR	▶ handler/ReadAllWeb 298 status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."}

Vikunja Version:

Frontend Version: 0.21.0+322-218d72494a

API Version: v0.21.0+189-66afe52afb

image

If I've misunderstood what you were asking for, feel free to let me know @konrad! This is on a new install with a brand new PostgreSQL DB.

Browser: ``` Google Chrome 119.0.6045.105 ``` Request path: ``` https://tasks-testing.domain.com/api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_by[]=due_date&filter_by[]=due_date&filter_value[]=false&filter_value[]=2023-11-16T06:40:03.101Z&filter_value[]=2023-11-09T06:40:03.101Z&filter_comparator[]=equals&filter_comparator[]=less&filter_comparator[]=greater&filter_concat=and&filter_include_nulls=false&page=1 ``` ``` 2023-11-09T06:37:36.042115894Z: WEB ▶ 10.233.114.192 f3601cf5784d0da1dcbb3b54a45acf13 GET 200 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&filter_include_nulls=false&page=1 160.44963ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:37.924343089Z: ERROR ▶ models/convertFilterValues 27e Unknown search type for value 2023-11-16 06:37:37.854 +0000 UTC 2023-11-09T06:37:37.924474988Z: ERROR ▶ models/convertFilterValues 27f Unknown search type for value 2023-11-09 06:37:37.854 +0000 UTC 2023-11-09T06:37:38.076239087Z: ERROR ▶ handler/ReadAllWeb 280 status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."} 2023-11-09T06:37:38.076635575Z: WEB ▶ 10.233.114.192 6e5f7d558689d05a15fdbce2a06261c7 GET 500 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_by[]=due_date&filter_by[]=due_date&filter_value[]=false&filter_value[]=2023-11-16T06:37:37.854Z&filter_value[]=2023-11-09T06:37:37.854Z&filter_comparator[]=equals&filter_comparator[]=less&filter_comparator[]=greater&filter_concat=and&filter_include_nulls=false&page=1 163.498789ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:40.750040249Z: WEB ▶ 10.233.114.192 8747151bf3f357ec67e789216ec1408f POST 200 /api/v1/user/token 3.829386ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:40.766872141Z: WEB ▶ 10.233.114.192 e9cf3c5f3a80a41b4180eae61741cb71 GET 200 /api/v1/user 2.569921ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:40.768402333Z: WEB ▶ 10.233.114.192 b5195663b226c69d5ad7c24cc019e26d GET 200 /api/v1/avatar/Jon?size=50&=1699511860725 3.598547ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:40.783904166Z: WEB ▶ 10.233.114.192 aee3000548b0aa736c0bd6cc82f47d50 GET 200 /api/v1/avatar/Jon?size=50&=1699511860739 3.947246ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:40.794835863Z: ERROR ▶ models/convertFilterValues 28c Unknown search type for value 2023-11-16 06:37:37.854 +0000 UTC 2023-11-09T06:37:40.794987309Z: ERROR ▶ models/convertFilterValues 28d Unknown search type for value 2023-11-09 06:37:37.854 +0000 UTC 2023-11-09T06:37:40.799956188Z: ERROR ▶ handler/ReadAllWeb 28e status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."} 2023-11-09T06:37:40.800101657Z: WEB ▶ 10.233.114.192 8958e5a65d2d03dbea156ca63dfbb192 GET 500 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_by[]=due_date&filter_by[]=due_date&filter_value[]=false&filter_value[]=2023-11-16T06:37:37.854Z&filter_value[]=2023-11-09T06:37:37.854Z&filter_comparator[]=equals&filter_comparator[]=less&filter_comparator[]=greater&filter_concat=and&filter_include_nulls=false&page=1 19.381403ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:45.752948067Z: WEB ▶ 10.233.114.192 478e29b4cbec51e732b1be8f3f81745e GET 200 /api/v1/notifications?page=1 3.8518ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 2023-11-09T06:37:46.500273794Z: ERROR ▶ models/convertFilterValues 296 Unknown search type for value 2023-11-16 06:37:46.397 +0000 UTC 2023-11-09T06:37:46.500448014Z: ERROR ▶ models/convertFilterValues 297 Unknown search type for value 2023-11-09 06:37:46.397 +0000 UTC 2023-11-09T06:37:46.505233779Z: ERROR ▶ handler/ReadAllWeb 298 status: 400 response: {"message": "Error with filter field `due_date`: Not an int64."} ``` Vikunja Version: ``` Frontend Version: 0.21.0+322-218d72494a API Version: v0.21.0+189-66afe52afb ``` ![image](/attachments/85097353-0ea1-47e0-b89f-bc7e82cc06a7) If I've misunderstood what you were asking for, feel free to let me know @konrad! This is on a new install with a brand new PostgreSQL DB.
image.png
45 KiB
konrad commented 2023-11-09 11:24:54 +00:00
Owner
Copy Link

Are you using typesense?

Are you using typesense?
konrad commented 2023-11-09 11:31:28 +00:00
Owner
Copy Link

Should be fixed in 6169c2e12e - looks like the problem was caused by dates not being converted correctly for typesense filtering.
Please test with the next unstable build.

As a workaround, you can disable the typesense integration.

Should be fixed in https://kolaente.dev/vikunja/api/commit/6169c2e12edd3e050de4563defa23aa0a2b7d948 - looks like the problem was caused by dates not being converted correctly for typesense filtering. Please test with the next unstable build. As a workaround, you can disable the typesense integration.
❤️ 1
perfectra1n commented 2023-11-11 19:00:07 +00:00
Author
Copy Link

I just love Typesense so much, I want to use it! lol

I just love Typesense so much, I want to use it! lol
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
renovate/camel-case-5.x
renovate/go-1.x
renovate/lowlight-3.x
renovate/golang.org-x-sync-0.x
renovate/major-dev-dependencies
renovate/github.com-wneessen-go-mail-0.x
renovate/golangci-golangci-lint-1.x
feature/better-filter-syntax
fix/tiptap-task-list
renovate/flexsearch-0.x
feature/zod-schema
renovate/github.com-typesense-typesense-go-1.x
renovate/github.com-golang-jwt-jwt-v4-5.x
automatic-year-range-for-go-header-template
feature/hide-forbidden-related-tasks
renovate/golang-1.x
release/0.20
release/0.17
release/0.16
release/0.15
release/0.14
release/0.13
v0.23.0
v0.22.1
v0.22.0
v0.21.0
v0.20.4
v0.20.3
v0.20.2
v0.20.1
v0.20.0
v0.19.2
v0.19.1
v0.19.0
v0.18.1
v0.18.0
v0.17.1
v0.17.0
v0.16.1
v0.16.0
v0.15.1
v0.15.0
v0.14.1
v0.14.0
v0.13.1
v0.13
v0.12
v0.11
v0.10
v0.9
v0.8
v0.7
v0.6
v0.5
v0.4
v0.3
v0.2
v0.1
Labels
Clear labels   
dependencies

   
duplicate

This issue or pull request already exists

  
help wanted

Need some help

  
invalid

Something is wrong

  
kind/bug

Something is not working

  
kind/feature

New feature

  
needs reproduction

   
question

More information is needed

  
security

   
wontfix

This won't be fixed

No Label
dependencies
duplicate
help wanted
invalid
kind/bug
kind/feature
needs reproduction
question
security
wontfix
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: vikunja/vikunja#1636
No description provided.
Delete Branch "%!s(<nil>)"

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?