Custom Data Grabber including Sky UK Channel/EPG Grabber (5 Viewers)

[DJBlu]

Hi

I keep getting my TVserivce crashing, I think its related to the EPG grab(s) after the inital install. I get the below error in my event logs. I have googled for a solution and from what I can see its a corruption in the DB but I have dropped the DB countless times and even reinstalled mySql a few times! Any ideas?

The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe: Sort aborted

The specified image file did not contain a resource section

Can you upload all your log files.

 

[clarkey2r]

Attached!

 

[DJBlu]

Looks like a serious issue with mysql

MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Have you installed a firewall recently or anything that could be stopping communication with the database?

 

[clarkey2r]

Looks like a serious issue with mysql

MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Have you installed a firewall recently or anything that could be stopping communication with the database?

Nope, default firewall is turned off also!

I don't suppose you know what port the connection uses? I have a variety of services running on all sorts of ports...

 

[DJBlu]

The default port is normally 3306

 

[clarkey2r]

Got nothing on that...

 

[DJBlu]

Got nothing on that...

The only suggestion I have is try MS SQL Server.

 

[BillyTheFish]

Hi DJBlu,
Quick question... What are the best settings to use if (like me), you have a custom channel setup (so not using the Sky layout - I have a mixed freeview/freesat setup with combined channels), but you want the plugin to update any moved channels etc? I currently have the channel update option disabled because when I first set things up I could not get it to leave my custom layout alone, but I suspect that this was because the configuration changes I had made had not been saved due to a big (now fixed), in the plug-in. So I'd like to try this again (and given that channel 4hd has moved this is a good time to test it)...

Thanks

Andy

Hi Andy, did you work this out? How did the test go? I'm in a similar situation with Freeview and Freesat with both mapped together where possible.

 

[wollo]

Just thought I'd say thanks for this wonderfull plugin, my t.v server has been up for over a week now solid. Properly reliable, I've not had that in a long while. Thanks DJBlu

 

[metropolis]

Hi, I can see that MP 1.2.2 has just been released. How does this effect your excellent plugin (which I couldn't live without).
Can I just install 1.2.2 and still use the plugin, or not?

Kind regards.