Version: 0.2.7
Platform: Linux (x86, tar.gz)
Instance: Self-hosted via Docker (latest image)
Description:
When configuring the desktop app with a self-hosted instance and entering the Client ID, the app sends the full JWT access token as the OAuth Client ID in the database query instead of the UUID. This causes a 500 error.
Error from Laravel log:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "eyJ0eXAiOiJKV1Qi..."
SQL: select * from "oauth_clients" where "oauth_clients"."id" = eyJ0eXAiOiJKV1Qi...
Steps to reproduce:
Set up a self-hosted Solidtime instance
Install the desktop app (v0.2.7, Linux)
Open Settings in the desktop app
Enter the instance URL and a valid Client ID (personal access client UUID from oauth_clients table)
Click Save — browser opens for OAuth flow
After login, server returns 500
Expected behavior:
The app should use the Client ID UUID for the OAuth client lookup, not the JWT token.
Additional context:
The oauth_clients table contains valid entries with grant_types: ["personal_access"]. The Client ID UUID is correct. The issue appears to be that the app passes the JWT token in a query that expects a UUID.
Version: 0.2.7
Platform: Linux (x86, tar.gz)
Instance: Self-hosted via Docker (latest image)
Description:
When configuring the desktop app with a self-hosted instance and entering the Client ID, the app sends the full JWT access token as the OAuth Client ID in the database query instead of the UUID. This causes a 500 error.
Error from Laravel log:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "eyJ0eXAiOiJKV1Qi..."
SQL: select * from "oauth_clients" where "oauth_clients"."id" = eyJ0eXAiOiJKV1Qi...
Steps to reproduce:
Set up a self-hosted Solidtime instance
Install the desktop app (v0.2.7, Linux)
Open Settings in the desktop app
Enter the instance URL and a valid Client ID (personal access client UUID from oauth_clients table)
Click Save — browser opens for OAuth flow
After login, server returns 500
Expected behavior:
The app should use the Client ID UUID for the OAuth client lookup, not the JWT token.
Additional context:
The oauth_clients table contains valid entries with grant_types: ["personal_access"]. The Client ID UUID is correct. The issue appears to be that the app passes the JWT token in a query that expects a UUID.