Error: Prestashop 8 installation on HestiaCP panel

Hello,

In a clean installation of a HestiaCP (Version 1.7.3) on a ubuntu 22.04, if you add a user and a domain to install a Prestashop, it gives the following error:


PHP Warning: Attempt to read property “theme_name” on null in /home/usuario/web/pleskclonado.cf/public_html/var/cache/prod/ContainerAh6vLbn/appAppKernelProdContainer.php on line 2702 PDO Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: #0 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute() #1 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(749): Doctrine\DBAL\Connection->executeQuery() #3 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(243): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load() #4 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Entity/Repository/TabRepository.php(61): Doctrine\ORM\EntityRepository->findOneBy() #5 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Entity/Repository/TabRepository.php(71): PrestaShopBundle\Entity\Repository\TabRepository->findOneByClassName() #6 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabRegister.php(171): PrestaShopBundle\Entity\Repository\TabRepository->findOneIdByClassName() #7 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabRegister.php(129): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabRegister->addUndeclaredTabs() #8 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabManagementSubscriber.php(71): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabRegister->registerTabs() #9 /home/usuario/web/pleskclonado.cf/public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(251): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabManagementSubscriber->onModuleInstall() #10 /home/usuario/web/pleskclonado.cf/public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #11 /home/usuario/web/pleskclonado.cf/public_html/src/Core/Module/ModuleManager.php(380): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #12 /home/usuario/web/pleskclonado.cf/public_html/src/Core/Module/ModuleManager.php(113): PrestaShop\PrestaShop\Core\Module\ModuleManager->dispatch() #13 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Install/Install.php(1034): PrestaShop\PrestaShop\Core\Module\ModuleManager->install() #14 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Install/Install.php(989): PrestaShopBundle\Install\Install->executeAction() #15 /home/usuario/web/pleskclonado.cf/public_html/install/controllers/console/process.php(288): PrestaShopBundle\Install\Install->installModules() #16 /home/usuario/web/pleskclonado.cf/public_html/install/controllers/console/process.php(167): InstallControllerConsoleProcess->processInstallModules() #17 /home/usuario/web/pleskclonado.cf/public_html/install/classes/controllerConsole.php(128): InstallControllerConsoleProcess->process() #18 /home/usuario/web/pleskclonado.cf/public_html/install/index_cli.php(64): InstallControllerConsole::execute() #19 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(749): Doctrine\DBAL\Connection->executeQuery() #3 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(243): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load() #4 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Entity/Repository/TabRepository.php(61): Doctrine\ORM\EntityRepository->findOneBy() #5 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Entity/Repository/TabRepository.php(71): PrestaShopBundle\Entity\Repository\TabRepository->findOneByClassName() #6 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabRegister.php(171): PrestaShopBundle\Entity\Repository\TabRepository->findOneIdByClassName() #7 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabRegister.php(129): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabRegister->addUndeclaredTabs() #8 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabManagementSubscriber.php(71): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabRegister->registerTabs() #9 /home/usuario/web/pleskclonado.cf/public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(251): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabManagementSubscriber->onModuleInstall() #10 /home/usuario/web/pleskclonado.cf/public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #11 /home/usuario/web/pleskclonado.cf/public_html/src/Core/Module/ModuleManager.php(380): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #12 /home/usuario/web/pleskclonado.cf/public_html/src/Core/Module/ModuleManager.php(113): PrestaShop\PrestaShop\Core\Module\ModuleManager->dispatch() #13 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Install/Install.php(1034): PrestaShop\PrestaShop\Core\Module\ModuleManager->install() #14 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Install/Install.php(989): PrestaShopBundle\Install\Install->executeAction() #15 /home/usuario/web/pleskclonado.cf/public_html/install/controllers/console/process.php(288): PrestaShopBundle\Install\Install->installModules() #16 /home/usuario/web/pleskclonado.cf/public_html/install/controllers/console/process.php(167): InstallControllerConsoleProcess->processInstallModules() #17 /home/usuario/web/pleskclonado.cf/public_html/install/classes/controllerConsole.php(128): InstallControllerConsoleProcess->process() #18 /home/usuario/web/pleskclonado.cf/public_html/install/index_cli.php(64): InstallControllerConsole::execute() #19 {main} Next Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing ‘SELECT t0.id_tab AS id_tab_1, t0.id_parent AS id_parent_2, t0.position AS position_3, t0.module AS module_4, t0.class_name AS class_name_5, t0.route_name AS route_name_6, t0.active AS active_7, t0.enabled AS enabled_8, t0.icon AS icon_9, t0.wording AS wording_10, t0.wording_domain AS wording_domain_11 FROM ps_tab t0 WHERE t0.class_name = ? LIMIT 1’ with params [“AdminDashgoals”]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115 Stack trace: #0 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() #1 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException() #2 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery() #3 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1313): Doctrine\DBAL\Connection->handleExceptionDuringQuery() #4 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(749): Doctrine\DBAL\Connection->executeQuery() #5 /home/usuario/web/pleskclonado.cf/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(243): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load() #6 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Entity/Repository/TabRepository.php(61): Doctrine\ORM\EntityRepository->findOneBy() #7 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Entity/Repository/TabRepository.php(71): PrestaShopBundle\Entity\Repository\TabRepository->findOneByClassName() #8 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabRegister.php(171): PrestaShopBundle\Entity\Repository\TabRepository->findOneIdByClassName() #9 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabRegister.php(129): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabRegister->addUndeclaredTabs() #10 /home/usuario/web/pleskclonado.cf/public_html/src/Adapter/Module/Tab/ModuleTabManagementSubscriber.php(71): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabRegister->registerTabs() #11 /home/usuario/web/pleskclonado.cf/public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(251): PrestaShop\PrestaShop\Adapter\Module\Tab\ModuleTabManagementSubscriber->onModuleInstall() #12 /home/usuario/web/pleskclonado.cf/public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #13 /home/usuario/web/pleskclonado.cf/public_html/src/Core/Module/ModuleManager.php(380): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #14 /home/usuario/web/pleskclonado.cf/public_html/src/Core/Module/ModuleManager.php(113): PrestaShop\PrestaShop\Core\Module\ModuleManager->dispatch() #15 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Install/Install.php(1034): PrestaShop\PrestaShop\Core\Module\ModuleManager->install() #16 /home/usuario/web/pleskclonado.cf/public_html/src/PrestaShopBundle/Install/Install.php(989): PrestaShopBundle\Install\Install->executeAction() #17 /home/usuario/web/pleskclonado.cf/public_html/install/controllers/console/process.php(288): PrestaShopBundle\Install\Install->installModules() #18 /home/usuario/web/pleskclonado.cf/public_html/install/controllers/console/process.php(167): InstallControllerConsoleProcess->processInstallModules() #19 /home/usuario/web/pleskclonado.cf/public_html/install/classes/controllerConsole.php(128): InstallControllerConsoleProcess->process() #20 /home/usuario/web/pleskclonado.cf/public_html/install/index_cli.php(64): InstallControllerConsole::execute() #21 {main}Error: cmd exited with errors

to solve the problem, it was necessary to make a change to the MySQL configuration, you must increase the MySQL parameters in the MariaDB configuration section:

wait_timeout = 300
max_allowed_packet=64M

I hope it will help you.

I take this opportunity to consult you:

Is this “normal” or should I make an issue to increase the MySQL default values?

Regards!

increase wait_timeout in mysql configuration to 120-200

1 Like

th…you very much! Work now!

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.