Errors after manual upgrade from 1.7.5 to 1.7.6.9

[sylwekb]

I performed a manual update on a test copy of the page as instructed below. I was clearing the cache. I have php 7.3

https://belvg.com/blog/how-to-upgrade-prestashop-step-by-step-instruction.html

An error appeared in the administration panel in the Products and categories tabs

Oops! An Error Occurred
The server returned a "500 Internal Server Error".
Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

However, I got bugs when I turned on debug mode. How can they be improved?

Admin panel

Whoops, looks like something went wrong.

 (1/1) ContextErrorException

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?
in UnitOfWork.php line 2636
at ErrorHandler->handleError(2, '"continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?', '/...../vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php', 2636, array('class' => 'Doctrine\\ORM\\UnitOfWork', 'e' => 32767, 'file' => '/...../vendor/composer/../doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php'))in DebugClassLoader.php line 156
at require()in DebugClassLoader.php line 156
at DebugClassLoader->loadClass('Doctrine\\ORM\\UnitOfWork')
at spl_autoload_call('Doctrine\\ORM\\UnitOfWork')in EntityManager.php line 160
at EntityManager->__construct(object(Connection), object(Configuration), object(ContainerAwareEventManager))in EntityManager.php line 850
at EntityManager::create(object(Connection), object(Configuration))in appDevDebugProjectContainer.php line 1827
at appDevDebugProjectContainer->getDoctrine_Orm_DefaultEntityManagerService()in getPrestashop_Translation_DatabaseLoaderService.php line 8
at require('/...../var/cache/dev/ContainerL2wrsea/getPrestashop_Translation_DatabaseLoaderService.php')in appDevDebugProjectContainer.php line 1723
at appDevDebugProjectContainer->load('getPrestashop_Translation_DatabaseLoaderService.php')in appDevDebugProjectContainer.php line 3751
at appDevDebugProjectContainer->ContainerL2wrsea\{closure}()in ServiceLocator.php line 64
at ServiceLocator->get('prestashop.translation.database_loader')in Translator.php line 141
at Translator->initialize()in Translator.php line 127
at Translator->initializeCatalogue('pl-PL')in Translator.php line 314
at Translator->dumpCatalogue('pl-PL', object(ResourceCheckerConfigCache))in Translator.php line 299
at Translator->Symfony\Component\Translation\{closure}(object(ResourceCheckerConfigCache))in ResourceCheckerConfigCacheFactory.php line 43
at ResourceCheckerConfigCacheFactory->cache('/...../var/cache/dev/translations/catalogue.pl-PL.L8dqxxF.php', object(Closure))in Translator.php line 300
at Translator->initializeCacheCatalogue('pl-PL')in Translator.php line 265
at Translator->loadCatalogue('pl-PL')in Translator.php line 241
at Translator->getCatalogue('pl-PL')in Translator.php line 198
at Translator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)in PrestaShopTranslatorTrait.php line 57
at Translator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)in LoggingTranslator.php line 48
at LoggingTranslator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)in DataCollectorTranslator.php line 50
at DataCollectorTranslator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)in PrestaShopTranslatorTrait.php line 57
at DataCollectorTranslator->trans('Successful deletion.', array(), 'Admin.Notifications.Success', null)in Controller.php line 324
at ControllerCore->trans('Successful deletion.', array('legacy' => 'htmlspecialchars'), 'Admin.Notifications.Success')in AdminController.php line 466
at AdminControllerCore->__construct()in LegacyContext.php line 85
at LegacyContext->getContext()in UserLocaleListener.php line 39
at UserLocaleListener->__construct(object(LegacyContext))in appDevDebugProjectContainer.php line 2397
at appDevDebugProjectContainer->getPrestashop_UserLocale_ListenerService()in appDevDebugProjectContainer.php line 2884
at appDevDebugProjectContainer->ContainerL2wrsea\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 262
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 86

 

[JBW]

Your Prestashop version is only compatible up to PHP 7.2 - the error is caused by wrong PHP version!

[sylwekb]

I changed the php version on the copy of the site to version 7.1.

Linux server information # 2 SMP Tue Nov 19 07:12:54 CET 2019 x86_64 Server Software Version: Apache PHP version: 7.1.33 Memory limit: 256M Maximum execution time: 500 Maximum file size for upload: 150M

After uploading the update files to the server after selecting the page at domain/install/upgrade/upgrade.php first I have a blank page and then I get an error after refreshing XML processing error: root element not found Area: domain/install/upgrade/upgrade.php Line number: 384, column 1:

After logging in to the administration panel, I have errors in some tabs e.g. products, clients

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

after enabling debug mode i have errors

