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

GilDavis

New Member
October 21, 2019
5
0
40
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,101
    1,304
    Southampton
    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
    12,512
    7,211
    Kyiv
    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
    40
    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
    OP Title Forum Replies Date
    framug [solved] Some changes/fix in MP1 configuration client and server Submit: code patches (MediaPortal/TV-Server/etc.) 14
    S TV-Server MP1 - Automatic search doesn't work Installation, configuration support 2
    Patrik-See Win 10 Benutzer bei verschiedenen Clients Betriebssysteme 4
    ajs [Proposal] Improving the MP1 Small Splash Screen, providing nicer Image :) MediaPortal 1 3
    ajs [News] MediaPortal 1.26 Pre-Release ready for testing! News and Announcements 0
    C Hauppauge HVR-1265 -- does it work with MP1? MediaPortal 1 Talk 1
    ajs MP2Web - MP1 compatibility MediaPortal 1 20
    T MadVR + LAV Filters, Perfect in MPC-BE, Bad in MP1 MediaPortal 1 Talk 13
    P MP2: US user, OTA - can NOT get SchedulesDirect plugin to work on MP1 or MP2 --> how do I get OTA schedule? General 5
    C Streaming/transcoding MP2 vs MP1? General 4
    ajs [fixed] 5015: Improving the MP1 installer, providing nicer GUI :) MediaPortal 1 138
    C Streaming to clients over Wifi. MP1 or MP2? Newcomers Forum 0
    S Shortcuts MP1 My Recorded & TV Guide General 10
    azzuro [WiP] MP1-4999 - Big changes with many related change at once by Sebastiii MediaPortal 1 22
    ajs [WiP] MP1 X64 Version MediaPortal 1 73
    joecrow How about a Launcher plugin for MP1? MediaPortal 1 6
    wizard123 [solved] MP1 Build help MediaPortal 1 21
    ajs [News] MediaPortal 1 - 1.24 Released! News and Announcements 3
    CyberSimian [fixed] MP1-4990 : Improve horizontal scrolling in the EPG MediaPortal 1 10
    azzuro [WiP] MP1-5019: Replace MySQL with MariaDB MediaPortal 1 40
    catalpa Umsteiger von MP1: Schwierigkeiten Allgemeines Support- und Diskussionsforum 17
    CyberSimian [solved] MP1-4976 Built-in skin variables for current date MediaPortal 1 8
    rbo [solved] Umsteiger MP1 zu MP2 Allgemeines Support- und Diskussionsforum 67
    azzuro [Info] MP2 TVE inside MP1 repo MediaPortal 2 12
    lisag Can I get MP1 to open in the Recorded TV screen? MediaPortal 1 Talk 2

    Similar threads

    Top Bottom