2025-03-23, 05:56 PM
(2025-03-23, 02:15 AM)sneakie Wrote: Ok. So I managed to create a new DB that resembles the real deal (206000 KB vs 200000 KB) which also passes the pragma integrity check, which leads me to believe it might have worked, though I cant be sure, because I don't think the integrity check is meant to see if a database is healthy, just to check for errors?
What I did was I changed '.dump' to '.recover' in the powershell command.
Just for some more information in case this isn't a solution or anyone comes across this:
When checking both Library.db & Jellyfin.db with pragma integrity check; they both produced these errors:
Jellyfin.db: row 34 missing from index IX_ActivityLogs_DateCreated
Library.db: *** in database main ***, Tree 7 page 39598 cell 37: Rowid 232781 out of order, database disk image is malformed
and after running powershell command above with the alterations, both appear to be error free.
The Jellyfin startup afterwards without all the database malformed messages?