Jellyfin Newsletter Plugin

[zeit003]

After
Renamed Newsletter.xml to backup
Deleted the Newletter DB
Uninstalled the Newsletter plugin
Restarted Jellyfin
Installed the newsletter plugin
Restarted Jellyfin
Scraped my libraries

always
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Gathering Data...
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Altering DB table: CurrRunData
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Altering DB table: CurrNewsletterData
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Altering DB table: ArchiveData
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Parsing Series..
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Scan Size: 5132
[NLP]: [2025-04-23] :: [18:05:35] - [INFO] Scanning 'Series'
[NLP]: [2025-04-23] :: [18:05:36] - [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-23] :: [18:05:36] - [WARN] Setting Season number to 0 (SPECIALS)
[NLP]: [2025-04-23] :: [18:05:36] - [ERR] Encountered an error parsing: /mnt/ds918/Séries/Camera Cafe/S02/Caméra Café S02E74.mkv
[NLP]: [2025-04-23] :: [18:05:36] - [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-23] :: [18:05:36] - [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()

[Swindiff]

It just started working for me again, which is really weird. I still get some errors in the log, but nothing like before with everything trying to be set as series 0 (SPECIALS)

I know that when I have a collection of movies in a collection folder, that it cannot retrieve the poster art, but it also fails to retrieve the poster art if I update a movie to a better version that is not part of a collection. For example, I delete a 1080p file and replace it with a 4K one. The folder that the file is in will have the same name, but the name of the file will be different. Any idea why this would be the case?

I may eventually end up renaming my folders so they are no longer part of a collection folder and in the root library folder

[Swindiff]

This is a bit of a curious one.  I understand that the Newsletter can't navigate the path to movies which are in sub folders when part of a collection, all movies need to be in the library root folder for it to be able to find the images.  However, I have just added Star Trek TOS to my TV collection and it has decided to use the poster image from the 2009 Star Trek movie which is in a collection folder, not in the movie library root.  How is this possible?

Star Trek (2009) movie shown in the Alternate Reality Collection Folder
   

Star Trek Original Series in the Library root "TV Shows"
   

In the email it has used the image from the movie for the TV show?????
   

[xupd39baw]

Ive read logs and chased, installed/removed, I feel like ive tried everything and I must be missing something. since imgur is down or broken, Ive tried the local settings to get images to no avail.  Has anyone gotten this to work.  Ive tried it with my local ip and my public url with nothing.  The install says if you use local it calls on the jellyfin api, am I supposed to enter it somewhere???  Also, I have the smpt settings correct as I get test email.  but have yet to get an email regarding media....

Update.  now getting info only, no images.

[xupd39baw]

ok, the body is working like it should, just no images. I really like this plugin and I know its something I have wrong. Any help is greatly appreciated.

****** Edit *****

Got it, finally. Learning something new from every failed attempt, I deleted all .db and xml, uninstalled plugin, reinstalled plugin, setup up correctly and it works like a charm. Thank you for the time you put into this plugin, its great.