· 10 years ago · Aug 28, 2016, 12:00 PM
1[ERROR] exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes' in /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
2Stack trace:
3#0 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
4#1 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
5#2 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
6#3 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
7#4 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array)
8#5 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array)
9#6 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
10#7 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
11#8 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/module-ui/Setup/InstallSchema.php(88): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
12#9 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Ui\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
13#10 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
14#11 [internal function]: Magento\Setup\Model\Installer->installSchema()
15#12 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
16#13 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
17#14 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
18#15 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
19#16 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
20#17 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
21#18 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
22#19 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
23#20 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
24#21 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
25#22 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
26#23 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
27#24 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/index.php(31): Zend\Mvc\Application->run()
28#25 {main}
29
30Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes, query was: CREATE TABLE IF NOT EXISTS `ui_bookmark` (
31`bookmark_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Bookmark identifier' ,
32`user_id` int UNSIGNED NOT NULL COMMENT 'User Id' ,
33`namespace` varchar(255) NOT NULL COMMENT 'Bookmark namespace' ,
34`identifier` varchar(255) NOT NULL COMMENT 'Bookmark Identifier' ,
35`current` smallint NOT NULL COMMENT 'Mark current bookmark per user and identifier' ,
36`title` varchar(255) NULL COMMENT 'Bookmark title' ,
37`config` longtext NULL COMMENT 'Bookmark config' ,
38`created_at` datetime NOT NULL COMMENT 'Bookmark created at' ,
39`updated_at` datetime NOT NULL COMMENT 'Bookmark updated at' ,
40PRIMARY KEY (`bookmark_id`),
41INDEX `UI_BOOKMARK_USER_ID_NAMESPACE_IDENTIFIER` (`user_id`, `namespace`, `identifier`),
42CONSTRAINT `UI_BOOKMARK_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
43) COMMENT='Bookmark' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci' in /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235
44Stack trace:
45#0 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
46#1 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
47#2 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
48#3 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array)
49#4 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array)
50#5 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
51#6 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
52#7 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/magento/module-ui/Setup/InstallSchema.php(88): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
53#8 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Ui\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
54#9 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
55#10 [internal function]: Magento\Setup\Model\Installer->installSchema()
56#11 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
57#12 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
58#13 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
59#14 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
60#15 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
61#16 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
62#17 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
63#18 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
64#19 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
65#20 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
66#21 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
67#22 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
68#23 /mnt/data/accounts/h/hladik1/data/www/arasperky.cz/setup/index.php(31): Zend\Mvc\Application->run()
69#24 {main}