TV Recordings folder coming up empty

Discussion in 'Television (MyTV frontend and TV-Server)' started by onetoomany, April 6, 2013.

  1. onetoomany

    onetoomany Portal Pro

    Joined:
    July 5, 2005
    Messages:
    122
    Likes Received:
    1
    Location:
    UK
    Ratings:
    +2 / 0
    I've upgraded my tv server to 1.3.0 and one of my clients (plus DJBlu's Sky EPG plugin patch). The 1.3.0 was a clean install on both the client and server.



    On the 1.2.3 client, no problems - lots of recordings visible and playable.
    On the 1.3.0 client, the "My Recordings" screen comes up empty. There is an error in the log file:
    Code (Text):
    1. 2013-04-06 23:10:48.309490 [ERROR][MPMain(1)]: TvRecorded: Error fetching recordings from database The number of returned rows 0 did not match the expected count of 1.
    I can watch live TV, and schedule new recordings though.

    I've completely uninstalled the client and reinstalled, but I get the same issue.

    I've attached the tv client and server log files.

    Richard.
     

    Attached Files:

    • client.zip
      File size:
      3.9 KB
      Uploaded:
      April 6, 2013
      Views:
      61
    • server.zip
      File size:
      1.5 KB
      Uploaded:
      April 6, 2013
      Views:
      68
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. kiwijunglist
    • Team MediaPortal

    kiwijunglist Super Moderator

    Joined:
    June 10, 2008
    Messages:
    6,746
    Likes Received:
    1,420
    Occupation:
    Doctor
    Location:
    New Zealand
    Ratings:
    +1,849 / 9
    Home Country:
    New Zealand New Zealand
    Show System Specs
    Haven't looked at your logs, but this may work.

    Stop tvservice (Windows key -> type services.msc -> press enter)

    Backup and then delete your tvrecordings database file
    (I'm guessing it should be .db3 extension and located under start->team mp->mp->user files, on your server pc)

    Open tvserver config

    Import your tv recordings directory
    http://wiki.team-mediaportal.com/1_...guration/TV-Server_Configuration/07_Recording
     
    Last edited: April 7, 2013
  4. Edalex
    • Premium Supporter

    Edalex Community Plugin Dev

    Joined:
    January 3, 2008
    Messages:
    2,908
    Likes Received:
    713
    Gender:
    Male
    Location:
    Saratov
    Ratings:
    +1,229 / 9
    Home Country:
    Russian Federation Russian Federation
    Show System Specs
    Nope it is a table in TvServer MySQL/MSSQL db
     
  5. kiwijunglist
    • Team MediaPortal

    kiwijunglist Super Moderator

    Joined:
    June 10, 2008
    Messages:
    6,746
    Likes Received:
    1,420
    Occupation:
    Doctor
    Location:
    New Zealand
    Ratings:
    +1,849 / 9
    Home Country:
    New Zealand New Zealand
    Show System Specs
    http://wiki.team-mediaportal.com/1_...ng_TV_Setup_-_.22Failed_to_Create_Database.22

    I'm guessing exsiting tv recordings database is corrupt.
     
    Last edited: April 7, 2013
  6. onetoomany

    onetoomany Portal Pro

    Joined:
    July 5, 2005
    Messages:
    122
    Likes Received:
    1
    Location:
    UK
    Ratings:
    +2 / 0
    I'll try dropping the database and deleting db backup files on the server and see what happens...
     
  7. onetoomany

    onetoomany Portal Pro

    Joined:
    July 5, 2005
    Messages:
    122
    Likes Received:
    1
    Location:
    UK
    Ratings:
    +2 / 0
    Its been a week since I've had a chance to watch tv and try this.

    I dropped the database on the server, and allowed the config program to recreate it. The issue still remains.
    I have installed the 1.3.0 client software onto a second (clean) client, and the recordings folder is still empty - this suggests that it is a server problem not a client problem.

    The only non standard things about my config are:
    1. Different folder for recorded TV
    2. Running the TV service under its own username
     
  8. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
  9. onetoomany

    onetoomany Portal Pro

    Joined:
    July 5, 2005
    Messages:
    122
    Likes Received:
    1
    Location:
    UK
    Ratings:
    +2 / 0
    Import has run successfully.
    The TV server has been happily running and recording TV under 1.3.0 for the past couple of weeks.
    I've been happily watching recorded TV from a 1.2.3 client (for both TV programmes recorded prior to my server upgrade and those post upgrade)
    No success from a 1.3.0 client though. Strangely, I can watch live TV on the 1.3.0 client, and buffer etc...
     
  10. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    Can you access post upgrade recordings on 1.3 client and do you have any tools to look at the database tables installed?
     
  11. onetoomany

    onetoomany Portal Pro

    Joined:
    July 5, 2005
    Messages:
    122
    Likes Received:
    1
    Location:
    UK
    Ratings:
    +2 / 0
    No access to any post upgrade recordings on the 1.3.0 client - but I can access them on the 1.2.3 client.
    I am on MS SQL, so can open up the workbench and run various queries / examine table structures.
     
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!