Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error sending get events request: Invalid value for argument parameters #3197

Open
Chr1s0Blood opened this issue Feb 2, 2025 · 2 comments
Open

Comments

@Chr1s0Blood
Copy link

Chr1s0Blood commented Feb 2, 2025

Describe the Bug

When I send a request to endpont: "GET /api/websites/:websiteId/events" I get error 500.

Error: Invalid value for argument parameters: Could not convert from JSON date object to PrismaValue. Expected Flat JSON array (no nesting).

Database

PostgreSQL

Relevant log output

2025-02-02 11:49:07 Error [PrismaClientValidationError]: 
2025-02-02 11:49:07 Invalid `prisma.$queryRawUnsafe()` invocation:
2025-02-02 11:49:07 
2025-02-02 11:49:07 {
2025-02-02 11:49:07   query: "select count(*) as num from (\n    with events as (\n    select\n      event_id as \"id\",\n      website_id as \"websiteId\", \n      session_id as \"sessionId\",\n      created_at as \"createdAt\",\n      url_path as \"urlPath\",\n      url_query as \"urlQuery\",\n      referrer_path as \"referrerPath\",\n      referrer_query as \"referrerQuery\",\n      referrer_domain as \"referrerDomain\",\n      page_title as \"pageTitle\",\n      event_type as \"eventType\",\n      event_name as \"eventName\"\n    from website_event\n    where website_id = $1::uuid\n        and created_at between $2 and $3\n    \n    \n    order by created_at desc\n    limit 1000)\n    select * from events\n    ) t",
2025-02-02 11:49:07   parameters: {
2025-02-02 11:49:07     values: "[\"38b669df-e4e8-4c51-a1d1-fedbba019f38\",{\"prisma__type\":\"date\",\"prisma__value\":null},{\"prisma__type\":\"date\",\"prisma__value\":\"1970-01-01T00:00:00.000Z\"}]",
2025-02-02 11:49:07     __prismaRawParameters__: true
2025-02-02 11:49:07   }
2025-02-02 11:49:07   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2025-02-02 11:49:07 }
2025-02-02 11:49:07 
2025-02-02 11:49:07 Invalid value for argument `parameters`: Could not convert from `JSON date object` to `PrismaValue`. Expected Flat JSON array (no nesting).
2025-02-02 11:49:07     at wn (/app/node_modules/@prisma/client/runtime/library.js:29:1363)
2025-02-02 11:49:07     at $n.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:121:6958)
2025-02-02 11:49:07     at $n.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:121:6623)
2025-02-02 11:49:07     at $n.request (/app/node_modules/@prisma/client/runtime/library.js:121:6307)
2025-02-02 11:49:07     at async l (/app/node_modules/@prisma/client/runtime/library.js:130:9633)
2025-02-02 11:49:07     at async p (/app/.next/server/chunks/6711.js:1:21850)
2025-02-02 11:49:07     at async m (/app/.next/server/pages/api/websites/[websiteId]/events.js:1:2039)
2025-02-02 11:49:07     at async z (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:16764)
2025-02-02 11:49:07     at async U.render (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:17472)
2025-02-02 11:49:07     at async NextNodeServer.runApi (/app/node_modules/next/dist/server/next-server.js:618:9) {
2025-02-02 11:49:07   clientVersion: '5.22.0'
2025-02-02 11:49:07 }
2025-02-02 11:49:07  ⨯ Error [PrismaClientValidationError]: 
2025-02-02 11:49:07 Invalid `prisma.$queryRawUnsafe()` invocation:
2025-02-02 11:49:07 
2025-02-02 11:49:07 {
2025-02-02 11:49:07   query: "select count(*) as num from (\n    with events as (\n    select\n      event_id as \"id\",\n      website_id as \"websiteId\", \n      session_id as \"sessionId\",\n      created_at as \"createdAt\",\n      url_path as \"urlPath\",\n      url_query as \"urlQuery\",\n      referrer_path as \"referrerPath\",\n      referrer_query as \"referrerQuery\",\n      referrer_domain as \"referrerDomain\",\n      page_title as \"pageTitle\",\n      event_type as \"eventType\",\n      event_name as \"eventName\"\n    from website_event\n    where website_id = $1::uuid\n        and created_at between $2 and $3\n    \n    \n    order by created_at desc\n    limit 1000)\n    select * from events\n    ) t",
2025-02-02 11:49:07   parameters: {
2025-02-02 11:49:07     values: "[\"38b669df-e4e8-4c51-a1d1-fedbba019f38\",{\"prisma__type\":\"date\",\"prisma__value\":null},{\"prisma__type\":\"date\",\"prisma__value\":\"1970-01-01T00:00:00.000Z\"}]",
2025-02-02 11:49:07     __prismaRawParameters__: true
2025-02-02 11:49:07   }
2025-02-02 11:49:07   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2025-02-02 11:49:07 }
2025-02-02 11:49:07 
2025-02-02 11:49:07 Invalid value for argument `parameters`: Could not convert from `JSON date object` to `PrismaValue`. Expected Flat JSON array (no nesting).
2025-02-02 11:49:07     at wn (/app/node_modules/@prisma/client/runtime/library.js:29:1363)
2025-02-02 11:49:07     at $n.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:121:6958)
2025-02-02 11:49:07     at $n.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:121:6623)
2025-02-02 11:49:07     at $n.request (/app/node_modules/@prisma/client/runtime/library.js:121:6307)
2025-02-02 11:49:07     at async l (/app/node_modules/@prisma/client/runtime/library.js:130:9633)
2025-02-02 11:49:07     at async p (/app/.next/server/chunks/6711.js:1:21850)
2025-02-02 11:49:07     at async m (/app/.next/server/pages/api/websites/[websiteId]/events.js:1:2039)
2025-02-02 11:49:07     at async z (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:16764)
2025-02-02 11:49:07     at async U.render (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:17472)
2025-02-02 11:49:07     at async NextNodeServer.runApi (/app/node_modules/next/dist/server/next-server.js:618:9) {
2025-02-02 11:49:07   clientVersion: '5.22.0'
2025-02-02 11:49:07 }

Which Umami version are you using? (if relevant)

2.15.1

Which browser are you using? (if relevant)

None. Using Postman to requests

How are you deploying your application? (if relevant)

Docker, on my local machine

@mikecao
Copy link
Collaborator

mikecao commented Feb 3, 2025

What query parameters are you passing?

@Chr1s0Blood
Copy link
Author

What query parameters are you passing?

None. In other endpoints, the response says the missing field and doesn't give a 500 error, but this one does.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants