pdf Belege werden nicht angezeigt Fehler

Hallo zusammen,

ich bin mit der Version 5.5.6 auf einen neuen Server/Hoster umgezogen.

Bei Aufruf einer Rechnung/pdf werden mir nun Fehler angezeigt.

Bei Rechnungen vor dem Umzug wird beim Aufruf folgendes angezeigt

{“success”:false,“data”:{“id”:“d682ddd1928dbaa28a516ad51277e68c”,“module”:“backend”,“controller”:“Order”,“action”:“openPdf”},“message”:“File not exist”,“showOrderChannel”:false}

 

Einer Rechnung nach dem Umzug wird folgendes angezeigt

Ups! Ein Fehler ist aufgetreten!

Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.

Could not resolve type of column “ID” of class “Shopware\Models\Order\Document\Document” in vendor/doctrine/orm/lib/Doctrine/ORM/Utility/PersisterHelper.php on line 130

Stack trace:

 #0 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1357): Doctrine\ORM\Utility\PersisterHelper::getTypeOfColumn('ID', Object(Doctrine\ORM\Mapping\ClassMetadata), Object(Shopware\Components\Model\ModelManager)) #1 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1270): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>getSelectColumnAssociationSQL('document', Array, Object(Doctrine\ORM\Mapping\ClassMetadata), 'e0') #2 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1100): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>getSelectColumnsSQL() #3 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(912): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>getSelectSQL(Array, NULL, NULL, NULL, NULL, NULL) #4 vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(181): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>loadAll(Array, NULL, NULL, NULL) #5 engine/Shopware/Controllers/Backend/Order.php(1132): Doctrine\ORM\EntityRepository-\>findBy(Array) #6 engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_Order-\>openPdfAction() #7 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch('openPdfAction') #8 engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 engine/Shopware/Kernel.php(202): Enlight\_Controller\_Front-\>dispatch() #10 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #15 shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #16 {main}

 

Im Log steht folgendes drin

RuntimeException: Could not resolve type of column “ID” of class “Shopware\Models\Order\Document\Document” in /vendor/doctrine/orm/lib/Doctrine/ORM/Utility/PersisterHelper.php:130 Stack trace:
#0 /engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1357): Doctrine\ORM\Utility\PersisterHelper::getTypeOfColumn(‘ID’, Object(Doctrine\ORM\Mapping\ClassMetadata), Object(Shopware\Components\Model\ModelManager))
#1 /engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1270): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getSelectColumnAssociationSQL(‘document’, Array, Object(Doctrine\ORM\Mapping\ClassMetadata), ‘e0’)
#2 /engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1100): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getSelectColumnsSQL()
#3 /engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(740): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getSelectSQL(Array, NULL, NULL, 1, NULL, NULL)
#4 /vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(196): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#5 /engine/Shopware/Plugins/Community/Core/ViisonPickwareERP/Subscribers/Components/DocumentComponentSubscriber.php(157): Doctrine\ORM\EntityRepository->findOneBy(Array)
#6 /engine/Library/Enlight/Event/Handler/Default.php(91): Shopware\Plugins\ViisonPickwareERP\Subscribers\Components\DocumentComponentSubscriber->onAfterRender(Object(Enlight_Hook_HookArgs))
#7 /engine/Library/Enlight/Event/EventManager.php(304): Enlight_Event_Handler_Default->execute(Object(Enlight_Hook_HookArgs))
#8 /engine/Library/Enlight/Hook/HookExecutionContext.php(115): Enlight_Event_EventManager->filter(‘Shopware_Compon…’, NULL, Object(Enlight_Hook_HookArgs))
#9 /engine/Library/Enlight/Hook/HookManager.php(185): Enlight_Hook_HookExecutionContext->execute()
#10 /home/luettich/public_html/var/cache/production_201901211535/proxies/ShopwareComponentsDocumentProxy.php(90): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareComponentsDocumentProxy), ‘render’, Array)
#11 /engine/Shopware/Controllers/Backend/Order.php(1808): Shopware_Proxies_ShopwareComponentsDocumentProxy->render()
#12 /engine/Shopware/Controllers/Backend/Order.php(1095): Shopware_Controllers_Backend_Order->createDocument(9528, 1)
#13 /home/luettich/public_html/var/cache/production_201901211535/proxies/ShopwareControllersBackendOrderProxy.php(79): Shopware_Controllers_Backend_Order->createDocumentAction()
#14 /engine/Library/Enlight/Hook/HookExecutionContext.php(141): Shopware_Proxies_ShopwareControllersBackendOrderProxy->__executeOriginalMethod(‘createDocumentA…’, Array)
#15 /engine/Library/Enlight/Hook/HookExecutionContext.php(107): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array)
#16 /engine/Library/Enlight/Hook/HookManager.php(185): Enlight_Hook_HookExecutionContext->execute()
#17 /home/luettich/public_html/var/cache/production_201901211535/proxies/ShopwareControllersBackendOrderProxy.php(198): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersBackendOrderProxy), ‘createDocumentA…’, Array)
#18 /engine/Library/Enlight/Controller/Action.php(193): Shopware_Proxies_ShopwareControllersBackendOrderProxy->createDocumentAction()
#19 /engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‘createDocumentA…’)
#20 /engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#21 /engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch()
#22 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#23 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#24 /engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#25 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#26 /engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#27 /home/luettich/public_html/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#28 {main}

 

Ist da vielleicht beim Umzug etwas verloren gegangen?

Danke für die Hilfe und Grüße

Manfred

Hast du die Datenbank gewechselt?
Vielleicht MariaDB zu MySQL oder umgekehrt?

Du könntest per SSH mal php bin/console sw:migrate:mysql8 versuchen. Das fixt Probleme mti der ID-Colum bei den Belegen. 

1 Like

Das stimmt. Von MySQL zu MariaDB.

Das kann doch bestimmt auch der Hoster für mich machen. Mit dem SSH kenne ich mich nicht mit aus.

Danke

Hallo ich nochmal,

ich habe mich nun selber damit befasst weil ich vom Hoster noch keine Antwort habe.

Der Befehl ’ php bin/console sw:migrate:mysql8 ’ ist doch von MariaDB zu mysql. Wie wäre es denn umgekehrt von mysql zu MariaDB?

 

Danke

Der Befehl hat nichts bewirkt.

php bin/console sw:migrate:mysql8
Migration to MySQL8 compatibility already happened!