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)