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

[chr0non]

Hi DJBlu, I'm a recent convert to your plugin but don't know why it took so long - it's effin' brilliant, thank you.

Just FYI - when installing the 1.3 beta patches over a clean install of 1.3 beta ( with MSSQL) I am getting a "DB update failed" error. Likewise when running setuptv afterwards.

The relevant details from the log are below but since the columns all exist, a manual update of the version table as per the 4th sql statement gets past the problem for now.

2012-12-16 18:29:34.011631 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesId varchar(200)
2012-12-16 18:29:34.013631 [SetupTv(1)]: ********* SQL statement failed! *********
2012-12-16 18:29:34.013631 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'program' is specified more than once.
2012-12-16 18:29:34.014631 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2012-12-16 18:29:34.014631 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesTermination TINYINT
2012-12-16 18:29:34.014631 [SetupTv(1)]: ********* SQL statement failed! *********
2012-12-16 18:29:34.015631 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesTermination' in table 'program' is specified more than once.
2012-12-16 18:29:34.015631 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2012-12-16 18:29:34.015631 [SetupTv(1)]: Exec SQL: ALTER TABLE schedule ADD seriesId varchar(200)
2012-12-16 18:29:34.016631 [SetupTv(1)]: ********* SQL statement failed! *********
2012-12-16 18:29:34.017631 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'schedule' is specified more than once.
2012-12-16 18:29:34.017631 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2012-12-16 18:29:34.017631 [SetupTv(1)]: Exec SQL: UPDATE Version SET versionNumber=62 GO
2012-12-16 18:29:34.018631 [SetupTv(1)]: ********* SQL statement failed! *********
2012-12-16 18:29:34.018631 [SetupTv(1)]: ********* Error reason: Incorrect syntax near 'GO'.
2012-12-16 18:29:34.018631 [SetupTv(1)]: ********* Error code: 102, Line: 1 *********

 

[Jay_UK]

Hi there,

WAF is giving me grief to upgrade

Anyone using MS SQL having issues (cos I have)?

Did a 1.3b install...everything installed...performed a quick scan...worked fine

Tried to run the SVN installer, it reported it failed to upgrade the DB.

I will test/try again and upload logs later.

J.

 

[bob808]

I know it's a bit off topic but has anyone taken the win8 plunge and got this working? I tried win 8 a couple weeks back with a self compiled svn and had the frontend working well enough but the tv server seemed sluggish and unresponsive at times. Just debating stick with my clean win7 install or try 8 again...

Thanks for the great work again Dj Blu - I plan to install tonight if I get the chance so will come back with any feedback the

 

[sorrowuk]

I see this can now download channel logos. Running this on a dedicated server with just the MP TV Server is there a way to make the channel logos available to all the clients on seperate computers ?

 

[DJBlu]

I see this can now download channel logos. Running this on a dedicated server with just the MP TV Server is there a way to make the channel logos available to all the clients on seperate computers ?

You can set the logo location to any place you want. You would have to copy the files individually to all the clients.
If you share the logo directories on your network you could write a batch file to copy the files from the server to the clients.

I have looked into saving them in various locations but you need the clients to all be online for the updates.
The team are working on the TV Plugin and the logos to all clients is part of this.

 

[sorrowuk]

I see this can now download channel logos. Running this on a dedicated server with just the MP TV Server is there a way to make the channel logos available to all the clients on seperate computers ?

You can set the logo location to any place you want. You would have to copy the files individually to all the clients.
If you share the logo directories on your network you could write a batch file to copy the files from the server to the clients.

I have looked into saving them in various locations but you need the clients to all be online for the updates.
The team are working on the TV Plugin and the logos to all clients is part of this.

Would this work. Save the logos on the dedicated server in a folder.

Then on all the clients , the folder which stores the logos set it up as a symbolic link and point it to the smb network path (http://en.wikipedia.org/wiki/NTFS_symbolic_link) ?

Or could just copy then manually I guess .

 

[theidiot]

Hi there,

WAF is giving me grief to upgrade

Anyone using MS SQL having issues (cos I have)?

Did a 1.3b install...everything installed...performed a quick scan...worked fine

Tried to run the SVN installer, it reported it failed to upgrade the DB.

I will test/try again and upload logs later.

J.

Yup had to reinstall from scratch and revert to MYSQL. I also had some issues with the TV server crashing repeatedly but this went away once I'd disabled and then re-enabled the plugin. I'm having problems with Titans Extensions not working now. There is something about this further back in the thread which I'll look into when everyone isn't watching telly.

P.S. Thanks again DJBlu for this great plugin. I was going to try to do without it this build but I found I couldn't.

*Edit* I didn't realise the Titan Extensions were a separate download. Once I'd installed this the Extensions behaved as expected. I'm still getting a lot of TV Server crashes though. I'll investigate later after work, but so far I've noticed that opening TV Server Config, disabling the plugin, closing the config and then re-enabling the plugin seems to fix the problem.

 

[theidiot]

The team are working on the TV Plugin and the logos to all clients is part of this.

@DJBlu What's this? Is your plugin being rolled up into the main release?

 

[DJBlu]

The team are working on the TV Plugin and the logos to all clients is part of this.

@DJBlu What's this? Is your plugin being rolled up into the main release?

No. Just a feature that will be added. All logos will be distributed from the server to clients.

 

[psykix]

Hi there,

WAF is giving me grief to upgrade

Anyone using MS SQL having issues (cos I have)?

Did a 1.3b install...everything installed...performed a quick scan...worked fine

Tried to run the SVN installer, it reported it failed to upgrade the DB.

I will test/try again and upload logs later.

J.

I haven't tried yet - my PSU for the new build was DOA, so new stuff coming today.

I had this problem with the last couple of releases - @DJBlu had to fix each time, not sure what it is, but he fixed it pretty quickly!

I can't bear to use MYSQL, in my experience it is slow, and prone to corruption (my EPG database corrupted twice, and I had to delete database and reconfig)

So I'll wait for a fix!