starred/pocket-id-pocket-id-1
1
0
Fork 0
mirror of https://github.com/pocket-id/pocket-id.git synced 2025-12-09 14:53:00 +03:00
Code Issues 122 Packages Projects Releases 10 Wiki Activity

🐛 Bug Report: Can no longer create OIDC clients #169

New Issue
Closed
opened 2025-10-07 23:56:03 +03:00 by OVERLORD · 7 comments
OVERLORD commented 2025-10-07 23:56:03 +03:00
Owner
Copy Link

Originally created by @dougmeredith on GitHub.

Reproduction steps

In the UI, create a new client. Just specify a name and nothing else.

Expected behavior

It should create a client.

Actual Behavior

It reports "Something went wrong".

From the log:

SQL logic error: table oidc_clients has no column named credentials (1)

Version and Environment

v1.3.0

Database is SQLite.

Log Output

No response

Originally created by @dougmeredith on GitHub. ### Reproduction steps In the UI, create a new client. Just specify a name and nothing else. ### Expected behavior It should create a client. ### Actual Behavior It reports "Something went wrong". From the log: ``` SQL logic error: table oidc_clients has no column named credentials (1) ``` ### Version and Environment v1.3.0 Database is SQLite. ### Log Output _No response_
OVERLORD added the bug label 2025-10-07 23:56:03 +03:00
OVERLORD commented 2025-10-07 23:56:06 +03:00
Author
Owner
Copy Link

@golias17 commented on GitHub:

Also no errors, and updated from 1.2.0 to 1.3.0.

@golias17 commented on GitHub: Also no errors, and updated from 1.2.0 to 1.3.0.
OVERLORD commented 2025-10-07 23:56:06 +03:00
Author
Owner
Copy Link

@golias17 commented on GitHub:

Having the same problem with PostgreSQL.

2025-06-09 21:32:04.939 BST [1614] ERROR:  column "credentials" of relation "oidc_clients" does not exist at character 159
2025-06-09 21:32:04.939 BST [1614] STATEMENT:  UPDATE "oidc_clients" SET "created_at"=$1,"name"=$2,"secret"=$3,"callback_urls"=$4,"logout_callback_urls"=$5,"image_type"=$6,"is_public"=$7,"pkce_enabled"=$8,"credentials"=$9,"created_by_id"=$10 WHERE "id" = $11
@golias17 commented on GitHub: Having the same problem with PostgreSQL. ``` 2025-06-09 21:32:04.939 BST [1614] ERROR: column "credentials" of relation "oidc_clients" does not exist at character 159 2025-06-09 21:32:04.939 BST [1614] STATEMENT: UPDATE "oidc_clients" SET "created_at"=$1,"name"=$2,"secret"=$3,"callback_urls"=$4,"logout_callback_urls"=$5,"image_type"=$6,"is_public"=$7,"pkce_enabled"=$8,"credentials"=$9,"created_by_id"=$10 WHERE "id" = $11 ```
OVERLORD commented 2025-10-07 23:56:07 +03:00
Author
Owner
Copy Link

@dougmeredith commented on GitHub:

I tried restarting it, and there were no errors.

@dougmeredith commented on GitHub: I tried restarting it, and there were no errors.
OVERLORD commented 2025-10-07 23:56:08 +03:00
Author
Owner
Copy Link

@kmendell commented on GitHub:

If you restart the container do you see any logs about migrations failing?

@kmendell commented on GitHub: If you restart the container do you see any logs about migrations failing?
OVERLORD commented 2025-10-07 23:56:08 +03:00
Author
Owner
Copy Link

@stonith404 commented on GitHub:

Thanks for reporting this, this should be fixed in v1.3.1. The Docker image is available in a few minutes.

The issue was that the migration for creating this column was initially created before the migration you ran. Because of that Pocket ID thought that it already applied every necessary migration. I have changed the timestamp of this migration which should fix the isue.

@stonith404 commented on GitHub: Thanks for reporting this, this should be fixed in `v1.3.1`. The Docker image is available in a few minutes. The issue was that the migration for creating this column was initially created before the migration you ran. Because of that Pocket ID thought that it already applied every necessary migration. I have changed the timestamp of this migration which should fix the isue.
OVERLORD commented 2025-10-07 23:56:09 +03:00
Author
Owner
Copy Link

@dougmeredith commented on GitHub:

Awesome. Thanks for the quick attention to this.

@dougmeredith commented on GitHub: Awesome. Thanks for the quick attention to this.
OVERLORD commented 2025-10-07 23:56:09 +03:00
Author
Owner
Copy Link

@golias17 commented on GitHub:

Great, thanks a lot

@golias17 commented on GitHub: Great, thanks a lot
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
breaking
bug
documentation
feature
needs more upvotes
open to pull requests
pull-request
Mirrored from GitHub Pull Request
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/pocket-id-pocket-id-1#169
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?