Reply to thread

Message

Trying all afternoon to install MediaPortal 1.23 on a Windows 7 Pro x64 machine. The TV-Server Configuration exe stops with "Failed to upgrade the database" error.

I ran it with "/Configure-DB" and the TEST is successful, so I know I am talking to the Sql Server. Further, it creates the MpTvDb with 47 tables.

The SetUpTv.log file (in C:\ProgramData\Team MediaPortal\MediaPortal TV Server\log) ends with this:

[2019-10-20 20:19:17,294] [Log ] [SetupTv ] [INFO ] -   Exec SQL: CREATE INDEX IDX_Program_Notify ON Program(notify)
[2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] -   ********* SQL statement failed! *********
[2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] -   ********* Error reason: Cannot create an index on 'Program', because this table does not exist in database 'MpTvDb'.
[2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] -   ********* Error code: 1906, Line: 1 *********
[2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] -   Exec SQL: UPDATE Version SET versionNumber=45

There is no table called "Program" in the MpTvDb. I think "Program" may be a reserved word in Sql Server.

Help!

<blockquote data-quote="GilDavis" data-source="post: 1262796" data-attributes="member: 164425">Trying all afternoon to install MediaPortal 1.23 on a Windows 7 Pro x64 machine. The TV-Server Configuration exe stops with &quot;Failed to upgrade the database&quot; error.I ran it with &quot;/Configure-DB&quot; and the TEST is successful, so I know I am talking to the Sql Server. Further, it creates the MpTvDb with 47 tables.The SetUpTv.log file (in C:\ProgramData\Team MediaPortal\MediaPortal TV Server\log) ends with this:[2019-10-20 20:19:17,294] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [INFO ] -&nbsp;&nbsp; Exec SQL: CREATE INDEX IDX_Program_Notify ON Program(notify)[2019-10-20 20:19:17,304] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [INFO ] -&nbsp;&nbsp; ********* SQL statement failed! *********[2019-10-20 20:19:17,304] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [INFO ] -&nbsp;&nbsp; ********* Error reason: Cannot create an index on 'Program', because this table does not exist in database 'MpTvDb'.[2019-10-20 20:19:17,304] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [INFO ] -&nbsp;&nbsp; ********* Error code: 1906, Line: 1 *********[2019-10-20 20:19:17,304] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [INFO ] -&nbsp;&nbsp; Exec SQL: UPDATE Version SET versionNumber=45There is no table called &quot;Program&quot; in the MpTvDb. I think &quot;Program&quot; may be a reserved word in Sql Server.Help!</blockquote>

[QUOTE="GilDavis, post: 1262796, member: 164425"] Trying all afternoon to install MediaPortal 1.23 on a Windows 7 Pro x64 machine. The TV-Server Configuration exe stops with "Failed to upgrade the database" error. I ran it with "/Configure-DB" and the TEST is successful, so I know I am talking to the Sql Server. Further, it creates the MpTvDb with 47 tables. The SetUpTv.log file (in C:\ProgramData\Team MediaPortal\MediaPortal TV Server\log) ends with this: [2019-10-20 20:19:17,294] [Log ] [SetupTv ] [INFO ] - Exec SQL: CREATE INDEX IDX_Program_Notify ON Program(notify) [2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] - ********* SQL statement failed! ********* [2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] - ********* Error reason: Cannot create an index on 'Program', because this table does not exist in database 'MpTvDb'. [2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] - ********* Error code: 1906, Line: 1 ********* [2019-10-20 20:19:17,304] [Log ] [SetupTv ] [INFO ] - Exec SQL: UPDATE Version SET versionNumber=45 There is no table called "Program" in the MpTvDb. I think "Program" may be a reserved word in Sql Server. Help! [/QUOTE]