Jellyfin Newsletter Plugin

[Yummy_rad]

Hi @cloud9_development,

I’ve installed the latest updated (looks like 0.6.4.2) and after restarting, when I go to my plugin dashboard it says status malfunctioning, but has another newsletter plugin (0.6.0.0), which says active. Also, all my settings look like they are gone.

[TheDreadPirate]

The Newsletter plugin was renamed. So you will have to stop jellyfin and go into the plugin directory and delete the older "Jellyfin Newsletter" folders.

Also, can confirm that the SMTP settings and template still don't carry over after our discussion in the Matrix chat last night. Did a test and a fresh Newsletter install has no body or entry template.

@Yummy_rad if you have a backup of your jellyfin data, you can find the plugin configuration file and copy and paste your SMTP settings. And you can find the updated templates on the git hub.

https://github.com/Cloud9Developer/Jelly.../Templates

[cloud9_development]

There was an error in 0.6.4.1 in which the templates didn't copy over to the artifact during build. Should have resolved when I pushed 0.6.4.2 last night. So templates (on fresh install) should populate now

As for the jellyfin rename, sorry about that! I updated the build method and that was an unfortunate side affect

[Yummy_rad]

So I’ve had to reconfigure things since the latest update and I can’t seem to get the email working, and I can’t remember my previous settings. I’m using my Gmail. Any tips for the SMTP config? Do I leave the port as? Is the username and password just my gmail username and password?

[cloud9_development]

the plugin uses gmail as default, so the port and server can remain the same! As for your username/password,

username would be your email address
password is a "developer" password (think I have instructional links on the README.md?), but I'll share a link here as well, give me a sec

---

https://support.google.com/mail/answer/185833?hl=en

---

Also, as TheDreadPirate stated above, "The Newsletter plugin was renamed. So you will have to stop jellyfin and go into the plugin directory and delete the older "Jellyfin Newsletter" folders."

I would recommend deleting these "Old/Extra" folders, then restarting Jellyfin

[Yummy_rad]

Thanks! I had forgotten about the developers password. Got it back working. I am using the modern body and modern entry templates. I notice in the email that the duration of and IMDb rating is empty in each entry.

[cloud9_development]

Thanks! I had forgotten about the developers password. Got it back working. I am using the modern body and modern entry templates. I notice in the email that the duration of and IMDb rating is empty in each entry.

Hmmm.. Maybe due to existing database not having those values set (for the current newsletter run)? It (SHOULD) either be picked for the next newsletter (with newly added media items) or you can delete the database completely and re-run so that the archive will have all new data as well

---

Thanks! I had forgotten about the developers password. Got it back working. I am using the modern body and modern entry templates. I notice in the email that the duration of and IMDb rating is empty in each entry.

Hmmm.. Maybe due to existing database not having those values set (for the current newsletter run)? It (SHOULD) either be picked for the next newsletter (with newly added media items) or you can delete the database completely and re-run so that the archive will have all new data as well

OR, if you know how, you can delete all entries from the CurrNewsletterData table from newsletters.db (located in your jellyfin's config/data directory):

delete from CurrNewsletterData;

Then rescan

[Yummy_rad]

Thanks for the help! I’ll wait until next email to see if it works itself out. Love the plug in!

[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.