SOLVED: Continue Watching not working for one user after update

[icassassin]

I'm also having this problem since upgrading from 10.10.7. I'm running this on an Ubuntu 24.04 install, native binaries.

When I first upgraded via apt, migration failed due to 'libjemalloc' not being on my system at the time. I installed that and restarted Jellyfin and things were working OK. I did a full library scan and that went through without a hitch. But the only things showing up in 'Continue Watching' were the TV shows that were there before the upgrade. No movies show up, despite some having been in 'Continue Watching' before the upgrade. Subsequent watches of any movie or TV show do not add into 'Continue Watching'. Watching or marking watched a TV show in the 'Continue Watching' header will remove it.

I also tried remigrating but that doesn't seem to be working. Whenever I rename 'library.db.old' to 'library.db' and remove 'jellyfin.db' I see this in the logs:

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: __EFMigrationsHistory'.
  at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
  at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
  at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
  at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
  at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)

and Jellyfin does not start. I've tried toying with renaming 'migrating.xml.backup' to 'migrating.xml' in settings but still the same thing. I'm not sure if I'm supposed to do something else to get Jellyfin to try the migration again and I'm just doing it wrong.