Internal Server Error on CSV Import

[extremaratio]

Hi,

I recently experienced a 500 error whenever I try to use the import tool on my prestashop 8.1.3 shop (shared Hosting).

The error happens when I click "Next Step" in the Import page, no matter what options or files are selected.

What I tried so far:

• try different csv, xls or ods files, even the sample ones;
• delete the previously imported files;
• disable non native modules;
• disable overrides;
• revert back to default theme;
• restore two different backups (files and db) from cpanel;
• switched PHP versions (8.0, 8.1, 8.2)
• upgrade to PS 8.1.4.

The rest of the shop seems to work properly, with no major issues.

Any help is very appreciated, since the import tool is vital for the shop.

Thanks.

Error:
Call to a member function getQueryHash() on null

  at /home/mhd-01/www.paoluccigioielli.com/htdocs/classes/db/Db.php:596
  at DbCore->executeS()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/classes/Hook.php:191)
  at HookCore::getHooks()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/src/Adapter/LegacyHookSubscriber.php:65)
  at PrestaShop\PrestaShop\Adapter\LegacyHookSubscriber::getSubscribedEvents()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:197)
  at Symfony\Component\EventDispatcher\EventDispatcher->addSubscriber()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/src/Adapter/Hook/HookDispatcher.php:88)
  at PrestaShop\PrestaShop\Adapter\Hook\HookDispatcher->__construct()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:3462)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->getPrestashop_Hook_DispatcherService()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:2410)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->getHookDispatcherService()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:3570)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->getPrestashop_Twig_Extension_HookService()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:3901)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->getTwigService()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:3706)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->getProfilerService()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:4893)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->getProfilerListenerService()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/var/cache/dev/ContainerWGn5bU9/appAppKernelDevDebugContainer.php:2756)
  at ContainerWGn5bU9\appAppKernelDevDebugContainer->ContainerWGn5bU9\{closure}()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:279)
  at Symfony\Component\EventDispatcher\EventDispatcher->sortListeners()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:90)
  at Symfony\Component\EventDispatcher\EventDispatcher->getListeners()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/Debug/TraceableEventDispatcher.php:334)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/Debug/TraceableEventDispatcher.php:162)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:229)
  at Symfony\Component\HttpKernel\HttpKernel->handleThrowable()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:120)
  at Symfony\Component\HttpKernel\HttpKernel->terminateWithException()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/EventListener/DebugHandlersListener.php:129)
  at Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure}()
     (/home/mhd-01/www.paoluccigioielli.com/htdocs/vendor/symfony/symfony/src/Symfony/Component/ErrorHandler/ErrorHandler.php:601)
  at Symfony\Component\ErrorHandler\ErrorHandler->handleException()                

 

[Prestashop Addict]

Do you have php/os cache enabled, like Memcached? If so try to disable it.

[extremaratio]

I don't have any php/os enabled.

[extremaratio]

any idea?

[Prestashop Addict]

What do you import in your import file?

[extremaratio]

Products, but I got the same error also importing categories, even using the sample files. The import process doesn't start, I cannot get to the second step (mapping columns).

Thanks