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

JobScheduler Setup should work with MySQL 8

    XMLWordPrintable

    Details

    • Type: Feature
    • Status: Released (View Workflow)
    • Priority: 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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: