Prestashop: Can not access different shop sections after Upgrade 1.7.5.1 -> 1.7.6.3

[didi-2018]

Hi,

I upgraded from 1.7.5.1 to 1.7.6.3 and I can not access the following shop sections:

catalog -> categories
catalog -> brands & suppliers
customers -> customers
design -> sites
international -> localisation -> language
international -> localisation -> currencies

I get 500 ERROR.

This I found in advanced settings -> informations:
missing files (33):
vendor/composer/installers/src/Composer/Installers/UserFrostingInstaller.php
vendor/composer/installers/src/Composer/Installers/ExpressionEngineInstaller.php
vendor/composer/installers/src/Composer/Installers/KodiCMSInstaller.php
vendor/composer/installers/src/Composer/Installers/OsclassInstaller.php
vendor/composer/installers/src/Composer/Installers/MayaInstaller.php
vendor/composer/installers/src/Composer/Installers/EzPlatformInstaller.php
vendor/composer/installers/src/Composer/Installers/VanillaInstaller.php
vendor/composer/installers/src/Composer/Installers/ReIndexInstaller.php
vendor/composer/installers/src/Composer/Installers/ImageCMSInstaller.php
vendor/composer/installers/src/Composer/Installers/PlentymarketsInstaller.php
vendor/composer/installers/src/Composer/Installers/PxcmsInstaller.php
vendor/composer/installers/src/Composer/Installers/VgmcpInstaller.php
vendor/composer/installers/src/Composer/Installers/PortoInstaller.php
vendor/composer/installers/src/Composer/Installers/PhiftyInstaller.php
vendor/composer/installers/src/Composer/Installers/AttogramInstaller.php
vendor/composer/installers/src/Composer/Installers/LavaLiteInstaller.php
vendor/composer/installers/src/Composer/Installers/LanManagementSystemInstaller.php
vendor/composer/installers/src/Composer/Installers/EliasisInstaller.php
vendor/composer/installers/src/Composer/Installers/CockpitInstaller.php
vendor/composer/installers/src/Composer/Installers/ItopInstaller.php
vendor/composer/installers/src/Composer/Installers/YawikInstaller.php
vendor/composer/installers/src/Composer/Installers/Plugin.php
vendor/composer/installers/src/Composer/Installers/MauticInstaller.php
vendor/composer/installers/src/Composer/Installers/SyDESInstaller.php
vendor/composer/installers/src/Composer/Installers/BonefishInstaller.php
vendor/composer/installers/src/Composer/Installers/CiviCrmInstaller.php
vendor/composer/installers/src/Composer/Installers/KanboardInstaller.php
vendor/composer/installers/src/Composer/Installers/MajimaInstaller.php
vendor/composer/installers/src/Composer/Installers/ModxInstaller.php
vendor/composer/installers/src/Composer/Installers/SiteDirectInstaller.php
vendor/composer/installers/src/Composer/Installers/OntoWikiInstaller.php
vendor/composer/installers/src/Composer/Installers/RadPHPInstaller.php
vendor/composer/installers/src/Composer/Installers/DecibelInstaller.php

updated files (19):
admin573dqkovw/autoupgrade/index.php
admin573dqkovw/autoupgrade/backup/index.php
vendor/composer/installers/src/Composer/Installers/OxidInstaller.php
vendor/composer/installers/src/Composer/Installers/DrupalInstaller.php
vendor/composer/installers/src/Composer/Installers/BitrixInstaller.php
vendor/composer/installers/src/Composer/Installers/CraftInstaller.php
vendor/composer/installers/src/Composer/Installers/Concrete5Installer.php
vendor/composer/installers/src/Composer/Installers/AsgardInstaller.php
vendor/composer/installers/src/Composer/Installers/KirbyInstaller.php
vendor/composer/installers/src/Composer/Installers/ShopwareInstaller.php
vendor/composer/installers/src/Composer/Installers/SilverStripeInstaller.php
vendor/composer/installers/src/Composer/Installers/OctoberInstaller.php
vendor/composer/installers/src/Composer/Installers/BaseInstaller.php
vendor/composer/installers/src/Composer/Installers/TYPO3CmsInstaller.php
vendor/composer/installers/src/Composer/Installers/CakePHPInstaller.php
vendor/composer/installers/src/Composer/Installers/MoodleInstaller.php
vendor/composer/installers/src/Composer/Installers/WordPressInstaller.php
vendor/composer/installers/src/Composer/Installers/Installer.php
vendor/composer/installers/src/Composer/Installers/MediaWikiInstaller.php

