Closed duongquyet closed 8 years ago
@duongquyet can you provide information about your server (PHP version, MySQL etc)?
Some information of our server: PHP Version 5.6.15 mysqlnd 5.0.11 memory_limit 128M post_max_size 8M max_file_uploads 20 max_execution_time 30
@duongquyet can you try to install Magento without Sample Data. When it's ok, install Sample Data from CLI (more verbose than setup wizard) ?
BTW, Magento 2 memory limit must be 768M (set in htaccess), the issue caome from here maybe.
@duongquyet can you please check your server and php logs to check if there is any error? Also, the max_execution_time
is too low. it is recommended to be set to 18000
Have simmilar problem, just getting error info:
Module 'Magento_ConfigurableSampleData':
Installing data..
[ERROR] Exception: Warning: Error while sending QUERY packet. PID=8102 in /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 in /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'Error while sen...', '/home/speedbad/...', 228, Array)
#1 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#2 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#3 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `setup_m...', Array)
#6 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `setup_m...', Array)
#7 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('UPDATE `setup_m...', Array)
#8 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(635): Magento\Framework\DB\Adapter\Pdo\Mysql->query('UPDATE `setup_m...', Array)
#9 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/magento/framework/Module/ModuleResource.php(129): Zend_Db_Adapter_Abstract->update('setup_module', Array, '(module = 'Mage...')
#10 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/setup/src/Magento/Setup/Model/Installer.php(808): Magento\Framework\Module\ModuleResource->setDataVersion('Magento_Configu...', '2.0.0')
#11 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/setup/src/Magento/Setup/Model/Installer.php(746): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data')
#12 [internal function]: Magento\Setup\Model\Installer->installDataFixtures()
#13 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/setup/src/Magento/Setup/Model/Installer.php(331): call_user_func_array(Array, Array)
#14 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/setup/src/Magento/Setup/Controller/Install.php(97): Magento\Setup\Model\Installer->install(Array)
#15 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#16 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#17 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#20 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#21 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#22 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#23 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#25 /home/speedbad/domains/ridikiuliai.lt/public_html/learn/setup/index.php(31): Zend\Mvc\Application->run()
#26 {main}
@mcekutis what is the value of max_allowed_packet
in mysql?
Hi, Thanks you guys. I changed memory_limit 128M to 512M, max_execution_time 30 to 1800. Now, I can install it. But I get other problem. Our site have a lot bug. You can see my screen for more detail.
@duongquyet please open a new issue. This is not related to this thread.
@duongquyet for that last issue, you may reference #2412 as there is a good chance that is the issue you're experiencing.
FYI, in my case, increasing the MySQL max_allowed_packet
solved this issue
Hi, I'm trying install magento 2 on our server but it doesn't work.
Please help me to resolve this issue. Thanks.