Dokumente können nicht mehr erstellt werden nach Update auf 5.6.9

Hallo zusammen, leider stehen wir bei einem Problem mit der Erstellung von Dokumenten an. Nach dem Update auf 5.6.9 können keine Dokumente mehr in den Bestellungen erstellt werden. Im Backend wird folgender Fehler angezeigt: 

Fehler Beim Speichern des Dokuments ist ein Fehler aufgetreten.
Could not resolve type of column “ID” of class "Shopware\Models\Order\Document\Document"

Die Cache Dateien haben wir manuell gelöscht und dies scheint das Problem auch nicht zu lösen. Wir erhalten folgende Fehlermeldung. Kann uns jemand einen Tipp geben? Danke vielmals!

[2020-11-13 12:15:42] core.ERROR: RuntimeException: Could not resolve type of column “ID” of class “Shopware\Models\Order\Document\Document” in

/var/www/vhosts/kundenshop.ch/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Utility/PersisterHelper.php:129 Stack trace: #0 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1461): Doctrine\ORM\Utility\PersisterHelper::getTypeOfColumn() #1 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1378): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getSelectColumnAssociationSQL() #2 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(625): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getSelectColumnsSQL() #3 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(385): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getSelectSQL() #4 /var/www/vhosts/kundenshop.ch/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(193): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load() #5 /var/www/vhosts/kundenshop.ch/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(311): Doctrine\ORM\EntityRepository->findOneBy() #6 /var/www/vhosts/kundenshop.ch/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(228): Doctrine\ORM\EntityRepository->resolveMagicCall() #7 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Components/Document.php(739): Doctrine\ORM\EntityRepository->__call() #8 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Components/Document.php(328): Shopware_Components_Document->saveDocument() #9 /var/www/vhosts/kundenshop.ch/httpdocs/var/cache/production_202011060821/proxies/ShopwareComponentsDocumentProxy.php(79): Shopware_Components_Document->assignValues() #10 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_ShopwareComponentsDocumentProxy->__executeOriginalMethod() #11 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain() #12 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute() #13 /var/www/vhosts/kundenshop.ch/httpdocs/var/cache/production_202011060821/proxies/ShopwareComponentsDocumentProxy.php(90): Enlight_Hook_HookManager->executeHooks() #14 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Components/Document.php(259): Shopware_Proxies_ShopwareComponentsDocumentProxy->assignValues() #15 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Controllers/Backend/Order.php(1874): Shopware_Components_Document->render() #16 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Controllers/Backend/Order.php(1164): Shopware_Controllers_Backend_Order->createDocument() #17 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Order->createDocumentAction() #18 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch() #19 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch() #20 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #21 /var/www/vhosts/kundenshop.ch/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle() #22 /var/www/vhosts/kundenshop.ch/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #23 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #24 /var/www/vhosts/kundenshop.ch/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward() #25 /var/www/vhosts/kundenshop.ch/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass() #26 /var/www/vhosts/kundenshop.ch/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #27 {main} {“uid”:“6183b11”}

 

Wir konnten das Problem beheben!

Für die Nachwelt den Ordner in /var/cache/ löschen sollte helfen

Das war nicht das Problem! Es lag daran, dass das Update 1611-change-order-details-id-column.php nicht richtig durchlief.

ALTER TABLE s_order_documents CHANGE COLUMN ID id_tmp int auto_increment

und danach

ALTER TABLE s_order_documents CHANGE COLUMN id_tmp id int auto_increment

hat das Problem gelöst!