Bug #58894
MySQL max key length exceeded during Neos setup
Status: | New | Start date: | 2014-05-17 | |
---|---|---|---|---|
Priority: | Must have | Due date: | ||
Assigned To: | - | % Done: | 0% |
|
Category: | - Error Handler Report - | |||
Target version: | TYPO3 Flow Base Distribution - 2.x | |||
PHP Version: | 5.3 | Complexity: | ||
Has patch: | No | Affected Flow version: | Flow 2.0.0 |
Description
I tried to install Typo3 Neos 1.1 Beta 2 including Flow 2.2 and recieved the exception listed below during setup process.
Database version is 5.5.31-1~dotdeb.0-log (MyISAM engine), PHP version is 5.3.28.
I also tried Typo3 Neos 1.0.2 with same result. Database is UTF-8 as required by Neos.
It seems that the primary key is too long for MySQL running on MyISAM engine and UTF-8 encoding. 3 columns x 255 chars x UTF-8 encoding (3 bytes) > 1000 bytes allowed by MySQL with MyISAM engine. Please provide a fix that works under MyISAM with UTF-8.
TYPO3\Flow\Core\Booting\Exception\SubProcessException thrown in file Scripts.php
Uncaught Exception
An exception occurred while executing 'CREATE TABLE
typo3_flow3_mvc_web_routing_objectpathmapping (objecttype VARCHAR
NOT NULL, uripattern VARCHAR NOT NULL, pathsegment VARCHAR NOT
NULL, identifier VARCHAR DEFAULT NULL, PRIMARY KEY(objecttype,
uripattern, pathsegment)) ENGINE = InnoDB':
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was
too long; max key length is 1000 bytes
More Information
Exception code #0
File <path>/Neos-1.1.0-beta2/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 47
31 TYPO3\Flow\Core\Booting\Scripts::executeCommand("typo3.flow:doctrine:migrate", array|16|, FALSE)
30 TYPO3\Setup\Step\DatabaseStep_Original::postProcessFormValues(array|8|)
29 TYPO3\Setup\Controller\SetupController_Original::postProcessStep(array|8|, TYPO3\Setup\Step\DatabaseStep)
28 TYPO3\Setup\Controller\{closure}(TYPO3\Form\Core\Model\FinisherContext)
27 TYPO3\Form\Finishers\ClosureFinisher_Original::executeInternal()
26 TYPO3\Form\Core\Model\AbstractFinisher::execute(TYPO3\Form\Core\Model\FinisherContext)
25 TYPO3\Form\Core\Runtime\FormRuntime_Original::invokeFinishers()
24 TYPO3\Form\Core\Runtime\FormRuntime_Original::render()
23 TYPO3\Setup\Controller\SetupController_Original::indexAction(0)
22 TYPO3\Setup\Controller\SetupController::indexAction(0)
21 call_user_func_array(array|2|, array|1|)
20 TYPO3\Setup\Controller\SetupController::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
19 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
18 TYPO3\Flow\Security\Aspect\PolicyEnforcementAspect_Original::enforcePolicy(TYPO3\Flow\Aop\JoinPoint)
17 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
16 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
15 TYPO3\Setup\Controller\SetupController::indexAction(0)
14 call_user_func_array(array|2|, array|1|)
13 TYPO3\Flow\Mvc\Controller\ActionController_Original::callActionMethod()
12 TYPO3\Flow\Mvc\Controller\ActionController_Original::processRequest(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
11 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
10 TYPO3\Flow\Mvc\Dispatcher::dispatch(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
9 call_user_func_array(array|2|, array|2|)
8 TYPO3\Flow\Mvc\Dispatcher::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Security\Aspect\RequestDispatchingAspect_Original::blockIllegalRequestsAndForwardToAuthenticationEntryPoints(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
3 TYPO3\Flow\Mvc\Dispatcher::dispatch(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
2 TYPO3\Setup\Core\RequestHandler::handleRequest()
1 TYPO3\Flow\Core\Bootstrap::run()