MP1 TV Server "failed to upgrade the database" using MS Sql Server (1 Viewer)

GilDavis

New Member
October 21, 2019
5
0
41
Home Country
United States of America United States of America
Country flag
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!
 

CyberSimian

Test Group
  • Team MediaPortal
  • June 10, 2013
    2,310
    1,403
    Southampton
    Home Country
    United Kingdom United Kingdom
    Country flag
    Trying all afternoon to install MediaPortal 1.23 on a Windows 7 Pro x64 machine.
    I am currently running MP 1.22 on 32-bit Windows 7 Home Premium. As far as I can see, MP uses "MySQL", not "MS SQL". Are you really trying to use "MS SQL"?

    I don't know anything about SQL (I have never programmed it or had to set it up), but are different SQL engines interchangeable? I would speculate that they are like web browsers -- there is considerable commonality, but each SQL server supports its own non-standard extensions, and some standard features produce different results.

    If no one posts saying that "MS SQL" is usable, you might want to consider uninstalling "MS SQL", uninstalling MP, and then re-installing MP. The MP installer will install the version of "MySQL" that it needs if it is not already installed.

    -- from CyberSimian in the UK
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    13,757
    8,310
    Kyiv
    Home Country
    Ukraine Ukraine
    Country flag
    but are different SQL engines interchangeable
    Mostly yes. But here the problem is different:
    Error reason: Cannot create an index on 'Program', because this table does not exist in database 'MpTvDb'.
     

    GilDavis

    New Member
    October 21, 2019
    5
    0
    41
    Home Country
    United States of America United States of America
    Country flag
    I am currently running MP 1.22 on 32-bit Windows 7 Home Premium. As far as I can see, MP uses "MySQL", not "MS SQL". Are you really trying to use "MS SQL"?
    I am trying to use the Microsoft SQL Server 2000 that is installed on my Windows Server 2003.
     

    Users who are viewing this thread

    Similar threads

    Hallo, Since the update to MP1 27 pre, the refresh rate display no longer works correctly. The font is too small and illegible. The display can be reached with "Shift, 1". Andreas
    Hallo, Since the update to MP1 27 pre, the refresh rate display no longer works correctly. The font is too small and illegible. The...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Replies
    2
    Views
    825
    We have just released MediaPortal 1.27 Highlights of this release Bugfixes: [MP1-5050] - GUIHome should not be copied next to the mediaportal executable [MP1-5051] - Music Playback fails with ReplayGain enabled and no ReplayGain Information in song [MP1-5053] - TV framerate is not parsed from tsbuffer Since Pre-Release ...
    We have just released MediaPortal 1.27 Highlights of this release Bugfixes: [MP1-5050] - GUIHome should not be copied next to...
    We have just released MediaPortal 1.27 Highlights of this release Bugfixes: [MP1-5050] - GUIHome should not be copied next to...
    Replies
    0
    Views
    2K
    I think that this is a different exception to the others that have been reported. This is what happened: I woke the system from hibernation. From the Windows 7 desktop, I pressed the START button on the remote control to start MP 1.25f. On the MP splash screen, the "Starting TV Server" text appeared unexpectedly. After a long wait...
    I think that this is a different exception to the others that have been reported. This is what happened: I woke the system from...
    I think that this is a different exception to the others that have been reported. This is what happened: I woke the system from...
    Replies
    0
    Views
    560
    What is the status of the fix? I seem to be hitting this exact problem at channel 24 (in Seattle it is KUNS-DT).
    What is the status of the fix? I seem to be hitting this exact problem at channel 24 (in Seattle it is KUNS-DT).
    MediaPortal 2 Version: 2.2.2 Description I am setting up a new Windows 10 Pro system to replace my old Windows 7 WMC server to be...
    Replies
    33
    Views
    2K
    We are proud to present MediaPortal 2.3.1 MediaPortal 2.3.1 is a full-blown media center software that addresses the most common user requirements out of the box. Aside from its support for Live TV and Radio, it offers a complete media server for music, movies, and TV shows. Info is automatically downloaded from various sources to...
    We are proud to present MediaPortal 2.3.1 MediaPortal 2.3.1 is a full-blown media center software that addresses the most common...
    We are proud to present MediaPortal 2.3.1 MediaPortal 2.3.1 is a full-blown media center software that addresses the most common...
    Replies
    0
    Views
    770
    Top Bottom