This I get with debug mode:

InvalidFieldNameException

Doctrine\DBAL\Exception\InvalidFieldNameException: 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 i79e_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1' with params [1, 1, "category"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list' at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71 at Doctrine\DBAL\Driver\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 i79e_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1\' with params [1, 1, "category"]:SQLSTATE[42S22]: Column not found: 1054 Unknown column \'t0.filter_id\' in \'field list\'', object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128) at Doctrine\DBAL\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 i79e_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1', array(1, 1, 'category')) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855) at Doctrine\DBAL\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 i79e_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1', array(1, 1, 'category'), array('integer', 'integer', 'string')) (vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:712) at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array('employee' => 1, 'shop' => 1, 'filterId' => 'category'), null, null, array(), null, 1, null) (vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:196) at Doctrine\ORM\EntityRepository->findOneBy(array('employee' => 1, 'shop' => 1, 'filterId' => 'category')) (src/PrestaShopBundle/Entity/Repository/AdminFilterRepository.php:69) at PrestaShopBundle\Entity\Repository\AdminFilterRepository->findByEmployeeAndFilterId(1, 1, 'category') (src/Core/Search/Builder/RepositoryFiltersBuilder.php:76) at PrestaShop\PrestaShop\Core\Search\Builder\RepositoryFiltersBuilder->getParametersFromRepository('category') (src/Core/Search/Builder/RepositoryFiltersBuilder.php:49) at PrestaShop\PrestaShop\Core\Search\Builder\RepositoryFiltersBuilder->buildFilters(object(CategoryFilters)) (src/Core/Search/Builder/ChainedFiltersBuilder.php:80) at PrestaShop\PrestaShop\Core\Search\Builder\ChainedFiltersBuilder->buildFilters() (src/PrestaShopBundle/Controller/ArgumentResolver/FiltersBuilderResolver.php:70) at PrestaShopBundle\Controller\ArgumentResolver\FiltersBuilderResolver->resolve(object(Request), object(ArgumentMetadata)) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Controller/ArgumentResolver.php:62) at Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(object(Request), array(object(CategoryController), 'indexAction')) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Controller/TraceableArgumentResolver.php:38) at Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(object(Request), array(object(CategoryController), 'indexAction')) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:143) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, false) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200) at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, false) (admin573dqkovw/index.php:86)

PDOException

Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list' at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107 at Doctrine\DBAL\Driver\PDOStatement->execute() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847) at Doctrine\DBAL\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 i79e_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1', array(1, 1, 'category'), array('integer', 'integer', 'string')) (vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:712) at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array('employee' => 1, 'shop' => 1, 'filterId' => 'category'), null, null, array(), null, 1, null) (vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:196) at Doctrine\ORM\EntityRepository->findOneBy(array('employee' => 1, 'shop' => 1, 'filterId' => 'category')) (src/PrestaShopBundle/Entity/Repository/AdminFilterRepository.php:69) at PrestaShopBundle\Entity\Repository\AdminFilterRepository->findByEmployeeAndFilterId(1, 1, 'category') (src/Core/Search/Builder/RepositoryFiltersBuilder.php:76) at PrestaShop\PrestaShop\Core\Search\Builder\RepositoryFiltersBuilder->getParametersFromRepository('category') (src/Core/Search/Builder/RepositoryFiltersBuilder.php:49) at PrestaShop\PrestaShop\Core\Search\Builder\RepositoryFiltersBuilder->buildFilters(object(CategoryFilters)) (src/Core/Search/Builder/ChainedFiltersBuilder.php:80) at PrestaShop\PrestaShop\Core\Search\Builder\ChainedFiltersBuilder->buildFilters() (src/PrestaShopBundle/Controller/ArgumentResolver/FiltersBuilderResolver.php:70) at PrestaShopBundle\Controller\ArgumentResolver\FiltersBuilderResolver->resolve(object(Request), object(ArgumentMetadata)) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Controller/ArgumentResolver.php:62) at Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(object(Request), array(object(CategoryController), 'indexAction')) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Controller/TraceableArgumentResolver.php:38) at Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(object(Request), array(object(CategoryController), 'indexAction')) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:143) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, false) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200) at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, false) (admin573dqkovw/index.php:86)