An exception occurred while executing 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "ProductController", "catalogAction"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'

    Exceptions 3 Logs 2 Stack Traces 3

Doctrine\DBAL\Exception\ InvalidFieldNameException
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 71)
AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1\' with params [1, 1, "ProductController", "catalogAction"]:SQLSTATE[42S22]: Column not found: 1054 Unknown column \'t0.filter_id\' in \'field list\'', object(PDOException)) in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php (line 128)
DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array(1, 1, 'ProductController', 'catalogAction')) in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 855)
Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array(1, 1, 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php (line 712)
BasicEntityPersister->load(array('employee' => 1, 'shop' => 1, 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, 1, null) in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php (line 196)
EntityRepository->findOneBy(array('employee' => 1, 'shop' => 1, 'controller' => 'ProductController', 'action' => 'catalogAction')) in src/Adapter/Product/AdminProductDataProvider.php (line 96)

                $shop = Context::getContext()->shop;
                $filter = $this->entityManager->getRepository('PrestaShopBundle:AdminFilter')->findOneBy(array(
                    'employee' => $employeeId,
                    'shop' => $shop->id ?: 0,
                    'controller' => 'ProductController',
                    'action' => 'catalogAction',
                ));
                /** @var $filter AdminFilter */
                if (null === $filter) {
                    $filters = AdminFilter::getProductCatalogEmptyFilter();

AdminProductDataProvider->getPersistedFilterParameters() in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 129)
ProductController->catalogAction(object(Request), 'last', 0, 'last', 'last') in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
HttpKernel->handle(object(Request), 1, false) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
Kernel->handle(object(Request), 1, false) in admin/index.php (line 86)
Doctrine\DBAL\Driver\ PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 107)
PDOStatement->execute() in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 847)
Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array(1, 1, 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php (line 712)
BasicEntityPersister->load(array('employee' => 1, 'shop' => 1, 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, 1, null) in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php (line 196)
EntityRepository->findOneBy(array('employee' => 1, 'shop' => 1, 'controller' => 'ProductController', 'action' => 'catalogAction')) in src/Adapter/Product/AdminProductDataProvider.php (line 96)

                $shop = Context::getContext()->shop;
                $filter = $this->entityManager->getRepository('PrestaShopBundle:AdminFilter')->findOneBy(array(
                    'employee' => $employeeId,
                    'shop' => $shop->id ?: 0,
                    'controller' => 'ProductController',
                    'action' => 'catalogAction',
                ));
                /** @var $filter AdminFilter */
                if (null === $filter) {
                    $filters = AdminFilter::getProductCatalogEmptyFilter();

AdminProductDataProvider->getPersistedFilterParameters() in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 129)
ProductController->catalogAction(object(Request), 'last', 0, 'last', 'last') in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
HttpKernel->handle(object(Request), 1, false) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
Kernel->handle(object(Request), 1, false) in admin/index.php (line 86)
PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 105)
PDOStatement->execute(null) in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 105)
PDOStatement->execute() in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 847)
Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array(1, 1, 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php (line 712)
BasicEntityPersister->load(array('employee' => 1, 'shop' => 1, 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, 1, null) in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php (line 196)
EntityRepository->findOneBy(array('employee' => 1, 'shop' => 1, 'controller' => 'ProductController', 'action' => 'catalogAction')) in src/Adapter/Product/AdminProductDataProvider.php (line 96)

                $shop = Context::getContext()->shop;
                $filter = $this->entityManager->getRepository('PrestaShopBundle:AdminFilter')->findOneBy(array(
                    'employee' => $employeeId,
                    'shop' => $shop->id ?: 0,
                    'controller' => 'ProductController',
                    'action' => 'catalogAction',
                ));
                /** @var $filter AdminFilter */
                if (null === $filter) {
                    $filters = AdminFilter::getProductCatalogEmptyFilter();

AdminProductDataProvider->getPersistedFilterParameters() in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 129)
ProductController->catalogAction(object(Request), 'last', 0, 'last', 'last') in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
HttpKernel->handle(object(Request), 1, false) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
Kernel->handle(object(Request), 1, false) in admin/index.php (line 86)

Edited January 24, 2021 by sylwekb (see edit history)

[JBW]

You are missing a column in your database. Please find instructions to fix it here:

https://github.com/PrestaShop/PrestaShop/issues/14617

[cedcommerce]

Hello 

Hope you are fine. 

We are very glad to inform you that we have a team of certified Prestashop development Team, we will surely help and migrate your data information successfully. 

Please connect with us and brief all your issues over Skype or Whatsapp or Email. 

Skype: https://join.skype.com/invite/oiAb7sBcLZ0R
Whatsapp: https://wa.me/918765210314

Looking forward to hear from you soon!!

Thanks