2025-04-06, 03:07 PM
(This post was last modified: 2025-04-06, 03:10 PM by alike. Edited 2 times in total.)
I tried something else. I had in the SQL file I had dumped to dump.sql, a line that said "ROLLBACK; -- due to errors" at the end of the file. I changed this to "COMMIT;" and then dumped the dump.sql to .db using command "SQLite3 library.db" and then ".read dump.sql"
Now the former bad library is working at 85% syncing the changes since... a along time ago. I don't know if I actually fixed the database, but at least I am allowed to search for changes on it for now. Very excited! I'll share the jellyfin server log later when its finished.
Now the former bad library is working at 85% syncing the changes since... a along time ago. I don't know if I actually fixed the database, but at least I am allowed to search for changes on it for now. Very excited! I'll share the jellyfin server log later when its finished.