Database has become corrupt. Any suggestion for a fix? (1 Viewer)

toricred

MP Donator
  • Premium Supporter
  • August 29, 2006
    151
    14
    Home Country
    United States of America United States of America
    I am having similar problems with a client. In addition there is significant stuttering. I am attaching log files that indicate to me that the database has become corrupt. Any suggestion for a fix?
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,760
    7,224
    Sydney
    Home Country
    Australia Australia
    Yes, your database is corrupt. You need to delete your database file from:

    Code:
    C:\ProgramData\Team MediaPortal\MediaPortal\database
     

    RoChess

    Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,434
    1,897
    If you are lucky a backup was created last time you ran a big upgrade, so look for an MP-TVSeries folder inside the database folder, as it might hold a backup you can restore back to (simply overwrite the "TVSeriesDatabase4.db3" file).
     

    Scythe42

    Retired Team Member
  • Premium Supporter
  • June 20, 2009
    2,065
    2,703
    52
    Berlin
    Home Country
    Germany Germany
    Or take a look at the DB itself. It might not be corrupted at all and just TV Series cannot handle some stuff.

    I had constant crashes in the past with the importer until I cleaned up the DV (shows were referenced multiple times...). But doing so requires some understanding of DBs and you have to be a quick learner to understand what TVSeries is storing where and for what reason.

    But probably the easiest solution for most people will be a full re-import on a clean DB.
     

    jpichie

    Portal Pro
    May 12, 2011
    102
    8
    Home Country
    Canada Canada
    I had some issues when I upgraded to 1.2.1 for some reason.
    I was still able to get into MP-TVSeries config, and I exported my "watched list"
    I then deleted my DB as mentioned above, and re imported all my shows.

    Went back into MP-TVSeries config, and imported my watched list.
    All was good after this.
     

    jpichie

    Portal Pro
    May 12, 2011
    102
    8
    Home Country
    Canada Canada
    Go to "mediaportal configuration"
    From there, go to plugins -> MPTVseries, Config.
    Under the "general" tab, there is a link to "export watched flags"
     

    Users who are viewing this thread

    Similar threads

    I have added a scheduled task to MariaDB to delete all entries with the same start and end date
    I have added a scheduled task to MariaDB to delete all entries with the same start and end date
    Hello, I'm encountering an issue after importing EPG data into the TV-Server/Database. The Problem: After importing an XMLTV...
    Replies
    7
    Views
    2K
    If you’re planning to submit a pull request, let’s go through the list of issues and their solutions. I or someone from the team will create a Jira ticket, and for each ticket, you’ll make the changes and submit a pull request. This will be transparent and straightforward.
    If you’re planning to submit a pull request, let’s go through the list of issues and their solutions. I or someone from the team...
    I'm very glad to see that mediaportal 1 is on github, where ordinary devs with github accounts can make contributions. Please can...
    Replies
    7
    Views
    1K
    GitHub - jesmannstl/zap2xml: Automate TV guides to XMLTV much faster rewrite pulls full 14 day lineup in seconds. If pulling multiple lineups GitHub - jesmannstl/tvmerge: An updated and faster tvmerge utility merges 2 or more xmltv files. Both written in node.js.
    GitHub - jesmannstl/zap2xml: Automate TV guides to XMLTV much faster rewrite pulls full 14 day lineup in seconds. If pulling...
    Today I reached the end of my guide data. Upon researching what went wrong, I learned zap2it.com is dead. So zap2xml.exe doesn't...
    Replies
    13
    Views
    9K
    I don't know about MP2 but as you said you tried MP1 too, how is the MP music config ? MP(1) will only use LAV if you select "Internal DirectShow player" as music output, but then you lose gapless playback. If you you don't have multichannel music you can choose WASAPI as the output and set the number of speakers to stereo. I have...
    I don't know about MP2 but as you said you tried MP1 too, how is the MP music config ? MP(1) will only use LAV if you select...
    Not sure if this a a bug/config/settings problem. I am running a media portal 2.5 server with 2.41 client but it seems I get the...
    Replies
    1
    Views
    658
    After many hours of troubleshooting I've given up and accepted that it's just "one of these things" when using madVR for watching live TV. I've now ticked the box to "Use EVR for LiveTV", with a default display refresh rate of 50Hz. In combination with tweaking some of the Nvidia 3D settings for the MP executable only, I now have a...
    After many hours of troubleshooting I've given up and accepted that it's just "one of these things" when using madVR for watching...
    Every so often, when I switch to a TV channel, my MP client stops accepting user inputs, either from the remote or keyboard/mouse...
    Replies
    30
    Views
    8K
    Top Bottom