Sky UK/IT/AUS enhancements (3 Viewers)

[Jay_UK]

Hi there,

Its slightly hard to tell what the issue is...but it is complaining about the database.

I would try the following (wont do any harm):

Load a command prompt/DOS box and type (update the path or password if required):

net stop tvservice
c:
cd \program files\mysql\mysql server 5.1\bin
mysqlcheck mptvdb --auto-repair -e -u root -p --password=MediaPortal
net start tvservice

J.

 

[Dave Reynolds]

Hi
ran this and the utility came back ok.

The same thing happened today at 3.47am

2012-10-28 03:47:17.986714 [(5)]: Tvservice stopped due to an unhandled app domain exception System.NullReferenceException: Object reference not set to an instance of an object.
  at MySql.Data.MySqlClient.MySqlCommand.TimeoutExpired(Object commandObject)
  at System.Threading._TimerCallback.TimerCallback_Context(Object state)
  at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
  at System.Threading._TimerCallback.PerformTimerCallback(Object state)
2012-10-28 03:47:17.986714 [WinController exit thread(7)]: WindowsController: ExitWindows performed, result: True

Does anyone have any idea what causes the above ?

thanks

dave

 

[Jay_UK]

Hi there,

Please put MePo into Debug mode...and run a proper Mediaportal debug/capture...and post the Zip file here (which includes your config files too)

J.

 

[yrehan]

Hi miroslav22,
Is there any plan to merge EXP_Sky_UK_IT_Enhancements branch to the master?

Thanks,

 

[TheBatfink]

Hi, I'm also having issues all of a sudden. I haven't really done anything or installed anything except for trying to get my card reader and software to restart after sleep (which is really grating on me now lol).

I'm getting the 'no free cards' error. If I fire up the tvserver config and try previewing channels or attempting timeshifting in the manual control section, I get 'allcardsbusy'. I have no idea why this has started. I have just downloaded DVBViewer and it scanned fine, and it plays channels ok so I don't know whats going on.

My EPG is also completely blank. My CAM does not appear to show anything requesting decoding so its not even trying to playback anything.

Logs attached.

Any help much appreciated

Edit: Ran the database check J posted (just for the sake of it) and got this:

Spoiler

 mptvdb.canceledschedule                            OK
mptvdb.card                                        OK
mptvdb.cardgroup                                  OK
mptvdb.cardgroupmap                                OK
mptvdb.channel
warning  : 3 clients are using or haven't closed the table properly
status  : OK
mptvdb.channelgroup                                OK
mptvdb.channellinkagemap                          OK
mptvdb.channelmap                                  OK
mptvdb.conflict                                    OK
mptvdb.diseqcmotor                                OK
mptvdb.favorite                                    OK
mptvdb.groupmap                                    OK
mptvdb.history                                    OK
mptvdb.keyword                                    OK
mptvdb.keywordmap                                  OK
mptvdb.pendingdeletion                            OK
mptvdb.personaltvguidemap                          OK
mptvdb.program
warning  : Table is marked as crashed
warning  : 3 clients are using or haven't closed the table properly
warning  : Found 520236 deleted space in delete link chain. Should be 520308
error    : Found more than the expected 5538 deleted rows in delete link chain
error    : record delete-link-chain corrupted
error    : Corrupt
mptvdb.radiochannelgroup                          OK
mptvdb.radiogroupmap                              OK
mptvdb.recording                                  OK
mptvdb.satellite                                  OK
mptvdb.schedule                                    OK
mptvdb.server                                      OK
mptvdb.setting
warning  : 6 clients are using or haven't closed the table properly
status  : OK
mptvdb.softwareencoder                            OK
mptvdb.timespan                                    OK
mptvdb.tuningdetail                                OK
mptvdb.tvmoviemapping                              OK
mptvdb.version                                    OK Repairing tables
mptvdb.program
warning  : Number of rows changed from 142570 to 142561
status  : OK C:\Program Files\MySQL\MySQL Server 5.1\bin>

Fired MP back up and its working?!

So I guess my question now is what had I done to make it break so I don't do it again? BTW Thanks J!.

 

[yrehan]

I'm getting the 'no free cards' error.

Hi,
If this happens on the channels with multiple tunning details, then keep only one tunning detail and delete the rest.

See this thread for the details: https://forum.team-mediaportal.com/threads/no-cards-available.109338/

BR,

 

[Dave Reynolds]

Hi,

I have read today that the EPG Background audio channel is no longer broadcasting, if this is the case will the epg updates stop ?

Topic here

(Scroll down to bottom)

If their any other channel to download from if this is the case ?

Dave.[DOUBLEPOST=1353409780][/DOUBLEPOST]To Confirm, checked logs:

2012-11-20 04:29:10.542460 [DVB EPG timer(23)]: Initializing grab for Sky UK
2012-11-20 04:29:10.550460 [DVB EPG timer(23)]: There are 1 known channels on the default transponder
2012-11-20 04:29:10.558460 [DVB EPG timer(23)]: Tuning to 'EPG Background Audio.' to grab EPG for Sky UK
2012-11-20 04:29:37.342992 [DVB EPG timer(23)]: Epg: card:2 could not tune to channel:NoPmtFound
2012-11-20 04:29:37.342992 [DVB EPG timer(23)]: Failed to start grabbing EPG for Sky UK on channel 'EPG Background Audio.'. Trying next
2012-11-20 04:29:37.343992 [DVB EPG timer(23)]: Failed to start grabbing EPG for Sky UK on any channel in transponder list
2012-11-20 04:29:37.356993 [DVB EPG timer(23)]: Grab for card:#5 transponder #1/1 channel: Channel 5
2012-11-20 04:29:37.357993 [DVB EPG timer(23)]: EpgCard: grab epg on card: #5 transponder: #0 ch:Channel 5

 

[Dave Reynolds]

*** UPDATE ****

Edited the EPG Background Audio channel and changed:

Service ID: 4189
PMT PID: 86

Which is the (IEPG) channel and it's working again.

Dave.

 

[TheBatfink]

Hi, what needs to change in the configuration then because if I look at the EPG section of tvserver config, it wants frequencies etc?

 

[Dave Reynolds]

Hi, what needs to change in the configuration then because if I look at the EPG section of tvserver config, it wants frequencies etc?

They all stay the same I just changed the above two settings on the "EPG Background Audio" channel in the radio channels group.