Reply to thread

Message

<blockquote data-quote="psykix" data-source="post: 781422" data-attributes="member: 96309">I did...I completely removed Mediaportal - also ensured that the database was deleted (which MePo did during the uninstall).Even deleted all the remaining folders..I then installed RC and then installed your files. All was fine until the database upgrade.From the log file :-2011-08-29 15:06:02.915960 [SetupTv(1)]: ---- started in Deploy mode ----2011-08-29 15:06:02.915960 [SetupTv(1)]: ---- SetupTv v1.1.8.28160 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]2011-08-29 15:06:02.931560 [SetupTv(1)]: ---- check connection with database ----2011-08-29 15:06:03.025160 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - SQLBrowser2011-08-29 15:06:03.025160 [SetupTv(1)]: ---- SetupDatabaseForm: server = SERVER, local = True2011-08-29 15:06:03.025160 [SetupTv(1)]: ---- check if database needs to be updated/created ----2011-08-29 15:06:03.025160 [SetupTv(1)]: ---- upgrade database schema ----2011-08-29 15:06:03.025160 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: use MpTvDb2011-08-29 15:06:03.025160 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp; ADD seriesId varchar(200)2011-08-29 15:06:03.040760 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp; ADD seriesTermination TINYINT2011-08-29 15:06:03.040760 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE schedule&nbsp; ADD seriesId varchar(200)2011-08-29 15:06:03.040760 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=60 GO2011-08-29 15:06:03.040760 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2011-08-29 15:06:03.040760 [SetupTv(1)]:&nbsp;&nbsp; ********* Error reason: Incorrect syntax near 'GO'.2011-08-29 15:06:03.040760 [SetupTv(1)]:&nbsp;&nbsp; ********* Error code: 102, Line: 1 *********</blockquote>

[QUOTE="psykix, post: 781422, member: 96309"] I did... I completely removed Mediaportal - also ensured that the database was deleted (which MePo did during the uninstall). Even deleted all the remaining folders.. I then installed RC and then installed your files. All was fine until the database upgrade. From the log file :- 2011-08-29 15:06:02.915960 [SetupTv(1)]: ---- started in Deploy mode ---- 2011-08-29 15:06:02.915960 [SetupTv(1)]: ---- SetupTv v1.1.8.28160 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536] 2011-08-29 15:06:02.931560 [SetupTv(1)]: ---- check connection with database ---- 2011-08-29 15:06:03.025160 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - SQLBrowser 2011-08-29 15:06:03.025160 [SetupTv(1)]: ---- SetupDatabaseForm: server = SERVER, local = True 2011-08-29 15:06:03.025160 [SetupTv(1)]: ---- check if database needs to be updated/created ---- 2011-08-29 15:06:03.025160 [SetupTv(1)]: ---- upgrade database schema ---- 2011-08-29 15:06:03.025160 [SetupTv(1)]: Exec SQL: use MpTvDb 2011-08-29 15:06:03.025160 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesId varchar(200) 2011-08-29 15:06:03.040760 [SetupTv(1)]: Exec SQL: ALTER TABLE program ADD seriesTermination TINYINT 2011-08-29 15:06:03.040760 [SetupTv(1)]: Exec SQL: ALTER TABLE schedule ADD seriesId varchar(200) 2011-08-29 15:06:03.040760 [SetupTv(1)]: Exec SQL: UPDATE Version SET versionNumber=60 GO 2011-08-29 15:06:03.040760 [SetupTv(1)]: ********* SQL statement failed! ********* 2011-08-29 15:06:03.040760 [SetupTv(1)]: ********* Error reason: Incorrect syntax near 'GO'. 2011-08-29 15:06:03.040760 [SetupTv(1)]: ********* Error code: 102, Line: 1 ********* [/QUOTE]

Verification