Unhandled Exception - The number of returned rows (1 Viewer)

[millamber]

The following error message occurs if I do either of the following. Details of the error message and the mediaportal logs have been attached.

1.) Start MediaPortal
2.) Open the configuration of TV-Series plugin, by right-clicking on the plugin and choosing configuration.

---------------------------------------------------------------------------------------------------------------------------------
MediaPortal - Home
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 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.) I have opened the mptvdb database in SQL server and deleted all records from the Recordings table, but the message still appears.

5.) 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.

MediaPortal Version: 1.1.0.0
MediaPortal Skin: Blue 3 Wide
Windows Version: XP Service Pack 3
CPU Type: Intel Core Duo 3.33 Ghz
HDD: Seagate 80GB
Memory: 3GB DDR 400
Motherboard: ASUS P5Q-EM
Video Card: Onboard
Video Card Driver:
Sound Card: Onboard
Sound Card AC3:
Sound Card Driver:
1. TV Card: Dual Digital PCI Solution
1. TV Card Type: DVB-T
1. TV Card Driver:
2. TV Card: Dual Digital PCI Solution
2. TV Card Type: DVB-T
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: ffdshow 3014
MPEG2 Audio Codec: ffdshow 3014
h.264 Video Codec: ffdshow 3014
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV: Panasonic Plasma Vierra
TV - HTPC Connection: HDMI --> Onkyo Amplifier --> Plasma TV

 

[Marvman]

Did you deleted your recordings within MP or via windows explorer?

Did you check the button remove invalid recordings in the tv configuration under recoding settings.

Maybe you DB is a lil bit coruppted.

go to you MySQL bin folder and type in a shell following line:

mysqlcheck mptvdb --auto-repair -e -u root -p

*user may be differ*

good luck

 

[millamber]

Unhandled Exception

Did you deleted your recordings within MP or via windows explorer?

Neither, I deleted them through SQL Server Manager

Did you check the button remove invalid recordings in the tv configuration under recoding settings.

Yes

Maybe you DB is a lil bit coruppted.

go to you MySQL bin folder and type in a shell following line:

mysqlcheck mptvdb --auto-repair -e -u root -p


I tried this but everything reported as OK
Problem still not resolved
Thanks anyway



Millamber

 

[millamber]

Updated Information

I have since installed a new plugin "Moving Pictures"

The error message also occurs when I open the configuration for this plugin.

Is there a table in the database that gets accessed by all of the following plugins?:

TV Server (On MediaPortal startup)
Radio (On MediaPortal startup)
MP-TV-Series (When entering configuration or on MediaPortal startup)
Moving Pictures (When entering configuration or on MediaPortal startup)

TIA

Millamber

 

[Marvman]

You could ask in the moving picture and TV Series threads which tables they use.

Following error occurs in on the server side:

2009-10-23 18:53:17.421875 [DVB EPG timer]: Exception ystem.Runtime.Remoting.RemotingException: Requested Service not found

Server stack trace:
at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at TvControl.IController.IsRecording(User& user)
at TvService.EpgCard.IsCardIdle(Int32 cardId)
at TvService.EpgCard.GrabEpgForChannel(Channel channel, IChannel tuning, Card card)
at TvService.EpgCard.GrabEpg()
at TvService.EpgGrabber.GrabEpgOnCard(EpgCard epgCard)
at TvService.EpgGrabber._epgTimer_Elapsed(Object sender, ElapsedEventArgs e)

Did you check you channels (maybe re-scan) and epg data (delete all epg data)?

 

[millamber]

Thanks Marvman

Thanks Marvman,

I will do as you suggested and see if I can issolate which table in the database is giving me problems.

I have tried re-scanning all channels and refreshing the EPG but to no avail.



Millamber

 

[lqpl]

Same problem her, I think it has to do with TV, since I changed cards in my TV server
at suddenly I got this error on my client PCs.

 

[lqpl]

Uninstalled everything from my TV server , Mediaportal TV server and MySQL,
rebooted , installed again, now it works without error.

I think my problem started when I added a another DVB-S card.

 

[lqpl]

Got the same error again, after deleteing all channels before scanning again both cards in my server.
This time the solution was TV server Configurations > Recordings settings > Database import and press Remove invalid entries.