Update von 1.7.6.5 auf 1.7.8.9 schlägt fehl

[Alexpr]

Aufgrund der letzten Sicherheitslücke wollte ich eine 1.7.6.5er Installation auf die neueste 7er mit dem 1-click Modul upgraden. Die Seite läuft auf PHP 7.2. Nach dem Upgrade komme ich nicht mehr aufs Backend und auch das Frontend bringt Fehler.

Cache habe ich geleert. Irgendwie sieht es für mich aus, als ob die Datenbankstruktur nicht aktualisiert wurde. Habe es auch mit PHP 7.3 und 7.4 versucht, daran liegt es nicht.

Der Updateprozess selbst bringt folgende Meldung:

[INTERNAL] /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/doctrine/doctrine-bundle/ConnectionFactory.php line 79 - Doctrine\DBAL\DBALException: An exception occured while establishing a connection to figure out your platform version. You can circumvent this by setting a 'server_version' configuration value For further information have a look at: https://github.com/doctrine/DoctrineBundle/issues/673 #0 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/doctrine/doctrine-bundle/ConnectionFactory.php(50): Doctrine\Bundle\DoctrineBundle\ConnectionFactory->getDatabasePlatform(Object(Doctrine\DBAL\Connection)) #1 /mnt/web111/a2/87/57705387/htdocs/mb-shop/var/cache/prod/ContainerI9g1mn1/appProdProjectContainer.php(2704): Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Symfony\Bridge\Doctrine\ContainerAwareEventManager), Array) #2 /mnt/web111/a2/87/57705387/htdocs/mb-shop/var/cache/prod/ContainerI9g1mn1/appProdProjectContainer.php(2735): ContainerI9g1mn1\appProdProjectContainer->getDoctrine_Dbal_DefaultConnectionService() #3 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php(306): ContainerI9g1mn1\appProdProjectContainer->getDoctrine_Orm_DefaultEntityManagerService() #4 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/ManagerRegistry.php(63): Symfony\Component\DependencyInjection\Container->get('doctrine.orm.de...') #5 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/doctrine/persistence/lib/Doctrine/Persistence/AbstractManagerRegistry.php(204): Symfony\Bridge\Doctrine\ManagerRegistry->getService('doctrine.orm.de...') #6 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/CacheWarmer/ProxyCacheWarmer.php(53): Doctrine\Persistence\AbstractManagerRegistry->getManagers() #7 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/CacheWarmer/CacheWarmerAggregate.php(52): Symfony\Bridge\Doctrine\CacheWarmer\ProxyCacheWarmer->warmUp('/mnt/web111/a2/...') #8 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(686): Symfony\Component\HttpKernel\CacheWarmer\CacheWarmerAggregate->warmUp('/mnt/web111/a2/...') #9 /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(135): Symfony\Component\HttpKernel\Kernel->initializeContainer() #10 /mnt/web111/a2/87/57705387/htdocs/mb-shop/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(76): Symfony\Component\HttpKernel\Kernel->boot() #11 /mnt/web111/a2/87/57705387/htdocs/mb-shop/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(56): PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->initAppKernel() #12 /mnt/web111/a2/87/57705387/htdocs/mb-shop/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(87): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->initConstants() #13 /mnt/web111/a2/87/57705387/htdocs/mb-shop/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(42): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #14 /mnt/web111/a2/87/57705387/htdocs/mb-shop/ps-admin/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #15 {main}

-> nachdem ich mehrfach gescheitert bin die Fehlercodes hier zu posten, habe ich nach Rücksprache mit dem Support alles in ein angefügtes PDF gepackt, da ich sonst immer geblockt werde. Also ab hier geht es im PDF weiter - sorry dafür.

 

Hat vielleicht jemand eine Idee?

Fehlermeldungen.pdf

[rictools]

Sorry, irgendwie traue ich mich nicht, eine Datei von einem brandneuen User zu öffnen, es ist überhaupt kein Problem, den Text einer Fehlermeldung einfach in den Post zu schreiben. Dazu noch eine vorgebliche PDF-Datei, die (für eine Fehlermeldung!) doppelt so groß ist wie ein Prestashop-Rechnungs-PDF ...

[Nickz]

2 hours ago, rictools said:

Sorry,

Quote

