Table cm_co_announcements index on body fails for MySQL 8.x

XMLWordPrintable

      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));

            Assignee:
            Ioannis Eythymios Igoumenos
            Reporter:
            Scott Koranda
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: