Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2922

Table cm_co_announcements index on body fails for MySQL 8.x

    XMLWordPrintable

Details

    Description

      With debug set to 2, the output of ./Console/cake database includes this when run with MySQL 8.x:

      Query: ALTER TABLE cm_co_announcements ADD INDEX cm_co_announcements_i4 (`body`) failed. BLOB/TEXT column 'body' used in key specification without a key length
      		 
      Possibly failed to update database schema

      This command run by hand succeeds:

      ALTER TABLE cm_co_announcements ADD INDEX cm_co_announcements_i4 (`body`(64));

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CO-2917 DatabaseShell errors with MySQL 8.x

          • Blocker - Blocks development and/or testing work, production could not run.
          • Resolved

          Activity

            People

              ioannis.e.igoumenos@at.internet2.edu Ioannis Eythymios Igoumenos
              scott.koranda@at.internet2.edu Scott Koranda
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: