cancel
Showing results for 
Search instead for 
Did you mean: 

Installation stuck at 26%: SQLSTATE[42000]

Installation stuck at 26%: SQLSTATE[42000]

Hello to everyone,

I'm trying to install a magento software but i receive every time the same error message:

[ERROR] PDOException: SQLSTATE [42000]: Syntax error or access violation: 1071 Specified key was too long;

I have tried CE 2.0 and CE 2.1 and both with same error (fresh install).

Can somebody pleas help me.

Thanks in advance.

 

Console Log:

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}

 

6 REPLIES 6

Re: Installation stuck at 26%: SQLSTATE[42000]

Hi @vulner_x,

 

Can you sahre your software stack (with versions)?

Re: Installation stuck at 26%: SQLSTATE[42000]

Hi @Damian Culotta,

 

tnx for fast replay. I think it is shared hosting solution.

 

PHP: 7.0.13

mySql:  5.6

 

Is it possible to install magento on shared hosting?

 

Regards,

Sandin

Re: Installation stuck at 26%: SQLSTATE[42000]

@vulner_xis possible but never was recommended.

I understand that is possible but the reality says that is a worse idea with M2 than M1.

 

I understand that your error is related with some index creation but I've never got the error with fresh installs.


Are you sure that your current stack satisfy this requeriments?

 

Magento 2.0.x: http://devdocs.magento.com/guides/v2.0/install-gde/system-requirements-tech.html

Magento 2.1.x: http://devdocs.magento.com/guides/v2.1/install-gde/system-requirements-tech.html

Re: Installation stuck at 26%: SQLSTATE[42000]

Hi @Damian Culotta,

 

i think i do.. i also tried reaidmess ceck and everything was green.

 

PHP Version Check
Your PHP version is correct (7.0.13).

PHP Settings Check
Your PHP settings are correct.

PHP Extensions Check
You meet 15 out of 15 PHP extensions requirements. Hide detail

PHP Extension curl.
PHP Extension dom.
PHP Extension iconv.
PHP Extension mcrypt.
PHP Extension spl.
PHP Extension xsl.
PHP Extension intl.
PHP Extension mbstring.
PHP Extension ctype.
PHP Extension hash.
PHP Extension openssl.
PHP Extension zip.
PHP Extension simplexml.
PHP Extension xmlwriter.
PHP Extension gd.

File Permission Check

Thanks in advance.

 

Regards,

Sandin

Re: Installation stuck at 26%: SQLSTATE[42000]

But install for 1.9.3.1 goes without any problems Smiley Frustrated 

 

Does somebody has any idea?

Re: Installation stuck at 26%: SQLSTATE[42000]

Anyone?