Reply to thread

Message

<blockquote data-quote="craigbeat" data-source="post: 841881" data-attributes="member: 50797">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 582012-02-07 19:51:25.984375 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: use MpTvDb2012-02-07 19:51:25.984375 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: alter table Card drop constraint DF_Card_stopgraph2012-02-07 19:51:25.984375 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE Card&nbsp;&nbsp; ADD CONSTRAINT DF_Card_stopgraph&nbsp;&nbsp; DEFAULT (1) FOR stopgraph2012-02-07 19:51:25.984375 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=592012-02-07 19:51:25.984375 [SetupTv(1)]: - database upgraded to schema version 592012-02-07 19:51:26.000000 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: use MpTvDb2012-02-07 19:51:26.000000 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Card SET stopgraph = 12012-02-07 19:51:26.000000 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=602012-02-07 19:51:26.000000 [SetupTv(1)]: - database upgraded to schema version 602012-02-07 19:51:26.000000 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: use MpTvDb2012-02-07 19:51:26.000000 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp;&nbsp; ADD seriesId varchar(200)2012-02-07 19:51:26.015625 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp;&nbsp; ADD seriesTermination TINYINT2012-02-07 19:51:26.015625 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE schedule&nbsp;&nbsp; ADD seriesId varchar(200)2012-02-07 19:51:26.015625 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=61 GO2012-02-07 19:51:26.015625 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-02-07 19:51:26.015625 [SetupTv(1)]:&nbsp;&nbsp; ********* Error reason: Incorrect syntax near 'GO'.2012-02-07 19:51:26.015625 [SetupTv(1)]:&nbsp;&nbsp; ********* 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_TBS2012-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 - SQLBrowser2012-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)]:&nbsp;&nbsp; Exec SQL: use MpTvDb2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp;&nbsp; ADD seriesId varchar(200)2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* 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)]:&nbsp;&nbsp; ********* Error code: 2705, Line: 1 *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp;&nbsp; ADD seriesTermination TINYINT2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* 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)]:&nbsp;&nbsp; ********* Error code: 2705, Line: 1 *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE schedule&nbsp;&nbsp; ADD seriesId varchar(200)2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* 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)]:&nbsp;&nbsp; ********* Error code: 2705, Line: 1 *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=61 GO2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-02-07 19:52:59.546875 [SetupTv(1)]:&nbsp;&nbsp; ********* Error reason: Incorrect syntax near 'GO'.2012-02-07 19:52:59.562500 [SetupTv(1)]:&nbsp;&nbsp; ********* Error code: 102, Line: 1 *********[/CODE]</blockquote>

[QUOTE="craigbeat, post: 841881, member: 50797"] 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 *********[/CODE] [/QUOTE]

Verification