• Login
  • Register
    • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below
  • Forum
  • Website
  • GitHub
  • Status
  • Translation
  • Features
  • Team
  • Rules
  • Help
  • Feeds
User Links
  • Login
  • Register
    • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below

    Useful Links Forum Website GitHub Status Translation Features Team Rules Help Feeds
    Jellyfin Forum Development Plugin Development Jellyfin Newsletter Plugin

    Pages (8): « Previous 1 … 4 5 6 7 8 Next »
     

     
    • 1 Vote(s) - 5 Average

    Jellyfin Newsletter Plugin

    Discussion/Updates around the Jellyfin Newsletter Plugin (https://github.com/Cloud9Developer/Jellyfin-Newsletter-Plugin)
    Swindiff
    Offline

    Member
    Posts: 53
    Threads: 8
    Joined: 2023 Dec
    Reputation: 0
    Country:United Kingdom
    #61
    2025-04-20, 08:20 AM
    How my libraries are set

       
       
    TheDreadPirate
    Offline

    Community Moderator
    Posts: 15,375
    Threads: 10
    Joined: 2023 Jun
    Reputation: 459
    Country:United States
    #62
    2025-04-20, 11:07 PM
    Is a mixed library type? Why would it try to set a season number for a movies library?
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    Swindiff
    Offline

    Member
    Posts: 53
    Threads: 8
    Joined: 2023 Dec
    Reputation: 0
    Country:United Kingdom
    #63
    2025-04-21, 01:01 AM
    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?
    zeit003
    Offline

    Junior Member
    Posts: 3
    Threads: 0
    Joined: 2025 Apr
    Reputation: 0
    Country:France
    #64
    2025-04-21, 04:30 PM
    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()
    TheDreadPirate
    Offline

    Community Moderator
    Posts: 15,375
    Threads: 10
    Joined: 2023 Jun
    Reputation: 459
    Country:United States
    #65
    2025-04-21, 04:30 PM
    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.
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    zeit003
    Offline

    Junior Member
    Posts: 3
    Threads: 0
    Joined: 2025 Apr
    Reputation: 0
    Country:France
    #66
    2025-04-21, 04:47 PM
    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(IReadOnlyList    1 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(List    1 items, String type)
    at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.BuildJsonObjsToCurrScanfile()
    at Jellyfin.Plugin.Newsletters.Scripts.SCRAPER.Scraper.GetSeriesData()
    Swindiff
    Offline

    Member
    Posts: 53
    Threads: 8
    Joined: 2023 Dec
    Reputation: 0
    Country:United Kingdom
    #67
    2025-04-22, 10:35 AM
    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?
    Swindiff
    Offline

    Member
    Posts: 53
    Threads: 8
    Joined: 2023 Dec
    Reputation: 0
    Country:United Kingdom
    #68
    2025-04-22, 10:57 AM
    Replaced the body and entry text in the plugin from the modern templates in the template folder, still the same issue.
    Rubén Navarro López
    Offline

    Member
    Posts: 151
    Threads: 27
    Joined: 2023 Jun
    Reputation: 1
    Country:Spain
    #69
    2025-04-22, 11:15 AM (This post was last modified: 2025-04-22, 11:15 AM by Rubén Navarro López.)
    For me didn't work either, so I decided to use telegram plugin instead, is not the same, but is enough for me
    Swindiff
    Offline

    Member
    Posts: 53
    Threads: 8
    Joined: 2023 Dec
    Reputation: 0
    Country:United Kingdom
    #70
    2025-04-22, 12:44 PM
    It did actually work for me though, it just seemed to stop working for no reason?
    Pages (8): « Previous 1 … 4 5 6 7 8 Next »
     

    « Next Oldest | Next Newest »

    Users browsing this thread: 6 Guest(s)


    • View a Printable Version
    • Subscribe to this thread
    Forum Jump:

    Home · Team · Help · Contact
    © Designed by D&D - Powered by MyBB
    L


    Jellyfin

    The Free Software Media System

    Linear Mode
    Threaded Mode