[INTERNAL] /mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/doctrine/doctrine-
bundle/ConnectionFactory.php line 79 - Doctrine\DBAL\DBALException: An exception occured while
establishing a connection to figure out your platform version. You can circumvent this by setting a
'server_version' configuration value For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673 #0
/mnt/web111/a2/87/57705387/htdocs/mb-shop/vendor/doctrine/doctrine-
bundle/ConnectionFactory.php(50): Doctrine\Bundle\DoctrineBundle\ConnectionFactory-
>getDatabasePlatform(Object(Doctrine\DBAL\Connection)) #1
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/var/cache/prod/ContainerI9g1mn1/appProdProjectContainer.php(2704):
Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection(Array,
Object(Doctrine\DBAL\Configuration),
Object(Symfony\Bridge\Doctrine\ContainerAwareEventManager), Array) #2
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/var/cache/prod/ContainerI9g1mn1/appProdProjectContainer.php(2735):
ContainerI9g1mn1\appProdProjectContainer->getDoctrine_Dbal_DefaultConnectionService() #3
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php(306):
ContainerI9g1mn1\appProdProjectContainer->getDoctrine_Orm_DefaultEntityManagerService() #4
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/ManagerRegistry.php(63):
Symfony\Component\DependencyInjection\Container->get('doctrine.orm.de...') #5
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/doctrine/persistence/lib/Doctrine/Persistence/AbstractManagerRegistry.php(204):
Symfony\Bridge\Doctrine\ManagerRegistry->getService('doctrine.orm.de...') #6
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/CacheWarmer/ProxyCacheWarmer.p
hp(53): Doctrine\Persistence\AbstractManagerRegistry->getManagers() #7
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/CacheWarmer/CacheWarmer
Aggregate.php(52): Symfony\Bridge\Doctrine\CacheWarmer\ProxyCacheWarmer-
>warmUp('/mnt/web111/a2/...') #8 /mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(686):
Symfony\Component\HttpKernel\CacheWarmer\CacheWarmerAggregate-
>warmUp('/mnt/web111/a2/...') #9 /mnt/web111/a2/87/57705387/htdocs/mb-
shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(135):
Symfony\Component\HttpKernel\Kernel->initializeContainer() #10
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(76):
Symfony\Component\HttpKernel\Kernel->boot() #11 /mnt/web111/a2/87/57705387/htdocs/mb-
shop/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(56):
PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->initAppKernel() #12
/mnt/web111/a2/87/57705387/htdocs/mb-
shop/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(87):
PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->initConstants()
#13 /mnt/web111/a2/87/57705387/htdocs/mb-
shop/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(42):
PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #14/mnt/web111/a2/87/57705387/htdocs/mb-shop/ps-admin/autoupgrade/ajax-upgradetab.php(53):
PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #15 {main}
Beim ersten Versuch ins Frontend zu kommen:
Fatal error: Uncaught Unknown column 'h.active' in 'where clause'
SELECT lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
thrown in /mnt/web111/a2/87/57705387/htdocs/mb-shop/classes/db/Db.php on line 765
Nach dem Anlegen des Feldes "active" geht es erst mal. Aber nach dem Deaktivieren des
Wartungsmodus kommt im Frontend:
[PrestaShopDatabaseException]
Unknown column 'pa.mpn' in 'field list'<br /><br /><pre> SELECT a.`id_attribute`,
a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,
pa.`upc`, pa.`mpn` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` =
a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON
(pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON
(pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop
product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute
AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON
(a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 30
AND pac.`id_product_attribute` = 56 AND agl.`id_lang` = 1</pre>
at line 765 in file classes/db/Db.php
760. if ($webservice_call && $errno) {
761. $dbg = debug_backtrace();
762. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '.
From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql,
97);
763. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
764. if ($sql) {
765. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' .
$sql . '</pre>');766. }
767.
768. throw new PrestaShopDatabaseException($this->getMsgError());
769. }
770. }
DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 7406 - classes/Product.php] - [1 Arguments]
ProductCore::getAttributesParams - [line 5793 - classes/Product.php] - [2 Arguments]
ProductCore::getProductProperties - [line 5874 - classes/Product.php] - [2 Arguments]
ProductCore::getProductsProperties - [line 1069 - classes/Category.php] - [2 Arguments]
CategoryCore->getProducts - [line 88 - src/Adapter/Category/CategoryProductSearchProvider.php] -
[6 Arguments]
PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->getProductsOrCount -
[line 105 - src/Adapter/Category/CategoryProductSearchProvider.php] - [3 Arguments]
PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->runQuery - [line 299 -
modules/ps_featuredproducts/ps_featuredproducts.php] - [2 Arguments]
Ps_FeaturedProducts->getProducts - [line 257 -
modules/ps_featuredproducts/ps_featuredproducts.php]
Ps_FeaturedProducts->getWidgetVariables - [line 243 -
modules/ps_featuredproducts/ps_featuredproducts.php] - [2 Arguments]
Ps_FeaturedProducts->renderWidget - [line 1017 - classes/Hook.php] - [2 Arguments]
HookCore::coreRenderWidget - [line 964 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments]
IndexControllerCore->initContent - [line 306 - classes/controller/Controller.php]
ControllerCore->run - [line 525 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]
Nach der Aktivierung des Debug kommt im Backend:
(4/4) DBALException
An exception occured while establishing a connection to figure out your platform version.
You can circumvent this by setting a 'server_version' configuration value

 

Edited July 13, 2023 by Nickz (see edit history)

[Nickz]

@rictools

Bitte sehr

[Alexpr]

On 7/14/2023 at 1:21 AM, Nickz said:

@rictools

Bitte sehr

Danke Nickz für die Hilfe. Ich wollte halt möglichst umfangreich alle meine Aktionen und die Fehlermeldungen daraus posten.

Leider komme ich bisher immer noch nicht weiter. Mein Update schlägt immer wieder fehl, obwohl ich es mit einer Kopie sogar auf einem anderen Server und mit unterschiedlichen PHP Versionen probiert habe. Eine Seite mit Sicherheitslücken laufen zu lassen fällt mir schwer und ich hoffe, ich finde bald eine Lösung.

Bin für jede Hilfe dankbar.

[Alexpr]

Oder gibt es sogar die Möglichkeit das Update nicht per 1-click Modul zu machen, sondern auf Kommandozeile? Ich finde in der Anleitung aber nur das Upgrade, nicht ein update.

[Nickz]

10 hours ago, Alexpr said:

sondern auf Kommandozeile?

Wo hostest du denn? VPS,Shared; Dedicated? System?

[Alexpr]

Shared bei Strato. Ist der Shop von einem Kumpel. Ich könnte ihn aber auch auf einen besseren Shared Server von mir umziehen um upzugraden.

[Nickz]

Checke mal die Bibliotheken die der Shop haben muss.

Bessere Erfahrungen habe ich bei Contabo gemacht.