Tables Access by TV Series Plugin (1 Viewer)

[millamber]

Can anyone tell me which tables in the MediaPortal database are accessed when opening the configuration interface of the MP TV Series 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 moving pictures 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.

 

[marvenius]

I would seriously suggest you re-install MediaPortal. Delete your user files directories and reinstall MP, then verify everything is working and add your desired plugin one by one. Testing everytime if everything is working.
MediaPortal uses an xml file for its configuration, Tvseries (and Moving Pictures) use their own database, each independent of the other. Having problems with both MovPic and TVSeries... suggest that you have a problem with MediaPortal. TV and Radio are standard MediaPortal "plugins"/features. When you disable them and the problems is not there, it suggests a problem with MediaPortal, not with either TVSeries or MovPic.
As suggested in the Moving Pictures thread, any logfiles?

 

[millamber]

Log File Updates

Thanks Marvenius,

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.



Millamber

 

[marvenius]

Well, I had a look at your logfiles, There is no error.log and the tvserver_error.log is empty (0kb) Are these the logs from when you had the error?
If you do not wish to reinstall, create a backup of the database files and MediaPortal.xml file. Then, again, start without any 3rd party plugins (movPic and TV Series and others) and see if you can recreate the error.
Anything else (by having a quick look) in your log files appears to be OK.

 

[millamber]

Thanks

Thanks Marvenius,

Yes the log files were created after experiencing the error.

I did however, discover that the error is related specifically to MediaPortal and not TV Series or Moving Pictures as you suggested.

It was a matter of time, if I open the MediaPortal configuration and leave it long enough before trying to access the TVSeries or Moving Pictures plugins, the error eventually comes us, so whilst it seemed to me that activating these configurations was causing the problem it was actually activating the MediaPortal configuration that is generating the error.

So now at least I know not to focus on either of these plugins in trying to resolve this issue.

It is now clear that the error message occurs after starting the MediaPortal GUI or or the MediaPortal Configuration.

I always have a recent backup of all the databases, but not the xml file, so I will add this to my automated backup procedures.

I think the next step for me is going to be deleting all the channels in mediaportal and doing a rescan.

It is proving very difficult to find out what exactly is the cause of this error.

Thanks again for your help on this issue.



Millamber