On starting TV: Msg "Unknown Error" (1 Viewer)

pet.heyn

Portal Member
January 28, 2013
5
0
Home Country
Germany Germany
After months of successful use, suddenly MP TV stops working.

After start it looks ok. When clicking "TV" msg "Unknown Error" is shown.
No TV...:(

I've created the log and attached it!

Regards
Peter
 

JimCatMP

Documentation Group
  • Team MediaPortal
  • April 1, 2010
    652
    283
    Leeds
    Home Country
    United Kingdom United Kingdom
    Looks like Database problem - from log, one of several messages...........

    2013-01-28 10:09:27.525240 [TVService(6)]: TvControllerException: Error: StatementErrorUnclassified
    Gentle.Common.GentleException: Update Program set state=0 where state<>0; ---> MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired

    Check Forum for correct command to fix TV DB (I know it's there, I don't have time to search for it just at the moment though:-

    TTFN - JCMP.
     

    pet.heyn

    Portal Member
    January 28, 2013
    5
    0
    Home Country
    Germany Germany
    ...looks as if I got it?

    Found the CD to specify before sql-command.
    Then it worked - reported corrected errors.

    Started MP, "TV" - bad news: same problem as before.

    After some time I thought of TV Service!!! Stopped it.
    Again repaired SQL. Restarted service.

    At least TV was startable now!
    Before finally verifying I must restart PC - MP sometimes mocks around when moved between monitors (with differing solutions).

    Will try!

    Thanks
    Peter
     

    pet.heyn

    Portal Member
    January 28, 2013
    5
    0
    Home Country
    Germany Germany
    Thanks a lot: problem solved!

    After restart everything was fine!

    That is: after stopping TV-Service, fixing the TV DB (i.e. sql-db), and starting again the problem was gone!

    Thanks again!
     

    pet.heyn

    Portal Member
    January 28, 2013
    5
    0
    Home Country
    Germany Germany
    Just for info: the same happened again today.
    The reason, I think: a complete freeze of windows this morning. (No TV active that time, but tvservice is always running...)

    For all searching for the solution:
    open an administrative(!) command window
    net stop tvservice
    cd \program files\mysql\mysql server 5.1\bin
    mysqlcheck -u root -pMediaPortal --auto-repair --all-databases
    net start tvservice
    Then started MP: everything OK now!

    Thanks - and have fun!
     

    pet.heyn

    Portal Member
    January 28, 2013
    5
    0
    Home Country
    Germany Germany
    OK: this is the 3rd time...
    In between the time I know what's the error if MP says "Unknown Error" :-(

    But I also seem to know the reason for the problem: some hours before PC was hang up, again(!), on a problem of Virtual Box. And as TVServer is always running it can't close the data base as it should...
     

    Users who are viewing this thread

    Similar threads

    It's working after some hours search: the Auto3D plugin which I haven't used for years was corrupting the start of the TV live stream from server to MP. If anyone has a similar problem - disable all old plugins and then enable one after another :-)
    It's working after some hours search: the Auto3D plugin which I haven't used for years was corrupting the start of the TV live...
    After using MP for more than 10 years with regularly updates - this is the first time that after an update MP is not working...
    Replies
    3
    Views
    1K
    I have recently updated from MP 1.30 to 1.31 on a Win 11 PC slightly different to your software set up but given Win 10 is still supported I doubt there are many major differences regarding the ".NET Runtime Optimization Service". On my setup I am not seeing any significant CPU usuage MP takes around 3% and the TV Service is...
    I have recently updated from MP 1.30 to 1.31 on a Win 11 PC slightly different to your software set up but given Win 10 is still...
    Hi, I have a single seat setup with MP 1.31 on a Win10 machine. Since the last automated Windows update the TV-Service produces a...
    Replies
    7
    Views
    1K
    that is absolutely not my impression, I think I reboot my htpc max a couple of times a year, usually (wild guess) when directx derails (symptoms are: frozen image, or sound only at video playback) Mind you, it's MP client only, no tvservice, and mp shutdown before sleep (and ofcourse start again at wake) Edit: leaving MP running...
    that is absolutely not my impression, I think I reboot my htpc max a couple of times a year, usually (wild guess) when directx...
    Hello my media portal doesn't start anymore, it was working fine yesterday but impossible to start now. The last time I shutdown...
    Replies
    4
    Views
    1K
    I don't think it can be done that much easier. If you're not comfortable doing these kinds of things on your computer, you'd better leave it to a more eperienced person...
    I don't think it can be done that much easier. If you're not comfortable doing these kinds of things on your computer, you'd better...
    Hi I have been using MediaPortal 1.2.3.0 for years and it has been working well. However, today I receive the message "Connection...
    Replies
    15
    Views
    4K
    Yes correct that would have solved it. I guess I was more interested in finding out what I had done to cause the problem as the error message was of no help. By deleting everything I wouldn't have known so it was a learning curve for future reference. Fully understood I thought that might be the case. I also had some issues with...
    Yes correct that would have solved it. I guess I was more interested in finding out what I had done to cause the problem as the...
    I've just updated to Win 10 on a second drive and am installing MP 1.31. Having a bit of trouble with the install with the...
    Replies
    14
    Views
    2K
    Top Bottom