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

Cannot apply update script for EZEE-2880 on MySQL

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: High High
    • None
    • 3.0.0
    • Workflow

    Description

      Cannot apply update script for EZEE-2880 on MySQL.

      Prereq.: Installation with MySQL 5.7 db. STRICT_TRANS_TABLES mode enabled.

      Steps:

      1. Try to apply the script:
        -- EZEE-2880: Added support for stage and transition actions --
        ALTER TABLE `ezeditorialworkflow_markings`
            ADD COLUMN `message` TEXT NOT NULL default '',
            ADD COLUMN `reviewer_id` INT(11),
            ADD COLUMN `result` TEXT;
        --
        

      Actual result: Error occurs

      ERROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column 'message' can't have a default value
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            michal.szoltysek@ibexa.co Michał Szołtysek
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: