🐛 Bug Report: Can't load "My Apps" page #40

Closed
opened 2025-10-07 23:50:41 +03:00 by OVERLORD · 5 comments
Owner

Originally created by @paolodc95 on GitHub.

Reproduction steps

Login and click on "My Apps"

Expected behavior

Page loads correctly

Actual Behavior

Error page

Image

Pocket ID Version

v1.10.0

Database

postgres 16

OS and Environment

Docker in Uraid OS, traefik reverse proxy

Log Output

time=2025-09-05T16:44:02.672+02:00 level=INFO msg="Error #01: invalid field" app=pocket-id version=1.10.0 request.time=2025-09-05T14:44:02.669Z request.method=GET request.host=XXX.XXX.com request.path=/api/oidc/users/me/clients request.query="pagination[page]=1&pagination[limit]=20&sort[column]=lastUsedAt&sort[direction]=desc" request.params=map[] request.route=/api/oidc/users/me/clients request.ip=192.168.1.1 request.referer=https://XXX.XXX.com/settings/account request.length=0 response.time=2025-09-05T14:44:02.672Z response.latency=2.678424ms response.status=500 response.length=32

Originally created by @paolodc95 on GitHub. ### Reproduction steps Login and click on "My Apps" ### Expected behavior Page loads correctly ### Actual Behavior Error page <img width="505" height="351" alt="Image" src="https://github.com/user-attachments/assets/0328a31c-172a-4983-b03a-665aeabda565" /> ### Pocket ID Version v1.10.0 ### Database postgres 16 ### OS and Environment Docker in Uraid OS, traefik reverse proxy ### Log Output time=2025-09-05T16:44:02.672+02:00 level=INFO msg="Error #01: invalid field" app=pocket-id version=1.10.0 request.time=2025-09-05T14:44:02.669Z request.method=GET request.host=XXX.XXX.com request.path=/api/oidc/users/me/clients request.query="pagination[page]=1&pagination[limit]=20&sort[column]=lastUsedAt&sort[direction]=desc" request.params=map[] request.route=/api/oidc/users/me/clients request.ip=192.168.1.1 request.referer=https://XXX.XXX.com/settings/account request.length=0 response.time=2025-09-05T14:44:02.672Z response.latency=2.678424ms response.status=500 response.length=32
Author
Owner

@paolodc95 commented on GitHub:

I did manage to make it work executing these queries on db. Should I do something else?

Thank you

@paolodc95 commented on GitHub: I did manage to make it work executing [these](https://github.com/pocket-id/pocket-id/issues/866#issuecomment-3217887941) queries on db. Should I do something else? Thank you
Author
Owner

@stonith404 commented on GitHub:

Version 1.8 was broken, and some people used a workaround that may have damaged the database schema. Did you ever run anything manually on the database?

@stonith404 commented on GitHub: Version 1.8 was broken, and some people used a workaround that may have damaged the database schema. Did you ever run anything manually on the database?
Author
Owner

@janlauber commented on GitHub:

Does this have something to do with nginx settings: https://pocket-id.org/docs/advanced/nginx-reverse-proxy

I had similar behaviours in my k8s cluster with nginx ingress controller and saw the documentation site and adjusted it.
Now it's working great.

@janlauber commented on GitHub: Does this have something to do with nginx settings: https://pocket-id.org/docs/advanced/nginx-reverse-proxy I had similar behaviours in my k8s cluster with nginx ingress controller and saw the documentation site and adjusted it. Now it's working great.
Author
Owner

@stonith404 commented on GitHub:

Ok great, that should be enough.

@stonith404 commented on GitHub: Ok great, that should be enough.
Author
Owner

@paolodc95 commented on GitHub:

Yes I did set to false the dirty column in a row in schema_migration

@paolodc95 commented on GitHub: Yes I did set to false the dirty column in a row in schema_migration
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/pocket-id-pocket-id-1#40