Reply to thread

Message

<blockquote data-quote="chr0non" data-source="post: 944406" data-attributes="member: 115448">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.&nbsp;Just FYI - when installing the 1.3 beta patches over a clean install of 1.3 beta ( with MSSQL) I am getting a &quot;DB update failed&quot; error. Likewise when running setuptv afterwards.&nbsp;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.&nbsp;2012-12-16 18:29:34.011631 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp;&nbsp; ADD seriesId varchar(200)2012-12-16 18:29:34.013631 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-12-16 18:29:34.013631 [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-12-16 18:29:34.014631 [SetupTv(1)]:&nbsp;&nbsp; ********* Error code: 2705, Line: 1 *********2012-12-16 18:29:34.014631 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE program&nbsp;&nbsp; ADD seriesTermination TINYINT2012-12-16 18:29:34.014631 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-12-16 18:29:34.015631 [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-12-16 18:29:34.015631 [SetupTv(1)]:&nbsp;&nbsp; ********* Error code: 2705, Line: 1 *********2012-12-16 18:29:34.015631 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: ALTER TABLE schedule&nbsp;&nbsp; ADD seriesId varchar(200)2012-12-16 18:29:34.016631 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-12-16 18:29:34.017631 [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-12-16 18:29:34.017631 [SetupTv(1)]:&nbsp;&nbsp; ********* Error code: 2705, Line: 1 *********2012-12-16 18:29:34.017631 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=62 GO2012-12-16 18:29:34.018631 [SetupTv(1)]:&nbsp;&nbsp; ********* SQL statement failed! *********2012-12-16 18:29:34.018631 [SetupTv(1)]:&nbsp;&nbsp; ********* Error reason: Incorrect syntax near 'GO'.2012-12-16 18:29:34.018631 [SetupTv(1)]:&nbsp;&nbsp; ********* Error code: 102, Line: 1 *********</blockquote>

[QUOTE="chr0non, post: 944406, member: 115448"] 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 ********* [/QUOTE]

Verification