2025-03-23, 02:15 AM
(This post was last modified: 2025-03-23, 02:18 AM by sneakie. Edited 1 time in total.)
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.
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.