[Bug] MediaPortal 1.3 beta Failed to update database (1 Viewer)

findftp

MP Donator
  • Premium Supporter
  • September 20, 2011
    184
    35
    Nootdorp
    Home Country
    Netherlands Netherlands
    I have a clean windows 7 x64 with a completely uninstalled 1.2.3 version.
    Upgrading gave the same error, so I did a complete uninstall with no avail.
    Now I will try to uninstall mysql too.
     

    Attachments

    • Untitled.png
      Untitled.png
      174.9 KB

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    Me too.
    I can watch TV, but if i try to open the tvsetup i got this message
     
    Last edited:

    mm1352000

    Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    Hello

    Thank you for the reports and especially for the log files. (y)
    I've moved the thread to the MP 1.3 beta bug report section where it won't be missed.

    It looks like the issue is here:
    2012-12-15 05:42:39.193543 [SetupTv(1)]: ---- upgrade database schema ----
    2012-12-15 05:42:39.199544 [SetupTv(1)]: Exec SQL: USE MpTvDb;ALTER TABLE `Channel` ADD COLUMN `channelNumber` int(11) NOT NULL DEFAULT 10000;UPDATE Channel c set c.channelNumber = (SELECT t.channelNumber FROM TuningDetail t WHERE t.idChannel = c.idChannel ORDER BY t.idTuning limit 1);UPDATE Version SET versionNumber=61;
    2012-12-15 05:42:39.200544 [SetupTv(1)]: ********* SQL statement failed! *********
    2012-12-15 05:42:39.201544 [SetupTv(1)]: ********* Error reason: Duplicate column name 'channelNumber'
    2012-12-15 05:42:39.201544 [SetupTv(1)]: ********* Error code: 1060 *********

    Are you 100% sure you didn't attempt the update multiple times or install an unofficial version of the beta before it was released?

    mm
     

    mm1352000

    Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    @findftp
    Do you also use a MySQL database?
    Could you please also provide your log files so we can check if both of you are seeing the same problem.

    Thanks,
    mm
     

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    ...or install an unofficial version of the beta before it was released?

    No ;)
    But you can help me anyway?
     

    mm1352000

    Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    No ;)
    But you can help me anyway?
    We do not provide support for upgrading from custom/unofficial builds because the DB state can't be guaranteed. Please keep this in mind before trying such builds in the future. It is sometimes hard to wait for the release, but it saves problems like this. ;)

    You need to run the following SQL query to revert the state of your database:
    ALTER TABLE Channel DROP COLUMN ChannelNumber;

    You can either use MySQL Workbench (or MySQL GUI Tools) or command in DOS prompt like:
    mysql -u root -p -e "ALTER TABLE Channel DROP COLUMN ChannelNumber;" mptvdb

    After that the upgrade should succeed.

    Marking the thread as "no bug".
     
    Last edited:

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    Sorry again. It does not work for me.. (and i will never do this again :) )
    Is your mysql version the same?

    Bild1.png
     

    mm1352000

    Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    Ah, okay.
    You're in the MySQL command prompt. That is good. You can just enter:
    use MpTvDb;
    ALTER TABLE Channel DROP COLUMN ChannelNumber;

    No need for the "mysql -u ..." stuff

    mm
     

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    I tried bevor, but i got another error...
    Maybe Versions conflict?

    Bild1.png
     

    mm1352000

    Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    There are two commands. I think you got the first one wrong. It should be "use MpTvDb;". Note that the semi colon (;) is important. After you enter that command press enter. Then enter the second command and press enter.
     

    Users who are viewing this thread

    Similar threads

    Hi, you can try the new installer from this post if you like.
    Hi, you can try the new installer from this post if you like.
    Hello, I came from MediaPortal 1.30 and wanted to Update on 1.32 x64 Edition. I cleanly uninstalled 1.30 first and then installed...
    Replies
    7
    Views
    683
    Hi, First off: there are some issues with the latest Mediaportal (32bits vs 64bits), so that is one of the issues you're stumbling with. If you take the previous version (1.31) it should work as expected. For IPTV there is also a different option (with different pros and cons): Onlinevideos. I'm using that sometimes for my IPTV as...
    Hi, First off: there are some issues with the latest Mediaportal (32bits vs 64bits), so that is one of the issues you're stumbling...
    Hi I am trying to play a m3u file from my IPTV provider, but when I try to install the TV part of Media Portal v1.3.2 I get an...
    Replies
    1
    Views
    444
    • Sticky
    Looks Like .... Thanks Again!
    Looks Like .... Thanks Again!
    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
    28
    Views
    2K
    @Brownard another logs of failed installations. I'll take a look into the user management. Edit: I can confirm user management is completey broken with NET4 and NET6 :( Neither an existing profile can be selected nor a new one can be created.
    @Brownard another logs of failed installations. I'll take a look into the user management. Edit: I can confirm user management is...
    Description: Hi there. First of all, I appreciate all the effort in MediaPortal 2 release 2.5 - visible changes look great (eg...
    Replies
    1
    Views
    319
    • Sticky
    You are right, the one on the repository is correct, not sure how I ended up with a different version. See attached the incorrect version I ended up with.
    You are right, the one on the repository is correct, not sure how I ended up with a different version. See attached the incorrect...
    We have just released MediaPortal 1.32 Halloween Thanks to the great work of our new developer Pablik we are now able to present...
    Replies
    33
    Views
    4K
    Top Bottom