[Approved] - Fix MySQL Case Sensitive

Discussion in 'Archive' started by esdk, April 16, 2011.

  1. esdk

    esdk New Member

    Joined:
    April 16, 2011
    Messages:
    1
    Likes Received:
    1
    Ratings:
    +1 / 0
    Home Country:
    Denmark Denmark
    When upgrading from mysql database version 56->57 the case of the table name is with lower case but should be upper case:

    Reproduce:
    Compile and install the mediaportal on case sensitive mysql database (Default). In last part of installation the database is created and upgraded. - crash.



    Change file: ...\MediaPortal\TvEngine3\TVLibrary\SetupTv\57_upgrade_mysql_database.sql

    From:
    USE %TvLibrary%;
    ALTER TABLE channel DROP COLUMN name;
    ALTER TABLE channel DROP COLUMN freetoair;
    UPDATE Version SET versionNumber=57;

    To:
    USE %TvLibrary%;
    ALTER TABLE Channel DROP COLUMN name;
    ALTER TABLE Channel DROP COLUMN freetoair;
    UPDATE Version SET versionNumber=57;

    Rgds

    Søren Kristensen
    Denmark
     
    • Like Like x 1
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. chemelli
    • Team MediaPortal

    chemelli Retired Team Member

    Joined:
    September 28, 2006
    Messages:
    6,159
    Likes Received:
    1,126
    Gender:
    Male
    Occupation:
    Activation Manager - Cloud Services
    Location:
    Trento, Italy
    Ratings:
    +1,127 / 0
    Home Country:
    Italy Italy
    Change commited.

    :D a lot for your report.

    Simone
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!