Jellyfin Forum
Jellyfin Newsletter Plugin - Printable Version

+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Development (https://forum.jellyfin.org/f-development)
+--- Forum: Plugin Development (https://forum.jellyfin.org/f-plugin-development)
+--- Thread: Jellyfin Newsletter Plugin (/t-jellyfin-newsletter-plugin)

Pages: 1 2 3 4 5 6 7 8

RE: Jellyfin Newsletter Plugin - Swindiff - 2025-04-20

How my libraries are set

   
   

RE: Jellyfin Newsletter Plugin - TheDreadPirate - 2025-04-20

Is a mixed library type? Why would it try to set a season number for a movies library?

RE: Jellyfin Newsletter Plugin - Swindiff - 2025-04-21

No not mixed just movies. Very good question, I have no idea.
Any idea why when I Uninstalled the plugin and then reinstalled it, it remembered all the settings?

RE: Jellyfin Newsletter Plugin - zeit003 - 2025-04-21

Hello
I have almoste the same problem
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Gathering Data...
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Altering DB table: CurrRunData
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Altering DB table: CurrNewsletterData
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Altering DB table: ArchiveData
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Parsing Movie..
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Scan Size: 567
[NLP]: [2025-04-21] :: [18:21:53] - [INFO] Scanning 'Movie'
[NLP]: [2025-04-21] :: [18:21:53] - [WARN] Encountered an error parsing Season Number for: /mnt/ds918/Films/Conan le destructeur/Conan le destructeur.mkv
[NLP]: [2025-04-21] :: [18:21:53] - [WARN] Setting Season number to 0 (SPECIALS)
[NLP]: [2025-04-21] :: [18:21:53] - [ERR] An error has occured: Error: SQLitePCL.pretty.SQLiteException: 14 values for 13 columns
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.Scripts.SCRAPER.Scraper.BuildObjs(List`1 items, String type)
at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.GetSeriesData()

RE: Jellyfin Newsletter Plugin - TheDreadPirate - 2025-04-21

You would probably need to delete the XML file for the newsletter plugin in the configurations sub-folder within the plugins folder.

I would back that up instead of straight up deleting it.

RE: Jellyfin Newsletter Plugin - zeit003 - 2025-04-21

thanks for your answer but i have always a error
[NLP]: [2025-04-21] :: [18:45:53] - [INFO] Gathering Data...
[NLP]: [2025-04-21] :: [18:45:53] - [INFO] Altering DB table: CurrRunData
[NLP]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [INFO] Altering DB table: CurrNewsletterData
[NLP]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [INFO] Altering DB table: ArchiveData
[NLP]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:53] - [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]: [2025-04-21] :: [18:45:54] - [INFO] Parsing Series..
[NLP]: [2025-04-21] :: [18:45:54] - [INFO] Scan Size: 5132
[NLP]: [2025-04-21] :: [18:45:54] - [INFO] Scanning 'Series'
[NLP]: [2025-04-21] :: [18:45:54] - [WARN] Encountered an error parsing Season Number for: /mnt/ds918/Séries/Kaamelott/Kaamelott.S04.FRENCH.720p.BluRay.x264-UKDTV/Kaamelott.S04E86.FRENCH.720p.BluRay.x264-UKDTV/Kaamelott.S04E86.FRENCH.720p.BluRay.x264-UKDTV.mkv
[NLP]: [2025-04-21] :: [18:45:54] - [WARN] Setting Season number to 0 (SPECIALS)
[NLP]: [2025-04-21] :: [18:45:54] - [ERR] Encountered an error parsing: /mnt/ds918/Séries/Camera Cafe/S02/Caméra Café S02E74.mkv
[NLP]: [2025-04-21] :: [18:45:54] - [ERR] System.FormatException: The input string '-1.0' was not in a correct format.
at System.Number.ThrowFormatException[TChar](ReadOnlySpan1 value)
at Jellyfin.Plugin.Newsletters.Scripts.ENTITIES.JsonFileObj.ConvertToObj(IReadOnlyList1 row)
at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.SetImageURL(JsonFileObj currObj)
at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.BuildObjs(List1 items, String type)
[NLP]: [2025-04-21] :: [18:45:54] - [ERR] An error has occured: Error: SQLitePCL.pretty.SQLiteException: 14 values for 13 columns
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.Scripts.SCRAPER.Scraper.BuildObjs(List1 items, String type)
at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.BuildJsonObjsToCurrScanfile()
at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.GetSeriesData()

RE: Jellyfin Newsletter Plugin - Swindiff - 2025-04-22

Renamed Newsletter.xml to backup
Deleted the Newletter DB
Uninstalled the Newsletter plugin
Restarted Jellyfin
Installed the newsletter plugin
Restarted Jellyfin
Configured the plugin
Tested email was working OK
Scraped my libraries
Sent email
Log still showing the same, loads of errors with everything trying to be assigned to Season 0 (SPECIALS)

The only thing I can think is that something has got messed up in the Body or Entry Data HTML?

RE: Jellyfin Newsletter Plugin - Swindiff - 2025-04-22

Replaced the body and entry text in the plugin from the modern templates in the template folder, still the same issue.

RE: Jellyfin Newsletter Plugin - Jolaru21 - 2025-04-22

For me didn't work either, so I decided to use telegram plugin instead, is not the same, but is enough for me

RE: Jellyfin Newsletter Plugin - Swindiff - 2025-04-22

It did actually work for me though, it just seemed to stop working for no reason?