Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-152

JobScheduler Setup should work with MySQL 8

    XMLWordPrintable

Details

    • Feature
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.12
    • 1.12.6
    • None

    Description

      Current Situation

      When installing JobScheduler Master with MySQL 8 an error occurs when creating the database tables.

      The SQL script daily_plan.sql and jadehistory.sql fails with the message
      Error Code: 1071. Specified key was too long; max key length is 3072 bytes
      The reason is the length of the unique constraint fields that is bigger than 3072 bytes.

      Desired Behavior

      It should be possible to install JobScheduler Master with MySQL 8.

      Maintainer note

      The file jadehistory.sql will no longer be part of the db folder.

      Attachments

        Issue Links

          Activity

            People

              oh Oliver Haufe
              ur Uwe Risse
              Uwe Risse Uwe Risse
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: