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

Jay_UK

Test Group
  • Team MediaPortal
  • October 6, 2009
    1,781
    283
    Derby
    Home Country
    United Kingdom United Kingdom
    Hi there,

    Shouldn't the "GO" be on a separate line/command?

    J.
     

    onetoomany

    Portal Pro
    July 5, 2005
    122
    2
    UK
    Thanks for merging in the TBS code.

    I'm struggling to install the new version. I get failed to upgrade the database. Using SQL Server.
    TBS 6984 (quad without cam)

    I get the following error:
    2012-02-06 22:47:22.099703 [SetupTv(1)]: Exec SQL: use MpTvDb
    2012-02-06 22:47:22.101657 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesId varchar(200)
    2012-02-06 22:47:22.478624 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesTermination TINYINT
    2012-02-06 22:47:22.528431 [SetupTv(1)]: Exec SQL: ALTER TABLE schedule ADD seriesId varchar(200)
    2012-02-06 22:47:22.612418 [SetupTv(1)]: Exec SQL: UPDATE Version SET versionNumber=61 GO
    2012-02-06 22:47:22.613395 [SetupTv(1)]: ********* SQL statement failed! *********
    2012-02-06 22:47:22.614372 [SetupTv(1)]: ********* Error reason: Incorrect syntax near 'GO'.

    I've manually updated the DB to version 61, so it now starts. However, I then get the following error in the error log:
    2012-02-06 23:07:50.765841 [(5)]: Exception :confused:ystem.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
    at System.ThrowHelper.ThrowKeyNotFoundException()
    at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
    at TvLibrary.Implementations.DVB.ConditionalAccess.SendPids(Int32 subChannel, DVBBaseChannel channel, List`1 pids)

    Stop the TV service, close the Setup TV.

    Delete the database,

    Start Setup TV.

    The key not found is a seperate issue that will not affect anything.

    I had dropped the database and done a full uninstall of 1.2.1, so this was clean.

    The key not found goes along with the config program crashing. This happens when I try to do a DJBlu scan for channels. I'll post logs when I get home tonight, but it occurs after its found the channels but before EPG.
     

    DJBlu

    Portal Pro
    August 14, 2007
    1,670
    813
    Llanelli
    Home Country
    United Kingdom United Kingdom
    Thanks for merging in the TBS code.

    I'm struggling to install the new version. I get failed to upgrade the database. Using SQL Server.
    TBS 6984 (quad without cam)

    I get the following error:
    2012-02-06 22:47:22.099703 [SetupTv(1)]: Exec SQL: use MpTvDb
    2012-02-06 22:47:22.101657 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesId varchar(200)
    2012-02-06 22:47:22.478624 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesTermination TINYINT
    2012-02-06 22:47:22.528431 [SetupTv(1)]: Exec SQL: ALTER TABLE schedule ADD seriesId varchar(200)
    2012-02-06 22:47:22.612418 [SetupTv(1)]: Exec SQL: UPDATE Version SET versionNumber=61 GO
    2012-02-06 22:47:22.613395 [SetupTv(1)]: ********* SQL statement failed! *********
    2012-02-06 22:47:22.614372 [SetupTv(1)]: ********* Error reason: Incorrect syntax near 'GO'.

    I've manually updated the DB to version 61, so it now starts. However, I then get the following error in the error log:
    2012-02-06 23:07:50.765841 [(5)]: Exception :confused:ystem.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
    at System.ThrowHelper.ThrowKeyNotFoundException()
    at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
    at TvLibrary.Implementations.DVB.ConditionalAccess.SendPids(Int32 subChannel, DVBBaseChannel channel, List`1 pids)

    Stop the TV service, close the Setup TV.

    Delete the database,

    Start Setup TV.

    The key not found is a seperate issue that will not affect anything.

    I had dropped the database and done a full uninstall of 1.2.1, so this was clean.

    The key not found goes along with the config program crashing. This happens when I try to do a DJBlu scan for channels. I'll post logs when I get home tonight, but it occurs after its found the channels but before EPG.

    Can you try this file.

    View attachment 98736

    Thanks

    P.S. You'll be please to know that TBS are releasing new drivers for the 6984 in 2 days so we can have faster tuning.
     

    psykix

    MP Donator
  • Premium Supporter
  • July 10, 2009
    785
    46
    Wirral
    Home Country
    United Kingdom United Kingdom
    I'm running the files that Icam2 posted earlier in the thread over a clean 1.2.2 install..

    I want to try the TBS patch (especially if it gives faster tune times) - can I just install over the top? I don't fancy having to set everything up again!

    Ta...
     

    DJBlu

    Portal Pro
    August 14, 2007
    1,670
    813
    Llanelli
    Home Country
    United Kingdom United Kingdom
    I'm running the files that Icam2 posted earlier in the thread over a clean 1.2.2 install..

    I want to try the TBS patch (especially if it gives faster tune times) - can I just install over the top? I don't fancy having to set everything up again!

    Ta...

    Install over the top shouldn't be an issue.
     

    psykix

    MP Donator
  • Premium Supporter
  • July 10, 2009
    785
    46
    Wirral
    Home Country
    United Kingdom United Kingdom
    One other question.. I have both a TBS6984 and a TBS6981 in my single seat.. The TBS6984 is almost always used as they are the 4 tuners with highest priority. Does the TBSCI.dll file serve both cards?
     

    DJBlu

    Portal Pro
    August 14, 2007
    1,670
    813
    Llanelli
    Home Country
    United Kingdom United Kingdom
    One other question.. I have both a TBS6984 and a TBS6981 in my single seat.. The TBS6984 is almost always used as they are the 4 tuners with highest priority. Does the TBSCI.dll file serve both cards?

    Yup.

    The channel change will be the same speed on the 6984 until the new drivers come out. The 6981 will be faster.

    Mine went down from 3500ms to 1010ms.
     

    psykix

    MP Donator
  • Premium Supporter
  • July 10, 2009
    785
    46
    Wirral
    Home Country
    United Kingdom United Kingdom
    Cool.. I'll install later then, and then just update the driver when it comes out - mine are a bit old now probably, as I didn't bother to update them when I did the clean install.

    Cheers!
     

    onetoomany

    Portal Pro
    July 5, 2005
    122
    2
    UK
    Can you try this file.

    View attachment 98736

    Thanks

    P.S. You'll be please to know that TBS are releasing new drivers for the 6984 in 2 days so we can have faster tuning.

    Log files attached - I still get the crash.
    If possible, it would be good to surpress the key errors, as I fear my error file will get big quite quickly.

    R
     

    Attachments

    • install_1.2.0.171_2012-02-07_19-46-46.zip
      32 KB

    craigbeat

    Portal Member
    May 15, 2007
    46
    5
    Stop the TV service, close the Setup TV.

    Delete the database,

    Start Setup TV.

    The key not found is a seperate issue that will not affect anything.

    I had dropped the database and done a full uninstall of 1.2.1, so this was clean.

    The key not found goes along with the config program crashing. This happens when I try to do a DJBlu scan for channels. I'll post logs when I get home tonight, but it occurs after its found the channels but before EPG.

    Can you try this file.

    View attachment 98736

    Thanks

    P.S. You'll be please to know that TBS are releasing new drivers for the 6984 in 2 days so we can have faster tuning.

    I get the same issue, even with the file you attached:
    Code:
    2012-02-07 19:51:25.984375 [SetupTv(1)]: - database upgraded to schema version 58
    2012-02-07 19:51:25.984375 [SetupTv(1)]:   Exec SQL: use MpTvDb
    2012-02-07 19:51:25.984375 [SetupTv(1)]:   Exec SQL: alter table Card drop constraint DF_Card_stopgraph
    2012-02-07 19:51:25.984375 [SetupTv(1)]:   Exec SQL: ALTER TABLE Card   ADD CONSTRAINT DF_Card_stopgraph   DEFAULT (1) FOR stopgraph
    2012-02-07 19:51:25.984375 [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=59
    2012-02-07 19:51:25.984375 [SetupTv(1)]: - database upgraded to schema version 59
    2012-02-07 19:51:26.000000 [SetupTv(1)]:   Exec SQL: use MpTvDb
    2012-02-07 19:51:26.000000 [SetupTv(1)]:   Exec SQL: UPDATE Card SET stopgraph = 1
    2012-02-07 19:51:26.000000 [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=60
    2012-02-07 19:51:26.000000 [SetupTv(1)]: - database upgraded to schema version 60
    2012-02-07 19:51:26.000000 [SetupTv(1)]:   Exec SQL: use MpTvDb
    2012-02-07 19:51:26.000000 [SetupTv(1)]:   Exec SQL: ALTER TABLE program   ADD seriesId varchar(200)
    2012-02-07 19:51:26.015625 [SetupTv(1)]:   Exec SQL: ALTER TABLE program   ADD seriesTermination TINYINT
    2012-02-07 19:51:26.015625 [SetupTv(1)]:   Exec SQL: ALTER TABLE schedule   ADD seriesId varchar(200)
    2012-02-07 19:51:26.015625 [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=61 GO
    2012-02-07 19:51:26.015625 [SetupTv(1)]:   ********* SQL statement failed! *********
    2012-02-07 19:51:26.015625 [SetupTv(1)]:   ********* Error reason: Incorrect syntax near 'GO'.
    2012-02-07 19:51:26.015625 [SetupTv(1)]:   ********* Error code: 102, Line: 1 *********
    2012-02-07 19:52:59.109375 [SetupTv(1)]: ---- SetupTv v1.2.0.171 is starting up on Windows XP ( Service Pack 3 ) [5.1.2600.196608]
    2012-02-07 19:52:59.125000 [SetupTv(1)]: Build: 1.2.0-171-g24884a7-Merge_SeriesLink_Custom_TBS
    2012-02-07 19:52:59.125000 [SetupTv(1)]: ---- check connection with database ----
    2012-02-07 19:52:59.390625 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - SQLBrowser
    2012-02-07 19:52:59.390625 [SetupTv(1)]: ---- check if database needs to be updated/created ----
    2012-02-07 19:52:59.531250 [SetupTv(1)]: ---- upgrade database schema ----
    2012-02-07 19:52:59.531250 [SetupTv(1)]:   Exec SQL: use MpTvDb
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   Exec SQL: ALTER TABLE program   ADD seriesId varchar(200)
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* SQL statement failed! *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'program' is specified more than once.
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error code: 2705, Line: 1 *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   Exec SQL: ALTER TABLE program   ADD seriesTermination TINYINT
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* SQL statement failed! *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error reason: Column names in each table must be unique. Column name 'seriesTermination' in table 'program' is specified more than once.
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error code: 2705, Line: 1 *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   Exec SQL: ALTER TABLE schedule   ADD seriesId varchar(200)
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* SQL statement failed! *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error reason: Column names in each table must be unique. Column name 'seriesId' in table 'schedule' is specified more than once.
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error code: 2705, Line: 1 *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=61 GO
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* SQL statement failed! *********
    2012-02-07 19:52:59.546875 [SetupTv(1)]:   ********* Error reason: Incorrect syntax near 'GO'.
    2012-02-07 19:52:59.562500 [SetupTv(1)]:   ********* Error code: 102, Line: 1 *********
     

    Users who are viewing this thread

    Top Bottom