Uploaded image for project: 'eZ Platform Enterprise Edition'
  1. eZ Platform Enterprise Edition
  2. EZEE-3214

Mysql error while upgrading eZ Platform 2.5 to 3.0

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • Customer request, 3.0.6, 3.1.1
    • 3.0.0, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.0.5
    • Upgrade

    • MySQL: 5.7

    Description

      Description
      When upgrading from 2.5 to 3.0, an error occurs with MySQL 5.7 regarding the default value for the message field

      Steps to reproduce
      1. Install fresh version eZ Platform 2.5
      2. Upgrade platform to 3.0

      Actual
      MySQL reports an error:

      ALTER TABLE `ezeditorialworkflow_markings` ADD COLUMN `message` TEXT NOT NULL default '', ADD COLUMN `reviewer_id` INT(11), ADD COLUMN `result` TEXT
      Error Code: 1101. BLOB, TEXT, GEOMETRY or JSON column 'message' can't have a default value

      Except
      Correct platform update

      Attachments

        Activity

          People

            Unassigned Unassigned
            mateusz.debinski@ibexa.co Mateusz Dębiński
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: