🐛 Bug Report: Blank My Apps tiles repeating #89

Closed
opened 2025-10-07 00:01:19 +03:00 by OVERLORD · 3 comments
Owner

Originally created by @mitchplze on GitHub.

Reproduction steps

Hello, I have just setup Client Launch URLs for each of my apps. Nifty!

The My Apps view seems to show the tiles properly, but also there is a random tile (with my Pocket ID app logo) that appears randomly after some of them:

Image

When I click on one and then Edit, I am taken to settings/admin/oidc-clients

I have cleared cache and restarted, same issue.

Expected behavior

Apps should be shown without extra buggy tiles

Actual Behavior

Random tiles everywhere!

Image

Version and Environment

Version 1.7.0 on docker

Log Output

No response

Originally created by @mitchplze on GitHub. ### Reproduction steps Hello, I have just setup **Client Launch URLs** for each of my apps. Nifty! The **My Apps** view seems to show the tiles properly, but also there is a random tile (with my Pocket ID app logo) that appears randomly after some of them: <img width="1182" height="753" alt="Image" src="https://github.com/user-attachments/assets/b19e3b82-06ad-4766-a96b-f4983003cdb0" /> When I click on one and then **Edit**, I am taken to `settings/admin/oidc-clients` I have cleared cache and restarted, same issue. ### Expected behavior Apps should be shown without extra buggy tiles ### Actual Behavior Random tiles everywhere! <img width="922" height="808" alt="Image" src="https://github.com/user-attachments/assets/e583e8cc-1222-484a-80d1-4863ce2b302a" /> ### Version and Environment Version `1.7.0` on docker ### Log Output _No response_
Author
Owner

@stonith404 commented on GitHub:

Thanks for reporting this.

The issue is that the authorizations (the app cards in the dashboard) don't get deleted if the corresponding OIDC client gets deleted. This is because default connection string for Sqlite doesn't enforce foreign key constraints, we have to add the foreign_keys=on option.

Before we add this option we have to check all foreign key constraints in the Sqlite database schema to make sure that this doesn't break anything. I'll look into it as soon as I have time.

@stonith404 commented on GitHub: Thanks for reporting this. The issue is that the authorizations (the app cards in the dashboard) don't get deleted if the corresponding OIDC client gets deleted. This is because default connection string for Sqlite doesn't enforce foreign key constraints, we have to add the `foreign_keys=on` option. Before we add this option we have to check all foreign key constraints in the Sqlite database schema to make sure that this doesn't break anything. I'll look into it as soon as I have time.
Author
Owner

@stonith404 commented on GitHub:

Yeah, I linked the wrong issue in the PR. This should be fixed too and will be available in the next release.

@stonith404 commented on GitHub: Yeah, I linked the wrong issue in the PR. This should be fixed too and will be available in the next release.
Author
Owner

@ElioDiNino commented on GitHub:

@stonith404 Was this also fixed as part of #832?

@ElioDiNino commented on GitHub: @stonith404 Was this also fixed as part of #832?
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/pocket-id#89