So, an update. I ran these commands:
This didn't work.
But, I did get it working eventually. The problem, once again, was me. Turns out I need to touch up on my docker skills. I had started jellyfin using docker compose, yet I was using standard docker commands to try and stop it to edit the database. At some point I had accidentally started a standard docker instance too, I had two of the little fuckers running at the same time and things got messy. What I should have done is "docker compose down" to stop jellyfin, edit the database and then run "docker compose up".
Quote:docker stop jellyfin
UPDATE Users SET InvalidLoginAttemptCount = 0 WHERE Username = '[MyAdminUsernameHere]';
UPDATE Permissions SET Value = 0 WHERE Kind = 2 AND UserId IN (SELECT Id FROM Users WHERE Username = '[MyAdminUsernameHere]');
UPDATE Permissions SET Value = 1 WHERE (Kind = 0 OR Kind = 3 OR Kind = 4 OR Kind = 5 OR Kind = 6 OR Kind = 7 OR Kind = 8 OR Kind = 9 OR Kind = 10 OR Kind = 11 OR Kind = 12 OR Kind = 13 OR Kind = 14 OR Kind = 15 OR Kind = 16 OR Kind = 17 OR Kind = 18 OR Kind = 19 OR Kind = 20 OR Kind = 21) AND UserId IN (SELECT Id FROM Users WHERE Username = '[MyAdminUsernameHere]');
docker start jellyfin
This didn't work.
But, I did get it working eventually. The problem, once again, was me. Turns out I need to touch up on my docker skills. I had started jellyfin using docker compose, yet I was using standard docker commands to try and stop it to edit the database. At some point I had accidentally started a standard docker instance too, I had two of the little fuckers running at the same time and things got messy. What I should have done is "docker compose down" to stop jellyfin, edit the database and then run "docker compose up".