How does title.db update?

[brendongl]

Issue: Games missing from Ownfoil / Tinfoil library despite auto-download setup

Description
I recently updated my Switch to the latest firmware and dumped fresh prod.keys. I uploaded these keys to Ownfoil successfully.

My setup:
Auto-download of latest NSP/XCI files
Folder mounted correctly, files unzipped
Rescans and reboots attempted

Problem: many games do not appear in Ownfoil automatically or take awhile to do so. For example:
Hades 2 (0100A00019DE0000) does not show up in Tinfoil
Hollow Knight: Silksong also fails to appear

Error Log (Silksong example)
[2025-09-29 08:43:48.033] ERROR (app) Error during scheduled library scan job: (sqlite3.IntegrityError) UNIQUE constraint failed: files.filepath
[SQL: INSERT INTO files (library_id, filepath, folder, filename, extension, size, compressed, multicontent, nb_content, download_count, identified, identification_type, identification_error, identification_attempts, last_attempt) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING id]
[parameters: (2, '/games2/Nintendo Switch/Hollow_Knight_Silksong_NSW-VENOM/v-hollow_knight_silksong.nsp', '/games2/Nintendo Switch/Hollow_Knight_Silksong_NSW-VENOM', 'v-hollow_knight_silksong.nsp', 'nsp', 2492438806, 0, 0, 0, 0, 0, None, None, 0, '2025-09-27 12:43:34.719937')]

Additional Info

My files do not include the title ID in the filename, but I expected the app would scan for them.
Many missing entries seem to be non-English releases (which I can ignore), but others are new releases like Hades 2.

Questions:

Do I need to re-scan manually each time, or is there an automatic rescan schedule?
How can I resolve the UNIQUE constraint failed error and ensure new games are imported correctly?

Thank you so much

EDIT:
So the problem was i was using lockpick RCM which doesnt work for fw20+
I since then used this one https://gbatemp.net/download/lockpick_rcm-1-9-15-fw-20-zoria.39129/ and i tested by viewing the file with nxfileviewer and it works. So now ownfoil can finally scan all the new games.

[brendongl]

But still would love an answer - after fixing the keys issue. Its still not loading the latest game Super_Mario_Galaxy and Super_Mario_Galaxy_2 - i checked titleDB us.en.json and the titleIDs exist there, and the keys can decode the nsp as i used the same ones in nxfileviewer.

[Dan-Wood]

It downloads from

TITLEDB_ARTEFACTS_URL = 'https://nightly.link/a1ex4/ownfoil/workflows/region_titles/master/titledb.zip'

In https://github.com/a1ex4/ownfoil/blob/master/app/titledb.py

[HarleyBartles]

My PR #250 will allow you to add metadata overrides to force these "missing" titles to show in tinfoil. Of the games you mentioned, I can confirm the issue for both Super Mario Galaxy games, Hades 2 and some others - they appear in ownfoil library but tinfoil displays them as just their title id.

I added a region (US but it doesn't matter, whatever you have) as an override to these games and they now appear with their correct titles in my tinfoil. For some I also added a description override and that too comes through to tinfoil.

Idk what the underlying issue preventing them from showing properly in the first place might be - if I had to guess, ownfoil has a more up to date titledb than tinfoil - but metadata overrides certainly help to patch the problem and get them showing where they're expected to show.

Appreciate any and all feedback on the PR

[HarleyBartles]

See issue #255 for reference to my proposed fix for tinfoil's titledb being out of date and automatically resetting itself to an out of date version if you manually add an up to date version.