• 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

     
    • 1 Vote(s) - 5 Average

    Jellyfin Newsletter Plugin

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

    Junior Member
    Posts: 4
    Threads: 0
    Joined: 2023 Aug
    Reputation: 0
    Country:Germany
    #29
    2024-05-30, 06:12 PM
    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.
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-10, 04:24 PM
    RE: Jellyfin Newsletter Plugin - by bitmap - 2023-08-10, 09:49 PM
    RE: Jellyfin Newsletter Plugin - by Yummy_rad - 2023-08-14, 02:16 AM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-14, 02:51 PM
    RE: Jellyfin Newsletter Plugin - by Marcus Junius - 2023-08-14, 05:13 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-14, 05:19 PM
    RE: Jellyfin Newsletter Plugin - by Marcus Junius - 2023-08-14, 05:24 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-14, 05:25 PM
    RE: Jellyfin Newsletter Plugin - by Rubén Navarro López - 2023-08-17, 11:42 AM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-17, 02:31 PM
    RE: Jellyfin Newsletter Plugin - by Venson - 2023-08-17, 12:31 PM
    RE: Jellyfin Newsletter Plugin - by Rubén Navarro López - 2023-08-17, 07:35 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-17, 07:49 PM
    RE: Jellyfin Newsletter Plugin - by Rubén Navarro López - 2023-08-17, 08:13 PM
    RE: Jellyfin Newsletter Plugin - by yxb25674 - 2023-08-24, 04:16 AM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2023-08-24, 05:45 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2024-05-15, 04:31 AM
    RE: Jellyfin Newsletter Plugin - by TheDreadPirate - 2024-05-15, 01:20 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2024-05-15, 08:42 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2024-05-19, 04:26 AM
    RE: Jellyfin Newsletter Plugin - by Yummy_rad - 2024-05-19, 12:06 PM
    RE: Jellyfin Newsletter Plugin - by TheDreadPirate - 2024-05-19, 04:07 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2024-05-19, 06:20 PM
    RE: Jellyfin Newsletter Plugin - by Yummy_rad - 2024-05-20, 02:20 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2024-05-20, 03:58 PM
    RE: Jellyfin Newsletter Plugin - by Yummy_rad - 2024-05-20, 05:45 PM
    RE: Jellyfin Newsletter Plugin - by cloud9_development - 2024-05-20, 10:52 PM
    RE: Jellyfin Newsletter Plugin - by Yummy_rad - 2024-05-21, 12:50 AM
    RE: Jellyfin Newsletter Plugin - by Marcus Junius - 2024-05-30, 06:12 PM
    RE: Jellyfin Newsletter Plugin - by Rubén Navarro López - 2024-11-14, 09:53 PM
    RE: Jellyfin Newsletter Plugin - by Rubén Navarro López - 2024-11-18, 09:30 PM
    RE: Jellyfin Newsletter Plugin - by TheDreadPirate - 2024-11-18, 09:46 PM
    RE: Jellyfin Newsletter Plugin - by Rubén Navarro López - 2024-11-18, 10:08 PM

    • 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