Автор Тема: Повисает импорт товаров при импорте из csv файла.  (Прочитано 630 раз)

23 Июнь 2019, 19:39:19
  • Пользователь
  • **
  • Сообщений: 92
  • Репутация: +0/-0
  • Сообщество PrestaShop
    • Просмотр профиля
Даже если импортировать по 10 товаров все равно выходит ошибка.

Включаю импорт товаров, загружаю файл , происходит импорт нескольких товаров, потом все зависает и выдает ошибку импортирования.

Пробовал с разными товарами , одинаковая картина.

Как это решить?

В логах такие ошибки:
[Sun Jun 23 18:34:46.903669 2019] [:error] [pid 9615] [client 186.2.160.73:45755] PHP Fatal error:  Uncaught PrestaShopException: Link to database cannot be established: SQLSTATE[HY000] [2002] Connection refused in /public_html/classes/db/DbPDO.php:127\nStack trace:\n#0 /public_html/classes/db/Db.php(379): DbPDOCore->connect()\n#1 /public_html/classes/db/Db.php(613): DbCore->query('\\n\\t\\t\\tSELECT * FR...')\n#2 /public_html/classes/Hook.php(152): DbCore->executeS('\\n\\t\\t\\tSELECT * FR...')\n#3 /public_html/src/Adapter/LegacyHookSubscriber.php(233): HookCore::getHooks()\n#4 /public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(167): PrestaShop\\PrestaShop\\Adapter\\LegacyHookSubscriber::getSubscribedEvents()\n#5 /public_html/var/cache/prod/ContainerGcj8bdv/appProdProjectContainer.php(1738): Symfony\\Component\\EventDispatcher\\EventDispatcher->addSubscriber(Object(Presta in /public_html/classes/db/DbPDO.php on line 127, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 18:52:27.684340 2019] [:error] [pid 10745] [client 186.2.160.77:33897] PHP Warning:  PDO::query(): MySQL server has gone away in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 18:52:27.684368 2019] [:error] [pid 10745] [client 186.2.160.77:33897] PHP Warning:  PDO::query(): Error reading result set's header in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 18:52:27.689495 2019] [:error] [pid 10743] [client 186.2.160.77:51405] PHP Warning:  PDO::query(): MySQL server has gone away in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 18:52:27.689518 2019] [:error] [pid 10743] [client 186.2.160.77:51405] PHP Warning:  PDO::query(): Error reading result set's header in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.535859 2019] [:error] [pid 13388] [client 186.2.160.74:41373] PHP Warning:  PDO::query(): MySQL server has gone away in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.535894 2019] [:error] [pid 13388] [client 186.2.160.74:41373] PHP Warning:  PDO::query(): Error reading result set's header in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.543022 2019] [:error] [pid 13385] [client 186.2.160.73:1239] PHP Warning:  Packets out of order. Expected 1 received 0. Packet size=30 in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.543053 2019] [:error] [pid 13385] [client 186.2.160.73:1239] PHP Warning:  PDO::query(): MySQL server has gone away in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.543057 2019] [:error] [pid 13385] [client 186.2.160.73:1239] PHP Warning:  PDO::query(): Error reading result set's header in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.546551 2019] [:error] [pid 13385] [client 186.2.160.73:1239] PHP Fatal error:  Uncaught PrestaShopException: Link to database cannot be established: SQLSTATE[HY000] [2002] Connection refused in /public_html/classes/db/DbPDO.php:127\nStack trace:\n#0 /public_html/classes/db/Db.php(379): DbPDOCore->connect()\n#1 /public_html/classes/db/Db.php(613): DbCore->query('\\n\\t\\t\\tSELECT * FR...')\n#2 /public_html/classes/Hook.php(152): DbCore->executeS('\\n\\t\\t\\tSELECT * FR...')\n#3 /public_html/src/Adapter/LegacyHookSubscriber.php(233): HookCore::getHooks()\n#4 /public_html/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(167): PrestaShop\\PrestaShop\\Adapter\\LegacyHookSubscriber::getSubscribedEvents()\n#5 /public_html/var/cache/prod/ContainerGcj8bdv/appProdProjectContainer.php(1738): Symfony\\Component\\EventDispatcher\\EventDispatcher->addSubscriber(Object(Presta in /public_html/classes/db/DbPDO.php on line 127, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.549340 2019] [:error] [pid 13389] [client 186.2.160.78:5251] PHP Warning:  Packets out of order. Expected 1 received 0. Packet size=30 in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.549372 2019] [:error] [pid 13389] [client 186.2.160.78:5251] PHP Warning:  PDO::query(): MySQL server has gone away in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.549376 2019] [:error] [pid 13389] [client 186.2.160.78:5251] PHP Warning:  PDO::query(): Error reading result set's header in /public_html/classes/db/DbPDO.php on line 156, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
[Sun Jun 23 19:06:41.552166 2019] [:error] [pid 13389] [client 186.2.160.78:5251] PHP Fatal error:  Uncaught PrestaShopException: Link to database cannot be established: SQLSTATE[HY000] [2002] Connection refused in /public_html/classes/db/DbPDO.php:127\nStack trace:\n#0 /public_html/classes/db/Db.php(379): DbPDOCore->connect()\n#1 /public_html/classes/db/Db.php(613): DbCore->query('\\n            SE...')\n#2 /public_html/classes/Access.php(111): DbCore->executeS('\\n            SE...')\n#3 /public_html/src/PrestaShopBundle/Security/Admin/EmployeeProvider.php(83): AccessCore::getRoles(1)\n#4 /public_html/src/PrestaShopBundle/Security/Admin/EmployeeProvider.php(112): PrestaShopBundle\\Security\\Admin\\EmployeeProvider->loadUserByUsername('info@test.site')\n#5 /public_html/vendor/symfony/symfony/src/Symfony/Component/Security/Http/Firewall/ContextListener.php(172): PrestaShopBundle\\Security\\Admin\\EmployeeProv in /public_html/classes/db/DbPDO.php on line 127, referer: http://test.site/admin769pazsuf/index.php?controller=AdminImport&token=a96daddaac6adb193423bd9b22a90847
23 Июнь 2019, 20:29:59
Ответ #1
  • Ветеран
  • *****
  • Сообщений: 16673
  • Репутация: +14630/-5
  • Сообщество PrestaShop
    • Просмотр профиля
"MySQL server has gone away in" сервер mysql отбрасывает или отклоняет неправильные или слишком большие пакеты. Настройки mysql смотреть нужно.
23 Июнь 2019, 20:37:30
Ответ #2
  • Ветеран
  • *****
  • Сообщений: 22125
  • Репутация: +25303/-1
  • Prestashop - просто и эффективно
    • Просмотр профиля
Эксперт Prestashop - решения всех проблем, написание модулей, создание тем для интернет-магазинов под Prestashop.
Эксперт Magento - создам сайт на Magento, программирование кастомных модулей для Magento, кастомизация тем Magento.
Лучшие цены!!!