Hallo zusammen,
hat jemand von euch so ein Problem beim frischem Install von Magento 2.1.3 gehabt?
Starting Magento installation: File permissions check... Enabling Maintenance Mode... Installing deployment configuration... Installing database schema: Schema creation/updates: Module 'Magento_Store': Installing schema.. Module 'Magento_AdvancedPricingImportExport': Module 'Magento_Directory': Installing schema.. Module 'Magento_Theme': Installing schema.. Module 'Magento_Backend': Module 'Magento_Backup': Module 'Magento_Eav': Installing schema.. Module 'Magento_Customer': Installing schema.. Upgrading schema.. Module 'Magento_BundleImportExport': Module 'Magento_CacheInvalidate': Module 'Magento_AdminNotification': Installing schema.. Module 'Magento_Indexer': Installing schema.. Module 'Magento_CatalogImportExport': Module 'Magento_Cms': Installing schema.. Upgrading schema.. Module 'Magento_Rule': Module 'Magento_Catalog': Installing schema.. Upgrading schema.. Module 'Magento_Search': Installing schema.. Upgrading schema.. Module 'Magento_CatalogUrlRewrite': Installing schema.. Module 'Magento_Widget': Installing schema.. Module 'Magento_Quote': Installing schema.. Upgrading schema.. Module 'Magento_CheckoutAgreements': Installing schema.. Upgrading schema.. Module 'Magento_SalesSequence': Installing schema.. Module 'Magento_CmsUrlRewrite': Module 'Magento_Config': Installing schema.. Module 'Magento_ConfigurableImportExport': Module 'Magento_Msrp': Module 'Magento_Contact': Module 'Magento_Cookie': Module 'Magento_Cron': Installing schema.. Module 'Magento_CurrencySymbol': Module 'Magento_Bundle': Installing schema.. Upgrading schema.. Module 'Magento_CustomerImportExport': Module 'Magento_Deploy': Module 'Magento_Developer': Module 'Magento_Dhl': Module 'Magento_Authorization': Installing schema.. Module 'Magento_Downloadable': Installing schema.. Module 'Magento_ImportExport': Installing schema.. Upgrading schema.. Module 'Magento_Payment': Module 'Magento_Email': Installing schema.. Module 'Magento_User': Installing schema.. Upgrading schema.. Module 'Magento_Fedex': Module 'Magento_Sales': Installing schema.. Upgrading schema.. Module 'Magento_CatalogInventory': Installing schema.. Module 'Magento_GoogleAnalytics': Module 'Magento_GoogleOptimizer': Installing schema.. Module 'Magento_GroupedImportExport': Module 'Magento_GroupedProduct': Module 'Magento_DownloadableImportExport': Module 'Magento_Checkout': Module 'Magento_Integration': Installing schema.. Upgrading schema.. Module 'Magento_LayeredNavigation': Module 'Magento_Marketplace': Module 'Magento_MediaStorage': Module 'Magento_CatalogRule': Installing schema.. Upgrading schema.. Module 'Magento_Multishipping': Module 'Magento_ConfigurableProduct': Installing schema.. Module 'Magento_Newsletter': Installing schema.. Module 'Magento_OfflinePayments': Module 'Magento_SalesRule': Installing schema.. Upgrading schema.. Module 'Magento_PageCache': Module 'Magento_Captcha': Installing schema.. Module 'Magento_Paypal': Installing schema.. Module 'Magento_Persistent': Installing schema.. Module 'Magento_ProductAlert': Installing schema.. Module 'Magento_ProductVideo': Installing schema.. Module 'Magento_Authorizenet': Module 'Magento_Reports': Installing schema.. Module 'Magento_RequireJs': Module 'Magento_Review': Installing schema.. Module 'Magento_Rss': Module 'Magento_Braintree': Module 'Magento_OfflineShipping': Installing schema.. Module 'Magento_GoogleAdwords': Module 'Magento_SampleData': Module 'Magento_CatalogSearch': Installing schema.. Module 'Magento_SendFriend': Installing schema.. Module 'Magento_Ui': Installing schema.. [ERROR] PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes in /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #3 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array) #5 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(453): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array) #6 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(511): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array) #7 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(1996): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...') #8 /home/.sites/83/site3961034/web/vendor/magento/module-ui/Setup/InstallSchema.php(88): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table)) #9 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Ui\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext)) #10 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema') #11 [internal function]: Magento\Setup\Model\Installer->installSchema() #12 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array) #13 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array) #14 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction() #15 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #16 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #17 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #18 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #19 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #20 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #21 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #22 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #23 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #24 /home/.sites/83/site3961034/web/setup/index.php(31): Zend\Mvc\Application->run() #25 {main} Next Zend_Db_Statement_Exception: 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` ( `bookmark_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Bookmark identifier' , `user_id` int UNSIGNED NOT NULL COMMENT 'User Id' , `namespace` varchar(255) NOT NULL COMMENT 'Bookmark namespace' , `identifier` varchar(255) NOT NULL COMMENT 'Bookmark Identifier' , `current` smallint NOT NULL COMMENT 'Mark current bookmark per user and identifier' , `title` varchar(255) NULL COMMENT 'Bookmark title' , `config` longtext NULL COMMENT 'Bookmark config' , `created_at` datetime NOT NULL COMMENT 'Bookmark created at' , `updated_at` datetime NOT NULL COMMENT 'Bookmark updated at' , PRIMARY KEY (`bookmark_id`), INDEX `UI_BOOKMARK_USER_ID_NAMESPACE_IDENTIFIER` (`user_id`, `namespace`, `identifier`), CONSTRAINT `UI_BOOKMARK_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE ) COMMENT='Bookmark' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci in /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235 Stack trace: #0 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #2 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/.sites/83/site3961034/web/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array) #4 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(453): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array) #5 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(511): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array) #6 /home/.sites/83/site3961034/web/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(1996): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...') #7 /home/.sites/83/site3961034/web/vendor/magento/module-ui/Setup/InstallSchema.php(88): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table)) #8 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Ui\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext)) #9 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema') #10 [internal function]: Magento\Setup\Model\Installer->installSchema() #11 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array) #12 /home/.sites/83/site3961034/web/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array) #13 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction() #14 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #15 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #16 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #17 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #18 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #19 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #20 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #21 /home/.sites/83/site3961034/web/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #22 /home/.sites/83/site3961034/web/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #23 /home/.sites/83/site3961034/web/setup/index.php(31): Zend\Mvc\Application->run() #24 {main}
Übrigens Magento 1.9.2.4 kann ich auf dem Server problemlos installieren...
Ich bin seit 10 Tage nach der Fehlersuche und keiner konnte mir helfen
Danke im Voraus.
LG,
Hi,
Welche MySQL Version verwendest du denn?
MySQL 5.6?
Was ist als default engine eingestellt? MyISAM oder InnoDB?
Es sieht eher nach einen MySQL Fehler als nach einen Magento Fehler aus...