mirror of
https://github.com/pocket-id/pocket-id.git
synced 2025-12-09 14:53:00 +03:00
🐛 Bug Report: Visiting "My Apps" fails on 1.8.1 #61
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 @johnnycube on GitHub.
Reproduction steps
Login as a normal user and click on "My Apps"
Error message in the logs:
time=2025-08-24T18:27:12.926Z level=INFO msg="Error #01: ERROR: for SELECT DISTINCT, ORDER BY expressions must ap │ │ pear in select list (SQLSTATE 42P10)" app=pocket-id version=1.8.1 request.time=2025-08-24T18:27:12.914Z request.m │ │ ethod=GET request.host=XXX request.path=/api/oidc/users/me/clients request.query="pagination[p │ │ ge[]=1&pagination[limit]=20&sort[column]=lastUsedAt&sort[direction]=desc" request.params=map[] request.route=/api │ │ /oidc/users/me/clients request.ip=192.168.100.82 request.referer=https://XXX/settings/audit-lo │ │ g request.length=0 response.time=2025-08-24T18:27:12.926Z response.latency=11.611045ms response.status=500 respon │ │ se.length=32Expected behavior
Show a list of accessible apps
Actual Behavior
See above mentioned error and log output
Pocket ID Version
1.8.1
Database
Postgres 17 Alpine
OS and Environment
K8s Talos in Proxmox VM
Log Output
time=2025-08-24T18:27:12.926Z level=INFO msg="Error #01: ERROR: for SELECT DISTINCT, ORDER BY expressions must ap │ │ pear in select list (SQLSTATE 42P10)" app=pocket-id version=1.8.1 request.time=2025-08-24T18:27:12.914Z request.m │ │ ethod=GET request.host=XXX request.path=/api/oidc/users/me/clients request.query="pagination[p │ │ ge[]=1&pagination[limit]=20&sort[column]=lastUsedAt&sort[direction]=desc" request.params=map[] request.route=/api │ │ /oidc/users/me/clients request.ip=192.168.100.82 request.referer=https://XXX/settings/audit-lo │ │ g request.length=0 response.time=2025-08-24T18:27:12.926Z response.latency=11.611045ms response.status=500 respon │ │ se.length=32@tilwegener commented on GitHub:
I have the same problem. Logs:
time=2025-08-24T18:35:16.921Z level=INFO msg="Error #01: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list (SQLSTATE 42P10)" app=pocket-id version=1.8.1 request.time=2025-08-24T18:35:16.914Z request.method=GET request.host=id.xxx.xxx 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://id.xxx.xxx/settings/account request.length=0 response.time=2025-08-24T18:35:16.921Z response.latency=7.486588ms response.status=500 response.length=32@stonith404 commented on GitHub:
Thanks, this should be fixed in
v1.9.0which is available in a few minutes.