PDOException

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list' at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105 at PDOStatement->execute(null) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105) at Doctrine\DBAL\Driver\PDOStatement->execute() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847) at Doctrine\DBAL\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 i79e_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1', array(1, 1, 'category'), array('integer', 'integer', 'string')) (vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:712) at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array('employee' => 1, 'shop' => 1, 'filterId' => 'category'), null, null, array(), null, 1, null) (vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:196) at Doctrine\ORM\EntityRepository->findOneBy(array('employee' => 1, 'shop' => 1, 'filterId' => 'category')) (src/PrestaShopBundle/Entity/Repository/AdminFilterRepository.php:69) at PrestaShopBundle\Entity\Repository\AdminFilterRepository->findByEmployeeAndFilterId(1, 1, 'category') (src/Core/Search/Builder/RepositoryFiltersBuilder.php:76) at PrestaShop\PrestaShop\Core\Search\Builder\RepositoryFiltersBuilder->getParametersFromRepository('category') (src/Core/Search/Builder/RepositoryFiltersBuilder.php:49) at PrestaShop\PrestaShop\Core\Search\Builder\RepositoryFiltersBuilder->buildFilters(object(CategoryFilters)) (src/Core/Search/Builder/ChainedFiltersBuilder.php:80) at PrestaShop\PrestaShop\Core\Search\Builder\ChainedFiltersBuilder->buildFilters() (src/PrestaShopBundle/Controller/ArgumentResolver/FiltersBuilderResolver.php:70) at PrestaShopBundle\Controller\ArgumentResolver\FiltersBuilderResolver->resolve(object(Request), object(ArgumentMetadata)) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Controller/ArgumentResolver.php:62) at Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(object(Request), array(object(CategoryController), 'indexAction')) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Controller/TraceableArgumentResolver.php:38) at Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(object(Request), array(object(CategoryController), 'indexAction')) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:143) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, false) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200) at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, false) (admin573dqkovw/index.php:86)

prod.log.txt
log.txt

Presta cache and browser cache was deleted a few times. Also /var/cache/ a few times. It does not help. All Presta chaches are disabled.

Hope these informations help!

[khouloudbelguith]

Hi @didi-2018,

Thanks for your report.
What is the exact version of the 1-click upgrade did you use?
This issue was fixed in the last version PS1.7.6.1 with this PR: https://github.com/PrestaShop/PrestaShop/pull/14620 as reported here: https://github.com/PrestaShop/PrestaShop/issues/14617
Here's a provisional solution:

ALTER TABLEps_admin_filterADDfilter_idINT NOT NULL ;

Thanks to check & feedback.

[didi-2018]

@khouloudbelguith thanks for your answer. I used Version 4.10.1

I insert column "filter_id" but now I get the following issue:

[khouloudbelguith]

@didi-2018, you have an override causing this issue

It is not a PrestaShop issue, please contact the module author which installs this override.

Thanks to check & feedback.

[didi-2018]

[didi-2018]

@didi-2018, you have an override causing this issue

It is not a PrestaShop issue, please contact the module author which installs this override.

Thanks to check & feedback.

I added this mail.php a long time ago. This is a tipp from prestashop forum to get all mails as a copy.

[khouloudbelguith]

@didi-2018, Can you please provide us the log of your upgrade? It can be found in the log.txt file, available in <admin folder>/autoupgrade/tmp/log.txt

PS: in my case, I did not manage to reproduce the issue with PS1.7.6.3 after an upgrade from PS1.7.5.1 using the 1-click upgrade v4.10.1.
https://drive.google.com/file/d/1JutVHUjSHft-WUuqW4ZOTuSFzok3lE9l/view

I added this mail.php a long time ago. This is a tipp from prestashop forum to get all mails as a copy.
You need to edit this file, it is causes issues with PS1.7.6.3.

Thanks!

[didi-2018]

@khouloudbelguith you will find the log in my first message called "log.txt"

[khouloudbelguith]

@didi-2018, thanks to provide a screenshot from the table ps_cuurency & ps_currency_lang.

Thanks!

[didi-2018]

@khouloudbelguith

[khouloudbelguith]

@didi-2018, as you can see in this screenshot

symbols & names of all currencies are missing in the first language (id_lang=1).
Thanks to edit this table ps_currency_lang & edit those missings.

Thanks to check & feedback.

[didi-2018]

@khouloudbelguith nothing happens.

categories:

brands & suppliers:

design -> sites:

international -> localisation -> languages:

international -> localisation -> currencies:

[didi-2018]

