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
    1,995
    1,234
    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
    11,829
    6,681
    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 (Users: 0, Guests: 1)

    OP Similar threads 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
    Lehmden MariaDB with MP1 TV Server? Installation, configuration support 30
    ajs MP2Web - MP1 compatibility MediaPortal 1 20
    T MadVR + LAV Filters, Perfect in MPC-BE, Bad in MP1 MediaPortal 1 Talk 12
    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 1
    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 12
    ajs [Help Us!] MP1 X64 Version MediaPortal 1 20
    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
    M MP1 stops responding after Starting Plugins General Support 14
    R Problem with MP1 and WifiRemote Skins and Plugins Installer (MPEI) 8
    Similar threads

























    Top Bottom