SET - Setups
  1. SET - Setups
  2. SET-152

JobScheduler Setup should work with MySQL 8

    Details

    • Type: Feature Feature
    • Status: Released (View Workflow)
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.12
    • Fix Version/s: 1.12.6
    • Labels:
      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.

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

            • Assignee:
              Oliver Haufe
              Reporter:
              Uwe Risse
              Approver:
              Uwe Risse
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: