Uploaded image for project: 'MediaPortal 1'
  1. MediaPortal 1
  2. MP1-4520

Fix potential SQL upgrade issues and improve the statement(s)

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.0
    • 1.8.0
    • TvServer
    • None

    Description

      <p>Some people are experiencing SQL issues while updating. SQL Update is triggered, even while they are already on MySQL v5.6. We suspect the statement to be causing the problems, since it throws an Error 1175 (safe-update mode attempt without a WHERE that uses a KEY column).</p>

      <p><span style="line-height: 1.4em;">Besides that the table name is written as &#39;Version&#39; (needs to be lowercase v), which could cause issues for databases that are Case Sensitive.</span></p>

      Attachments

        Activity

          People

            HomeY HomeY
            HomeY HomeY
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: