App sometime fails to start due to missing loadable for pin in database.

[meganukebmp]

Sometimes the application would randomly freeze on load and not get anywhere (logcat attached).
Inspecting it reveals an SQL issue of some sort, tho I'm not familiar with this app's codebase.
I have no steps to reproduce but I think I have narrowed down the issue.
When the app exhibits this behavior going through ChanDB I can see that there are values in pins which point to values that do not exist in the loadable table. Removing those entries from the pins table makes the app launch again (at the cost of losing that pin)
It appears that there is some sort of issue preventing the creation of loadable entries sometimes, or alternatively the clearing of loadable entries but not pins on pin removal. Unsure which as I have no reproduction steps.
I've had these issues on all versions after v4.13.6-da888f34. That version and prior have never caused any problems.

The first time it happened I had wiped all app data and re-set up manually (no imports) so it shouldn't be an invalid config.

logcat_10-21-2022_05-31-03.txt

[Adamantcheese]

I appreciate the logcat files, looks like some pin loadables have their site ID set to zero instead of an actual site model ID that's in the database, not that the loadables don't exist in the database (that would be showing a different exception message entirely). I'll take a closer look at anywhere that could be missing that assignment or if I accidentally touched something I shouldn't have.