[SOLVED] Error while setup neos 4.1


(Florian Feuerpfeil) #1

Hi I have a problem while testing Neos 4.1

Before I’ll update the running Installation of my neos from 3.3 to 4.1 I want to test it. But the first problem comes up current the setup. After Step 2 the setup wants to create the Database and runs into the first error.

Whats the Problem? The neos files are from today and I’m sure to have the newest packages.

The MySQL version is: 10.1.34
PHP version is: 7.2

See the error or image below.

Thanks for your help.

An exception oc> curred 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 /var/www/vhosts/mtv-leck.de/neos4.mtv-leck.de/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: 2018091912355068e770.txt
Exception Code 1355480641
Exception Type Neos\Flow\Core\Booting\Exception\SubProcessException
Log Reference 20180919103547ecdee6
Thrown in File Packages/Framework/Neos.Flow/Classes/Core/Booting/Scripts.php
Line 665


(Bastian Heist) #2

Hi Florian,
we require MySQL 10.2.x as a minimum in Neos 4.x due to the UTF8-multibyte compatibility. You will have to upgrade your MySQL in order to proceed.


(Florian Feuerpfeil) #3

Thanks for response. The Problem is solved :+1:


(Bastian Heist) #4

happy to hear it!