[SOLVED] 1-Click Upgrade after upgrade no native language

[Thommen]

Using 1-Click Upgrade I updated from "1.6.1.16" → "1.6.1.24" → "1.7.8.10". On PrestaShop I had the backend in Polish language. After the upgrade I have in English language.

How can I restore the Polish language of the backend of the store?

I tried to change the Polish language to English before the update, but I have errors during the update:

[INTERNAL] /home/platne/serwer188777/public_html/x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 - Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1' with params ["en"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.locale' in 'field list'
#0 /home/platne/serwer188777/public_html/x/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /home/platne/serwer188777/public_html/x/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(145): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'An exception oc...')
#2 /home/platne/serwer188777/public_html/x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(913): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT t0.id_la...', Array)
#3 /home/platne/serwer188777/public_html/x/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(726): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id_la...', Array, Array)
#4 /home/platne/serwer188777/public_html/x/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(193): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#5 /home/platne/serwer188777/public_html/x/src/PrestaShopBundle/Translation/Loader/DatabaseTranslationLoader.php(72): Doctrine\ORM\EntityRepository->findOneBy(Array)
#6 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(385): PrestaShopBundle\Translation\Loader\DatabaseTranslationLoader->load('validators.en.d...', 'en', 'validators')
#7 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(277): Symfony\Component\Translation\Translator->doLoadCatalogue('en')
#8 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Translation/Translator.php(128): Symfony\Component\Translation\Translator->initializeCatalogue('en')
#9 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(396): Symfony\Bundle\FrameworkBundle\Translation\Translator->initializeCatalogue('en')
#10 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(283): Symfony\Component\Translation\Translator->loadFallbackCatalogues('en_US')
#11 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Translation/Translator.php(128): Symfony\Component\Translation\Translator->initializeCatalogue('en_US')
#12 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(396): Symfony\Bundle\FrameworkBundle\Translation\Translator->initializeCatalogue('en_US')
#13 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(283): Symfony\Component\Translation\Translator->loadFallbackCatalogues(NULL)
#14 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Translation/Translator.php(128): Symfony\Component\Translation\Translator->initializeCatalogue(NULL)
#15 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(314): Symfony\Bundle\FrameworkBundle\Translation\Translator->initializeCatalogue(NULL)
#16 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(299): Symfony\Component\Translation\Translator->dumpCatalogue(NULL, Object(Symfony\Component\Config\ResourceCheckerConfigCache))
#17 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCacheFactory.php(43): Symfony\Component\Translation\Translator->Symfony\Component\Translation\{closure}(Object(Symfony\Component\Config\ResourceCheckerConfigCache))
#18 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(300): Symfony\Component\Config\ResourceCheckerConfigCacheFactory->cache('/home/platne/se...', Object(Closure))
#19 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(265): Symfony\Component\Translation\Translator->initializeCacheCatalogue(NULL)
#20 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(241): Symfony\Component\Translation\Translator->loadCatalogue(NULL)
#21 /home/platne/serwer188777/public_html/x/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php(198): Symfony\Component\Translation\Translator->getCatalogue(NULL)
#22 /home/platne/serwer188777/public_html/x/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php(61): Symfony\Component\Translation\Translator->trans('[DROP] SQL %s t...', Array, 'messages', NULL)
#23 /home/platne/serwer188777/public_html/x/classes/Translate.php(282): PrestaShopBundle\Translation\Translator->trans('[DROP] SQL %s t...', Array, NULL, NULL)
#24 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/UpgradeTools/Translator.php(60): TranslateCore::getModuleTranslation('autoupgrade', '[DROP] SQL %s t...', 'AdminSelfUpgrad...', NULL)
#25 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(421): PrestaShop\Module\AutoUpgrade\UpgradeTools\Translator->trans('[DROP] SQL %s t...', Array, 'Modules.Autoupg...')
#26 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(357): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->runSqlQuery('1.7.0.0', 'CREATE TABLE `p...')
#27 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(279): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->runQuery('1.7.0.0', 'CREATE TABLE `p...')
#28 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(61): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->upgradeDb('1.6.1.24')
#29 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(102): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->upgradeDb('1.6.1.24')
#30 /home/platne/serwer188777/public_html/x/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(41): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade()
#31 /home/platne/serwer188777/public_html/x/admin0181eyzql/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run()
#32 {main}

I am looking for a way to have Polish language for the backend. Maybe it is possible to forcibly overwrite the translation?

Edited October 30, 2023 by Thommen (see edit history)

[musicmaster]

The backend language is a setting of the employee. So go there in the backoffice.

[Thommen]

In my case, I had to download the translation again. Then I had to update the language.