[Resolved] Missing column in database (1 Viewer)

pontusson

MP Donator
  • Premium Supporter
  • April 4, 2011
    29
    16
    Hi

    Just did a fresh re-install on a PC to be used in a caravan during the summer and got a lot of errors when parsing my TV-series. Keeps whining about a missing column VideoFormat in table local_episides. Opened the database with sqlite3.exe and indeed this column isn't there. Anybody else who can test this so it's not only my PC who is haunted?

    Version 4.3.1.

    BR Anders
     

    Edalex

    Community Plugin Dev
  • Premium Supporter
  • January 3, 2008
    2,923
    1,233
    Saratov
    Russian Federation Russian Federation
    Country flag
    What about backuping db and dropping it to let MP-TVseries to recreate it from scratch again?
     

    pontusson

    MP Donator
  • Premium Supporter
  • April 4, 2011
    29
    16
    Nope doesn't help, no need for backup since it's a fresh install and it can't import any episodes to begin with due to the missing column. I copied a database from another PC, empty it and started an import successful. Lucky to have three other instances of MP but hopefully someone can fix the original problem if someone new to MP is trying.
     

    fredco

    Portal Pro
    November 13, 2010
    88
    15
    Netherlands Netherlands
    Country flag
    I got the same issue: fresh Win10 and MP install and no import of my TV-series. I have alot of other instances of MP that work fine, but this new combination of MP 1.19, Win10 and MP TV-Series generates just errors. Log included.
     

    Attachments

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,722
    7,107
    Sydney
    Australia Australia
    Country flag
    Perhaps there has been some SQLite changes in the latest MP 1.19 which affect the tvseries database handling. I will install and see if I can reproduce.
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,722
    7,107
    Sydney
    Australia Australia
    Country flag
    In the meantime, I suggest grab a copy of the older mediainfo.dll and replace it with the current one. I haven't had time to look into this yet, but have not forgotten.
     

    fredco

    Portal Pro
    November 13, 2010
    88
    15
    Netherlands Netherlands
    Country flag
    @ltfearme: I have reported this in other threads also, but I'll repeat it here to be sure. I am having MAJOR issues with both Moving Pictures Configuration and MP TV-series. It only happens in MediaPortal versions 1.17, 1.18, 1.19 and 1.20. The older 1.16 works as expected, like before. The problem with Moving Pictures Configuration is: it imports only 50-60 titles (out of 1.000+), then stops responding and needs to be closed. In MP TV-series no series get imported, just a lot of errors.
    I'm using Windows 7 SP1, but it also happens on Windows 10 with MP 1.17 through 1.20 and Moving Pictures 1.8.2 and MP TV-series 4.3.2.0.
     

    Users who are viewing this thread

    Similar threads
    OP Title Forum Replies Date
    T [Resolved] Strange apostrophe issue My TVSeries 8
    fischy667 [Resolved] No fanart for "Who is America?" My TVSeries 15
    D MSBuild V14 is missing on my dev machine General Development (no feature request here!) 6
    ge2301 Images missing im Forum Online Facilities 2
    catalpa MP2 - V2.3 Optimfrog.dll missing Allgemeines Support- und Diskussionsforum 10
    E [solved] TV-Server Configuration Missing TV-Server 9
    O Steps to achieve AV sync - please tell me I'm missing something General 0
    P Missing channels after rebuild (all on one MUX ?) General 2
    SpudR Missing Page Numbers Website/Forum/Wiki Feedback 11
    g0rsq UK Freesat not tunning BBC HD channels, and lots of other freesat channels missing. Newcomers Forum 4
    D [solved] TVServer Plugin must be missing something. General Development (no feature request here!) 1
    HTPCSourcer Missing series posters/banners MediaPortal 2 11
    thepahakurki Trakt error: Invalid or missing file Trakt 8
    T How to add missing buttons IR Server Suite (IRSS) 0
    T Missing sound in online streaming service (SVTPlay) General Support 3
    D Tuner Suddenly Missing Channels TV-Cards 0
    S Missing plugin for MP2 Plugin Development 1
    L [solved] MP2 doesnt play anything - player missing? General 1
    L Tv series install problem missing file My TVSeries 7
    L [solved] Missing gentle.config file General 6
    CyberSimian TV Server import is missing some settings MediaPortal 1 0
    T Media Portal 2 EPG data missing General 16
    zunixnuz Missing #iswatched property to recorded TV Titan Skin Feedback 5
    Ralph Holmes Missing TV channels after transmitter change (Tacolneston) General 6

    Similar threads

    Top Bottom