Database Tables in Moving Pictures (1 Viewer)

[millamber]

Can anyone tell me which tables in the MediaPortal database are accessed when opening the configuration interface of the Moving Pictures Plugin.

Whenever I open the configuration screen I get the following error message. I am having trouble working out which table or view might be having this problem of 0 rows.

---------------------------------------------------------------------------------------------------------------------------------
Unhandled exception has occured in your application. If you click continue, the application will ignore this error and attempt to Continue. If you click Quit, the application will close immediately.

The number of returned rows 0 did not match the expected count of 1.
If concurrency control is enabled this may indicate that the record was updated or deleted by another process.
---------------------------------------------------------------------------------------------------------------------------------

I also get the message when starting the MediaPortal Interface or accessing the configuration interface of the the MP TV Series plugin. I am wondering if there is a table or view that gets accessed in all three of these situations. It might help me to narrow down where the problem lies.

I have read some posts on similar issues in these forums and have attempted the following.

1.) I have disabled the TV, Radio and TV-Series Plugins in configuration. When I do this the error message disappears, but of course this renders the mediaportal next to useless.

2.) I have disabled only the TV and Radio plug-ins, but left the TV-Series plugin enabled. In this instance the message does not occur, but again not much good if I can't watch TV

3.) If I have either of the TV or Radio plugins enabled then the error message appears. It only disappears when both are disabled.

4.) When accessing the configuration screen of either the MP TV Series or Moving Pictures plugins I also have the error message occur.

5.) I have opened the mptvdb database in SQL server and deleted all records from the Recordings table, but the message still appears.

6.) I have deleted all records from the TVSeriesDatabase.db3, but the message still appears.

If any one has any ideas, it would be much appreciated.

 

[fforde]

Moving Pictures accesses only the Moving Pictures database and no other. If you post your logs I will take a peek but this sounds unrelated to Moving Pictures to me...

 

[millamber]

fforde - Reply

Thanks for your response.

Not at home at the moment so will post logs when I get home.

Just to clarify what I am doing in regards to the Moving Pictures, so you have a clear idea of what might be happening at the time of the error.

I close the MediaPortal GUI
I open MediaPortal Configuration
I click on Plugins
I then right-click on Moving Pictures and Choose configuration.
The configuration interface opens
A few seconds later is when I get the error message.

If I just open the MediaPortal configuration and don't go any further, no error message occurs.

It only occurs after I have accessed the configuration of either MP TV Series or Moving Pictures.



Millamber

 

[millamber]

Updated Log Files

Thanks fforde,

Thanks for your reply this at least has narrowed down my field of investigation.

I would prefer not to have to do a complete reinstall as I have spent a lot of time getting everything just the way I like it.

If I can locate the actual source of the error and fix it, this would be much preferable.

I have attached my log files.