Cancelled schedules not removed from TV database

Discussion in 'Area 51 - Testing Area' started by elliottmc, August 30, 2014.

  1. elliottmc
    • Premium Supporter

    elliottmc Retired Team Member

    Joined:
    August 7, 2005
    Messages:
    14,927
    Likes Received:
    4,011
    Gender:
    Male
    Location:
    Cardiff, UK
    Ratings:
    +5,503 / 13
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    Hi,

    Whenever you set a series recording and then cancel an episode, an entry is created in the 'canceledschedule' table in the database.

    This allows MP to check and not record this one.

    The problem is, these are NEVER removed.

    With the fix,

    https://issues.team-mediaportal.com/browse/MP1-2719

    they are removed if they are older than 48 hours.

    (in the GIT branch it waits 5 days, but I changed this to 2 days to make it easier to test)



    I have provided an installer for only the TV part.

    You need to be running 1.9.0 Pre Release, and if you install this over the top, you will add this fix and a few updated tuning details.

    We need testers with MSSQL. Already tested with MySQL, but more testing is also good.

    Please provide TV logs (TVService.log). You should see line like

    [2014-08-29 19:00:12,926] [Log ] [scheduler thread] [DEBUG] - DeleteAllCancelledSeries: Removing 8/27/2014 7:00:00 PM

    (the first time you will probably see lots)

    It will help if you know how to check the relevant tables in your database.

    Because this fix only removes canceledschedules, the only likely regression is that something will record that you didn't want. However, this is for testing, so take your chances!

    Please test and report back!

    Thanks!
     
    • Like Like x 2
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. frankteb
    • Premium Supporter

    frankteb MP Donator

    Joined:
    April 5, 2005
    Messages:
    1,118
    Likes Received:
    88
    Gender:
    Male
    Ratings:
    +92 / 1
    Home Country:
    Germany Germany
    Show System Specs
    Thanks. Have this bug a long time (since 1.3 as far as I remember). Unfortunally I'm not using 1.9 pre at this moment, so I can't test it.
     
  4. Lehmden
    • Premium Supporter

    Lehmden Retired Team Member

    Joined:
    December 17, 2010
    Messages:
    11,894
    Likes Received:
    2,151
    Gender:
    Male
    Location:
    Lehmden
    Ratings:
    +3,626 / 28
    Home Country:
    Germany Germany
    Show System Specs
    Hi.
    Running SQLExpress 2014 and will test later, when I'm back home.
     
    • Thank You! Thank You! x 2
  5. Lehmden
    • Premium Supporter

    Lehmden Retired Team Member

    Joined:
    December 17, 2010
    Messages:
    11,894
    Likes Received:
    2,151
    Gender:
    Male
    Location:
    Lehmden
    Ratings:
    +3,626 / 28
    Home Country:
    Germany Germany
    Show System Specs
    Hi.
    Fix seems to work with SQL Express 2014 too...
    Will try to look into DB later to see if table really is altered
     

    Attached Files:

    • TVService.7z
      File size:
      7.8 KB
      Uploaded:
      September 1, 2014
      Views:
      95
    • Like Like x 1
  6. Lehmden
    • Premium Supporter

    Lehmden Retired Team Member

    Joined:
    December 17, 2010
    Messages:
    11,894
    Likes Received:
    2,151
    Gender:
    Male
    Location:
    Lehmden
    Ratings:
    +3,626 / 28
    Home Country:
    Germany Germany
    Show System Specs
    Hi.
    Had a look into the DB itself. Oldest entry in table is from 2014-08-31 04:25:00.000.
    So it's less than 2 days old. With SQL Express 2014 all is working as expected, I think.
     
    • Thank You! Thank You! x 2
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!