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

[clarkey2r]

I'm still getting 'Failed to upgrade DB' after I've installed the 1.2.200.459 SVN

2013-01-10 11:57:39.307597 [TVService(6)]: TV service: Started
2013-01-10 11:57:46.581013 [SetupTv(1)]: ---- SetupTv v1.2.200.459 is starting up on Windows 2008 R2 ( Service Pack 1 ) [6.1.7601.65536]
2013-01-10 11:57:46.584013 [SetupTv(1)]: *******************************************
2013-01-10 11:57:46.584013 [SetupTv(1)]: * WARNING, OS not officially supported *
2013-01-10 11:57:46.585013 [SetupTv(1)]: *******************************************
2013-01-10 11:57:48.153103 [SetupTv(1)]: ---- check connection with database ----
2013-01-10 11:57:48.388116 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - SQLBrowser
2013-01-10 11:57:48.390116 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2013-01-10 11:57:48.416118 [SetupTv(1)]: ---- upgrade database schema ----
2013-01-10 11:57:48.427119 [SetupTv(1)]: Exec SQL: use MpTvDb
2013-01-10 11:57:48.428119 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesId varchar(200)
2013-01-10 11:57:48.431119 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-10 11:57:48.431119 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'program' is specified more than once.
2013-01-10 11:57:48.432119 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2013-01-10 11:57:48.432119 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesTermination TINYINT
2013-01-10 11:57:48.434119 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-10 11:57:48.435119 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesTermination' in table 'program' is specified more than once.
2013-01-10 11:57:48.435119 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2013-01-10 11:57:48.436119 [SetupTv(1)]: Exec SQL: ALTER TABLE schedule ADD seriesId varchar(200)
2013-01-10 11:57:48.437119 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-10 11:57:48.438119 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'schedule' is specified more than once.
2013-01-10 11:57:48.439119 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2013-01-10 11:57:48.439119 [SetupTv(1)]: Exec SQL: UPDATE Version SET versionNumber=61
2013-01-10 12:01:23.831439 [SetupTv(1)]: ---- SetupTv v1.2.200.459 is starting up on Windows 2008 R2 ( Service Pack 1 ) [6.1.7601.65536]
2013-01-10 12:01:23.835439 [SetupTv(1)]: *******************************************
2013-01-10 12:01:23.835439 [SetupTv(1)]: * WARNING, OS not officially supported *
2013-01-10 12:01:23.836439 [SetupTv(1)]: *******************************************
2013-01-10 12:01:25.038508 [SetupTv(1)]: ---- check connection with database ----
2013-01-10 12:01:25.349526 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - SQLBrowser
2013-01-10 12:01:25.351526 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2013-01-10 12:01:25.366527 [SetupTv(1)]: ---- upgrade database schema ----
2013-01-10 12:01:25.385528 [SetupTv(1)]: Exec SQL: use MpTvDb
2013-01-10 12:01:25.387528 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesId varchar(200)
2013-01-10 12:01:25.391528 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-10 12:01:25.392528 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'program' is specified more than once.
2013-01-10 12:01:25.394528 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2013-01-10 12:01:25.395528 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesTermination TINYINT
2013-01-10 12:01:25.402529 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-10 12:01:25.403529 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesTermination' in table 'program' is specified more than once.
2013-01-10 12:01:25.404529 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2013-01-10 12:01:25.405529 [SetupTv(1)]: Exec SQL: ALTER TABLE schedule ADD seriesId varchar(200)
2013-01-10 12:01:25.411529 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-10 12:01:25.413529 [SetupTv(1)]: ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'schedule' is specified more than once.
2013-01-10 12:01:25.415530 [SetupTv(1)]: ********* Error code: 2705, Line: 1 *********
2013-01-10 12:01:25.416530 [SetupTv(1)]: Exec SQL: UPDATE Version SET versionNumber=61

Any ideas?

Edit : I tried the below (from here) in SQL Management studio to no avail.

UPDATE Channel
SET channelNumber = (SELECT TOP 1 t.channelNumber ORDER BY t.idTuning)
FROM TuningDetail as t INNER JOIN Channel as c
ON t.idChannel = c.idChannel

 

[clarkey2r]

I manually deleted the offending columns in thier respective tables and TV server config opens once, if I close it and re-open I get the same error...

 

[onelegend]

Did you install over the top of 1.2.3 or alpha? Or was this a clean install of the files on the front page

 

[yrehan]

DJBlu's 1.2.2 has code that tells the new TBS drivers whether the channel is DVBS or DVBS2 so that it doesn't waste time checking the wrong signal.

Hi DJBlu / Onelegend /All,
Is the source code for these changes available somewhere? Patch or github branch?

BR,
yrehan

 

[clarkey2r]

Clean install

 

[onelegend]

Tbs branch is obsolete, there is a new branch called exp tuner hardware.

It's experimental and depends on your tuner and I believe it to be unstable

If you just require the faster change code I believe it works with no stability issues here (eg tbs 6984 and tbs 6981)

What tbs tuner do you have?

 

[clarkey2r]

A tbs6981

What about channel sort and epg?

 

[yrehan]

Tbs branch is obsolete, there is a new branch called exp tuner hardware.

It's experimental and depends on your tuner and I believe it to be unstable

If you just require the faster change code I believe it works with no stability issues here (eg tbs 6984 and tbs 6981)

Yes faster change code is all what I am looking for. Any pointer to it?

What tbs tuner do you have?

TBS8922

 

[JoeF]

is there a new issue with this as im missing a load of channels ranging from bbc1 to sky hd

 

[DJBlu]

is there a new issue with this as im missing a load of channels ranging from bbc1 to sky hd

M