Hallo Gemeinde, ich flippe hier völlig aus, seit 3 Stunden versuche ich auf Shopware 5 zu updaten - es funktioniert nicht. Kurze Infos: Habe einen 4.3.6 Shop der bis auf das Plugin Custom Products komplett Standard ist. Standard Template - sonst keine weitere Plugins installiert. Vor dem Update habe ich alle Plugins auf den neusten Stand gebracht. Das Update habe ich nun über den Update Manger als auch manuell versucht. Einmal mit 5.1.1 und einmal mit 5.0.0. Beide Updates resultieren im selben Fehler: Frontend: weiße Seite Backend: Fehlermeldung Plugin Manager [code]
Ups! Ein Fehler ist aufgetreten!
Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
No mapping found for field ‘payment’ on class ‘Shopware\Models\Attribute\Payment’. in vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/MappingException.php on line 153
Stack trace:
#0 vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php(1129): Doctrine\ORM\Mapping\MappingException::mappingNotFound('Shopware\\Models...', 'payment') #1 Doctrine/ORM/Persisters/BasicEntityPersister.php(1297): Doctrine\ORM\Mapping\ClassMetadataInfo-\>getAssociationMapping('payment') #2 Doctrine/ORM/Persisters/BasicEntityPersister.php(1147): Doctrine\ORM\Persisters\BasicEntityPersister-\>getSelectColumnsSQL() #3 Doctrine/ORM/Persisters/BasicEntityPersister.php(1796): Doctrine\ORM\Persisters\BasicEntityPersister-\>getSelectSQL(Array, Array, 0, NULL, NULL) #4 Doctrine/ORM/Persisters/BasicEntityPersister.php(1755): Doctrine\ORM\Persisters\BasicEntityPersister-\>getOneToManyStatement(Array, Object(Shopware\Models\Plugin\Plugin)) #5 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(2792): Doctrine\ORM\Persisters\BasicEntityPersister-\>loadOneToManyCollection(Array, Object(Shopware\Models\Plugin\Plugin), Object(Doctrine\ORM\PersistentCollection)) #6 vendor/doctrine/orm/lib/Doctrine/ORM/PersistentCollection.php(236): Doctrine\ORM\UnitOfWork-\>loadCollection(Object(Doctrine\ORM\PersistentCollection)) #7 vendor/doctrine/orm/lib/Doctrine/ORM/PersistentCollection.php(612): Doctrine\ORM\PersistentCollection-\>initialize() #8 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(2263): Doctrine\ORM\PersistentCollection-\>getIterator() #9 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1688): Doctrine\ORM\UnitOfWork-\>cascadeRemove(Object(Shopware\Models\Plugin\Plugin), Array) #10 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1659): Doctrine\ORM\UnitOfWork-\>doRemove(Object(Shopware\Models\Plugin\Plugin), Array) #11 vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(647): Doctrine\ORM\UnitOfWork-\>remove(Object(Shopware\Models\Plugin\Plugin)) #12 Shopware/Bundle/PluginInstallerBundle/Service/InstallerService.php(398): Doctrine\ORM\EntityManager-\>remove(Object(Shopware\Models\Plugin\Plugin)) #13 Shopware/Plugins/Default/Backend/PluginManager/Controllers/Backend/PluginManager.php(56): Shopware\Bundle\PluginInstallerBundle\Service\InstallerService-\>refreshPluginList() #14 Enlight/Controller/Action.php(150): Shopware\_Controllers\_Backend\_PluginManager-\>preDispatch() #15 Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch('indexAction') #16 Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #17 Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #18 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #20 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #21 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #22 shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main}
[/code] Des weiteren werden die Bestellungen nicht aufgerufen. Hier bekomme ich Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing 'SELECT count(DISTINCT s0\_.id) AS sclr0 FROM s\_order s0\_ LEFT JOIN s\_core\_paymentmeans s1\_ ON s0\_.paymentID = s1\_.id LEFT JOIN s\_core\_states s2\_ ON s0\_.cleared = s2\_.id LEFT JOIN s\_core\_states s3\_ ON s0\_.status = s3\_.id LEFT JOIN s\_order\_billingaddress s4\_ ON s0\_.id = s4\_.orderID LEFT JOIN s\_user s5\_ ON s0\_.userID = s5\_.id LEFT JOIN s\_order\_details s6\_ ON s0\_.id = s6\_.orderID LEFT JOIN s\_core\_countries s7\_ ON s4\_.countryID = s7\_.id LEFT JOIN s\_core\_countries\_states s8\_ ON s4\_.stateID = s8\_.id LEFT JOIN s\_core\_shops s9\_ ON s0\_.subshopID = s9\_.id LEFT JOIN s\_premium\_dispatch s10\_ ON s0\_.dispatchID = s10\_.id LEFT JOIN LEFT JOIN WHERE s0\_.status NOT IN ('-1') AND s0\_.ordernumber IS NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN WHERE s0\_.status NOT IN ('-1') AND s0\_.ordernumber IS NOT NULL' at line 1 in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT count(DI...', Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT count(DI...', Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery-\>execute(NULL, 3) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery-\>getScalarResult() #6 Shopware/Controllers/Backend/Order.php(357): Doctrine\ORM\Tools\Pagination\Paginator-\>count() #7 Shopware/Controllers/Backend/Order.php(330): Shopware\_Controllers\_Backend\_Order-\>getList(NULL, NULL, '0', '20') #8 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Order-\>getListAction() #9 Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch('getListAction') #10 Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 Shopware/Kernel.php(143): Ich habe gehört das man dann die Foreign Keys reparieren soll. Das Script was ich aber downloaden kann läuft in meiner Datenbank nicht durch. Hier kommt Fehler: -- Add missing foreign key ALTER TABLE `s_article_configurator_template_prices_attributes` ADD FOREIGN KEY ( `template_price_id` ) REFERENCES `s_article_configurator_template_prices` ( `id` ) ON DELETE CASCADE ON UPDATE NO ACTION ; MySQL meldet: Dokumentation #1005 - Can't create table 'd0206c90.#sql-8b8\_fe72d' (errno: 150) (Details...) Ich weiss echt nicht mehr weiter - einer von Euch? LG kweb