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

[DJBlu]

I have found a Database folder at" Team MediaPortal\MediaPortal\database".

This folder is full of SQL (.db3) databases (Pictures, Videos, Music, TV series...). However, there is not an specific TV database in there.
Is this the right place to delete the database? Am I climbing the wrong tree again?

cheers

pj

I'd leave them alone.

Before trying this stop the tvservice and close tv setup.

To delete the database click start -> Programs -> MySql -> MySql Commandline tool

The password is MediaPortal
It is case sensative

type the following

drop database mptvdb;

It will say something along the lines of 30 records affected.

 

[pjuegos]

Ok, thanks

db dropped. Sky UK Grabber grab works now, but Freesat's does not.

I have to go to work now. I will test things further before posting the logs tonight.

Cheers

 

[rich76]

Just had a chance to try out the new files and its all works fine for me and certainly alot quicker on 1st scan.
Noticed a slight bug tho with the epg, after the new update and deleting my old db and rescanning now every program in the tv guide has (-1.-1 -1) after every program name. I have tried deleting the db a couple of times and tried again but same results. I've tried with default skin and still the same so not a skin issue I don't think. Would you have any ideas what it could be?

Thanks for all your hard work and for all the updates on already a great plugin

Rich

 

[DJBlu]

Just had a chance to try out the new files and its all works fine for me and certainly alot quicker on 1st scan.
Noticed a slight bug tho with the epg, after the new update and deleting my old db and rescanning now every program in the tv guide has (-1.-1 -1) after every program name. I have tried deleting the db a couple of times and tried again but same results. I've tried with default skin and still the same so not a skin issue I don't think. Would you have any ideas what it could be?

Thanks for all your hard work and for all the updates on already a great plugin

Rich

Can you upload your log files.

 

[rich76]

Here is my log files from the bug above.

Rich

 

[onetoomany]

I've installed the latest files from the first page (the 1.2.07 of the TV server and 1.2.0.8 of the Sky dll); I have dropped the database and started afresh. The channel scan works great, but I cannot get any EPG - the error log starts to fill!

Running on SQL server.

Log files attached.

2011-06-15 15:57:34.617868 [SetupTv(1)]: Exception :Error: StatementErrorUnclassified
Gentle.Common.GentleException: delete from Program ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
--- End of inner exception stack trace ---

 

[DJBlu]

Here is my log files from the bug above.

Rich

Can you try 1.2.0.9

I have changed something which should solve the issue.

Can you delete your database and try again, thanks.

 

[psykix]

Here is my log files from the bug above.

Rich

Can you try 1.2.0.9

I have changed something which should solve the issue.

Can you delete your database and try again, thanks.

I'm using 1.2.0.8 and MSSQL and have no issues, it's working fine..

Dunno whether I need to change to 1.2.0.9?

I'm using MSSQL 2008 R2, dunno if that makes any difference..

 

[DJBlu]

Here is my log files from the bug above.

Rich

Can you try 1.2.0.9

I have changed something which should solve the issue.

Can you delete your database and try again, thanks.

I'm using 1.2.0.8 and MSSQL and have no issues, it's working fine..

Dunno whether I need to change to 1.2.0.9?

I'm using MSSQL 2008 R2, dunno if that makes any difference..

All I have changed is the EPG Update on the start. I had it to enter the values "-1" in the Series details columns, it now enters nothing.

 

[rich76]

DjBlu,

Just tried out 1.2.0.9 and that fixed the bug I mentioned so thanks for that
Haven't spotted any other bugs so all looking good for me

Thanks again for all your hard work and the quick fix

Rich