@khouloudbelguith this I found in table admin_filter:

[khouloudbelguith]

@didi-2018, thanks to navigate to the BO => International => Translations => update all your languges.

Could you please try to clear cache manually by deleting all the folder into var/cache (prod & dev).
Thanks to check and feedback.

[didi-2018]

@khouloudbelguith languages are updated and var/cache/prod and var/cache/dev are deleted but nothing happens. still no access

[didi-2018]

@khouloudbelguith what do you think should I do a new update and deinstall autoupgrade module first and install new before upgrade?

[khouloudbelguith]

@didi-2018, As always, you can use the 1-click update to upgrade between minor versions without much trouble. In order to avoid problems, remember not to change core files, check the compatibility of your modules and theme beforehand, and test the upgrade on a separate machine from your production.

Thanks!

[didi-2018]

@khouloudbelguith so you do not have any idea what causes the errors? I always make updates on a fresh shopcopy.

I have just done a new upgrade with deinstall autoupgrade and install fresh and upgrade stopped at upgrading presta modules and logged me out. After login the same problems as before. No column "filter_id" insert and all the rest

[khouloudbelguith]

@didi-2018, in my case, I did not manage to reproduce the issue, but it could be the problem related to some overrides added in your case or some custom module.

Thanks!

[didi-2018]

@khouloudbelguith all not-presta-modules are disabled before update, all overrides are disabled, Mail.php is deleted.

Now "id_log" is not found

[khouloudbelguith]

@didi-2018,

all not-presta-modules are disabled before update, all overrides are disabled

Those options are disabled from the BO => Advanced Parameters => Performance page?

Thanks!

[didi-2018]

@khouloudbelguith YES excactly!

[khouloudbelguith]

@didi-2018, The options do not work in the PS1.7.6
as reported here:
https://github.com/PrestaShop/PrestaShop/issues/14596
https://github.com/PrestaShop/PrestaShop/issues/9965
So, please check if you have any override manually in all folders: https://github.com/PrestaShop/PrestaShop/tree/develop/override

Thanks!

[didi-2018]

@khouloudbelguith all override files removed and all third party modules manually deactiveted and still the same.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id_log' in 'order clause'
what does it mean?

[didi-2018]

@khouloudbelguith what I saw before a few days is there are no more numbers shown for modules that should be updated. notification_counter does not work anymore in my 1.7.5.1 and after update a module there appears everytime the presta notice:

but module are updated. This a have since a few days, maybe a week. And my favicon is gone too in module section where are modules updates are.

[khouloudbelguith]

@didi-2018, your upgrade was stopped when upgrading PrestaShop modules.
It could be related to this issue.

And my favicon is gone too in module section where are modules updates are.

Did you make any changes before this? did you install any modules?

Thanks!

[didi-2018]

@khouloudbelguith in the mean time a maked new update and it does not stop.

I installed a module for a video tab in FO and one for alt tags. But if I disable them, the problem is still there. And I always do a lot in my shop. I can not say it happened with installing something. One day it was like now is.

[khouloudbelguith]

@didi-2018, did you delete any currency before?
Your issue is similar to this ticket: https://github.com/PrestaShop/PrestaShop/issues/17185

Thanks!

[didi-2018]

@khouloudbelguith no I did not delete any currency. You can look at the database screenshot I have sent you today. Only three currencies and all are active.

[khouloudbelguith]

@didi-2018, multistore is enabled?

Thanks!

[didi-2018]

@khouloudbelguith no I do not use multistore

[khouloudbelguith]

@didi-2018, Despite our several trials, we could not reproduce your issue with the provided information.
It seems that your issue is not a PrestaShop's core bug but most likely a server configuration or customization problem.
I invite you to contact our support team: http://addons.prestashop.com/en/388-support to help you solve your issue.

Thanks!

[didi-2018]

@khouloudbelguith I could find out that prestashop makes wrong entries in database "admin_filter". The filters are wrong! For example: "orderBy : "id_log" in category search. Deleting that wrong database entries fixed my problems and I have access to the section I could not access before.

[didi-2018]

@khouloudbelguith

for example:
catalog -> categories prestashop make an entry in database "admin_filter":

{"limit":50,"orderBy":"id_lang","sortOrder":"ASC","filters":{"id_category_parent":"2"}}

there is no filter "id_lang" and access is not possible.

and set no "controller" and "action". So how should the shop now know for what the filter is?

deleting that filter from database and refresh the page, the page works.