1

While installing neos it throws this exception:

An exception occurred while executing 'CREATE TABLE flow3_resource_resourcepointer (hash VARCHAR(255) NOT NULL, PRIMARY KEY(hash)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB':
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

The exception details have been logged to the Flow system log.
Exception in line 184 of /Users/julius/Documents/dev/neos/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: An exception occurred while executing 'CREATE TABLE flow3_resource_resourcepointer (hash VARCHAR(255) NOT NULL, PRIMARY KEY(hash)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB':

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes - See also: 201805011913565a6e91.txt

Exception Code  1355480641
Exception Type  Neos\Flow\Core\Booting\Exception\SubProcessException
Log Reference   20180501191355663ebf
Thrown in File  Packages/Framework/Neos.Flow/Classes/Core/Booting/Scripts.php
Line    677
jalieb
  • 13
  • 5

1 Answers1

2

With Neos 4.0 the default charset and collation was changed to utf8mb4 which requires longer keys and therefore requires at least MySQL 5.7.x or MariaDB 10.2.x. I assume you try to install Neos 4.0 on an older database version.

dlienert
  • 228
  • 1
  • 4
  • You're right, I was using MySQL 5.6.x. Thx! http://neos.readthedocs.io/en/stable/GettingStarted/Installation.html – jalieb May 03 '18 at 08:24