Jellyfin Newsletter Plugin

[Marcus Junius]

Hello,

I no longer receive newsletters under Jellyfin 10.9.x -10.9.3. I have uninstalled the plugin (0.6.4.2), including deleting the newsletter.db, then restarted the server and reinstalled the newsletter with the Modern Templet Body/entry.

The log shows the following:

[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Gathering Data...
[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Altering DB table: CurrRunData
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: PremiereYear
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: RunTime
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: OfficialRating
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: CommunityRating
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Altering DB table: CurrNewsletterData
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: PremiereYear
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: RunTime
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: OfficialRating
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: CommunityRating
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Altering DB table: ArchiveData
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: PremiereYear
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: RunTime
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: OfficialRating
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [WARN] Error: SQLitePCL.pretty.SQLiteException: duplicate column name: CommunityRating
  at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
  at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
  at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
  at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
  at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql)
  at Jellyfin.Plugin.Newsletters.Shared.DATA.SQLiteDatabase.CreateTables(String[] tables)
[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Parsing Series..
[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Scan Size: 11919
[NLP]: [2024-05-30] :: [20:00:48] - [INFO] Scanning 'Series'
[NLP]: [2024-05-30] :: [20:00:48] - [ERR] An error has occured: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.BuildObjs(List`1 items, String type)
  at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.BuildJsonObjsToCurrScanfile()
  at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.GetSeriesData()



I hope you can help me.