cancel
Showing results for 
Search instead for 
Did you mean: 

Error when installing - tried all recomendations

Error when installing - tried all recomendations

I'm trying to install 2.0.2 Community to evaluate it and so far I'm having a heck of a time just trying to get it installed.  

 

Server specs are as follows:

personal Dedicated server running Web Host Manager.

Dual Xeon X5355 @ 2.66Ghz (8 cores total)

12 GB Ram

Plenty of HDD space

PHP 5.6

MySQL 5.6.29

 

I get stuck at 66% with the following error: 

 

[ERROR] exception 'Exception' with message 'Warning: Error while sending QUERY packet. PID=20017 in /home/ps3court/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228' in /home/ps3court/public_html/magento/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'Error while sen...', '/home/ps3court/...', 228, Array)
#1 /home/ps3court/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#2 /home/ps3court/public_html/magento/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#3 /home/ps3court/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /home/ps3court/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /home/ps3court/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `setup_m...', Array)
#6 /home/ps3court/public_html/magento/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `setup_m...', Array)
#7 /home/ps3court/public_html/magento/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('UPDATE `setup_m...', Array)
#8 /home/ps3court/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(635): Magento\Framework\DB\Adapter\Pdo\Mysql->query('UPDATE `setup_m...', Array)
#9 /home/ps3court/public_html/magento/vendor/magento/framework/Module/ModuleResource.php(129): Zend_Db_Adapter_Abstract->update('setup_module', Array, Array)
#10 /home/ps3court/public_html/magento/setup/src/Magento/Setup/Model/Installer.php(808): Magento\Framework\Module\ModuleResource->setDataVersion('Magento_Directo...', '2.0.0')
#11 /home/ps3court/public_html/magento/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/ps3court/public_html/magento/setup/src/Magento/Setup/Model/Installer.php(331): call_user_func_array(Array, Array)
#14 /home/ps3court/public_html/magento/setup/src/Magento/Setup/Controller/Install.php(97): Magento\Setup\Model\Installer->install(Array)
#15 /home/ps3court/public_html/magento/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/ps3court/public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 /home/ps3court/public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /home/ps3court/public_html/magento/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#20 /home/ps3court/public_html/magento/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/ps3court/public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#23 /home/ps3court/public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /home/ps3court/public_html/magento/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#25 /home/ps3court/public_html/magento/setup/index.php(31): Zend\Mvc\Application->run()
#26 {main}

I've read it's caused by a MySQL Memroy Error so I bumped up max_allowed_packet to 256MB - which should be WAY more than it needs.

 

I also read its caused by the a lack the PHP Memory Limit setting so I bumped that up to 256.  

 

I've also read it can be caused by the php settings: max_execution_time and max_input_time being too low, so I bumped them up to 300 respectively from 60 and 30.  

 

Still no dice.  What else could be causing these issues?

 

******EDIT******

I was able to correct the problem by increasing the wait_timeout in my.cnf to 60 from 10

3 REPLIES

Re: Error when installing - tried all recomendations

Well it looks like I spoke too soon.  I'm stuck at 90%

 

Module 'Magento_Downloadable':
Installing schema.. 

Its been sitting at this point for over 2 hours.  any ideas on how to fix this?

Re: Error when installing - tried all recomendations

I have the same problem! stuck at 67%:

 

Module 'Magento_ConfigurableSampleData':
Installing data...
[ERROR] exception 'Exception' with message 'Warning: Error while sending QUERY packet. PID=487835 in /public_html/shop/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228' in /public_html/shop/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'Error while sen...', '/home/***/...', 228, Array)

Re: Error when installing - tried all recomendations

That maybe because you didn't enable all required PHP extensions for Magento 2

You can follow this tutorial to have a complete Magento 2 installation on Xampp localhost

How to install Magento 2 on XAMPP localhost in 4 steps

Hope this helps