# Fehler beim Aufruf der Bestellungen **URL:** \ **Category:** Shopware 3.5\ **Tags:** general\ **Created:** [4. Mai 2014 um 07:43 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077 "2014-05-04T07:43:25Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [4. Mai 2014 um 07:43 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/1 "2014-05-04T07:43:25Z")
Hallo seit heute kommt ein Fehler wenn ich die Bestellungen aufrufen möchte: `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\_shops s8\_ ON s0\_.subshopID = s8\_.id LEFT JOIN s\_premium\_dispatch s9\_ ON s0\_.dispatchID = s9\_.id LEFT JOIN s\_order\_billingaddress\_attributes s10\_ ON s4\_.id = s10\_.billingID 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 '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(701): 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(361): Doctrine\ORM\Tools\Pagination\Paginator-\>count() #7 Shopware/Controllers/Backend/Order.php(334): 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(528): Enlight\_Controller\_Action-\>dispatch('getListAction') #10 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 vendor/symfony/http-` Kennt Ihr das ? ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [4. Mai 2014 um 08:38 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/2 "2014-05-04T08:38:49Z")
Ich hatte gestern zum Testen das Paypal Modul installiert, und gerade zum testen auch wieder deinstalliert. Kann das damit zusammenhängen ? ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [4. Mai 2014 um 11:48 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/3 "2014-05-04T11:48:45Z")
Wenn ich das Ende des SQL-Statement beim SQL-Test mal weglasse: LEFT JOIN WHERE s0\_.status NOT IN (’-1’) AND s0\_.ordernumber IS NOT NULL geht die Abfrage. denke das LEFT JOIN an der Stelle ist nicht richtig oder ? Lasse ich das ebenfalls weg geht es auch… ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [4. Mai 2014 um 14:10 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/4 "2014-05-04T14:10:21Z")
Kennt sich keiner mit dem SQL-Skript dafür aus ? ---
**Author:** ![EikeBrandtWarneke](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@EikeBrandtWarneke](https://forum.shopware.com/u/EikeBrandtWarneke)\ **Post date:** [4. Mai 2014 um 14:22 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/5 "2014-05-04T14:22:58Z")
`[...] LEFT JOIN WHERE [...]` Da fehlt definitiv die Hälfte. Hier müsste man erst untersuchen, warum die Angabe der Tabelle fehlt. Viele Grüße ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [4. Mai 2014 um 21:34 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/6 "2014-05-04T21:34:34Z")
Ja ich habe das auch mal zerpflückt, es scheint so als würde die Schleife abbrechen welche die LEFT JOIN Anweisung “baut”. Und zwar endet es nach “LEFT JOIN s\_order\_billingaddress\_attributes s10\_ ON s4\_.id = s10\_.billingID” Wird in den Feldern der Fehler stecken, oder eher in dem danach ? ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [5. Mai 2014 um 06:43 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/7 "2014-05-05T06:43:29Z")
Ich habe vor paar Tagen zwei Benutzer über das Backend erstellt, und für die Bestellungen durchgeführt. Kann das damit zusammenhängen ? Was kann ich nun tun um wieder mit dem System arbeiten zu können ? ---
**Author:** ![m.streiber](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@m.streiber](https://forum.shopware.com/u/m.streiber)\ **Post date:** [5. Mai 2014 um 14:01 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/8 "2014-05-05T14:01:23Z")
Hallo, auch bei mir trat dieses Problem auf und ich konnte nicht mehr die Bestellungen im Backend einsehen. Ich dachte erst, dass es an dem update von 4.2.1 auf 4.2.2 lag, welches ja auch Fehler produzierte. Nachdem ich dann die Vollversion der 4.2.3 installierte und die Datenbank importierte hatte ich keine Fehler mehr. Somit spielte ich die Daten meiner gesicherten Datenbank ein. Hier funktionierte ebenfalls alles ohne Probleme. Bis ich dann Plugins installierte. Gestern trat der Fehle nach der Installation des Paypal Plugins auf. Schwups eine Fehlermeldung jagt die nächste. Keine Bestellungen mehr einsehbar und kein Frontend mehr sichtbar. Alles futsch. Wo liegt hier denn das Problem? ---
**Author:** ![m.streiber](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@m.streiber](https://forum.shopware.com/u/m.streiber)\ **Post date:** [5. Mai 2014 um 14:01 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/9 "2014-05-05T14:01:29Z")
Hallo, auch bei mir trat dieses Problem auf und ich konnte nicht mehr die Bestellungen im Backend einsehen. Ich dachte erst, dass es an dem update von 4.2.1 auf 4.2.2 lag, welches ja auch Fehler produzierte. Nachdem ich dann die Vollversion der 4.2.3 installierte und die Datenbank importierte hatte ich keine Fehler mehr. Somit spielte ich die Daten meiner gesicherten Datenbank ein. Hier funktionierte ebenfalls alles ohne Probleme. Bis ich dann Plugins installierte. Gestern trat der Fehle nach der Installation des Paypal Plugins auf. Schwups eine Fehlermeldung jagt die nächste. Keine Bestellungen mehr einsehbar und kein Frontend mehr sichtbar. Alles futsch. Wo liegt hier denn das Problem? ---
**Author:** ![m.streiber](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@m.streiber](https://forum.shopware.com/u/m.streiber)\ **Post date:** [5. Mai 2014 um 22:38 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/10 "2014-05-05T22:38:24Z")
Also nun nach einem Tag testen das selbe Problem: core.ERROR: exception ‚PDOException‘ with message ‚SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s5\_.lb\_layout\_id‘ in ‚field list‘‘ in /shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 hab echt keine Ahnung mehr wo das Problem liegt und wie ich es herausfinden kann… ---
**Author:** ![m.streiber](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@m.streiber](https://forum.shopware.com/u/m.streiber)\ **Post date:** [5. Mai 2014 um 22:43 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/11 "2014-05-05T22:43:59Z")
Na wird immer besser: Next exception ‘Doctrine\DBAL\DBALException’ with message 'An exception occurred while executing ‘SELECT s0\_.id AS id0, s0\_.ordernumber AS ordernumber1, s0\_.userID AS userID2, s0\_.status AS status3, s0\_.cleared AS cleared4, s0\_.paymentID AS paymentID5, s0\_.dispatchID AS dispatchID6, s0\_.partnerID AS partnerID7, s0\_.subshopID AS subshopID8, s0\_.invoice\_amount AS invoice\_amount9, s0\_.invoice\_amount\_net AS invoice\_amount\_net10, s0\_.invoice\_shipping AS invoice\_shipping11, s0\_.invoice\_shipping\_net AS invoice\_shipping\_net12, s0\_.ordertime AS ordertime13, s0\_.transactionID AS transactionID14, s0\_.comment AS comment15, s0\_.customercomment AS customercomment16, s0\_.internalcomment AS internalcomment17, s0\_.net AS net18, s0\_.taxfree AS taxfree19, s0\_.temporaryID AS temporaryID20, s0\_.referer AS referer21, s0\_.cleareddate AS cleareddate22, s0\_.trackingcode AS trackingcode23, s0\_.language AS language24, s0\_.currency AS currency25, s0\_.currencyfactor AS currencyfactor26, s0\_.remote\_addr AS remote\_addr27, s1\_.ID AS ID28, s1\_.date AS date29, s1\_.type AS type30, s1\_.userID AS userID31, s1\_.orderID AS orderID32, s1\_.amount AS amount33, s1\_.docID AS docID34, s1\_.hash AS hash35, s2\_.id AS id36, s2\_.name AS name37, s2\_.template AS template38, s2\_.numbers AS numbers39, s2\_.left AS left40, s2\_.right AS right41, s2\_.top AS top42, s2\_.bottom AS bottom43, s2\_.pagebreak AS pagebreak44, s3\_.id AS id45, s3\_.documentID AS documentID46, s4\_.id AS id47, s4\_.orderID AS orderID48, s4\_.articleID AS articleID49, s4\_.taxID AS taxID50, s4\_.tax\_rate AS tax\_rate51, s4\_.status AS status52, s4\_.ordernumber AS ordernumber53, s4\_.articleordernumber AS articleordernumber54, s4\_.price AS price55, s4\_.quantity AS quantity56, s4\_.name AS name57, s4\_.shipped AS shipped58, s4\_.shippedgroup AS shippedgroup59, s4\_.releasedate AS releasedate60, s4\_.modus AS modus61, s4\_.esdarticle AS esdarticle62, s4\_.config AS config63, s5\_.id AS id64, s5\_.detailID AS detailID65, s5\_.attribute1 AS attribute166, s5\_.attribute2 AS attribute267, s5\_.attribute3 AS attribute368, s5\_.attribute4 AS attribute469, s5\_.attribute5 AS attribute570, s5\_.attribute6 AS attribute671, s5\_.lb\_layout\_id AS lb\_layout\_id72, s5\_.lb\_layout\_options AS lb\_layout\_options73, s6\_.id AS id74, s6\_.paymentID AS paymentID75, s6\_.customergroup AS customergroup76, s6\_.subshopID AS subshopID77, s6\_.pricegroupID AS pricegroupID78, s6\_.encoder AS encoder79, s6\_.password AS password80, s6\_.active AS active81, s6\_.email AS email82, s6\_.firstlogin AS firstlogin83, s6\_.lastlogin AS lastlogin84, s6\_.accountmode AS accountmode85, s6\_.confirmationkey AS confirmationkey86, s6\_.sessionID AS sessionID87, s6\_.newsletter AS newsletter88, s6\_.validation AS validation89, s6\_.affiliate AS affiliate90, s6\_.paymentpreset AS paymentpreset91, s6\_.language AS language92, s6\_.referer AS referer93, s6\_.internalcomment AS internalcomment94, s6\_.failedlogins AS failedlogins95, s6\_.lockedUntil AS lockedUntil96, s7\_.id AS id97, s7\_.userID AS userID98, s7\_.account AS account99, s7\_.bankcode AS bankcode100, s7\_.bankname AS bankname101, s7\_.bankholder AS bankholder102, s8\_.id AS id103, s8\_.firstname AS firstname104, s8\_.lastname AS lastname105, s8\_.address AS address106, s8\_.zipcode AS zipcode107, s8\_.city AS city108, s8\_.bank\_name AS bank\_name109, s8\_.bank\_code AS bank\_code110, s8\_.account\_number AS account\_number111, s8\_.account\_holder AS account\_holder112, s8\_.bic AS bic113, s8\_.iban AS iban114, s8\_.amount AS amount115, s8\_.created\_at AS created\_at116, s9\_.id AS id117, s9\_.orderID AS orderID118, s9\_.countryID AS countryID119, s9\_.userID AS userID120, s9\_.company AS company121, s9\_.department AS department122, s9\_.salutation AS salutation123, s9\_.firstname AS firstname124, s9\_.lastname AS lastname125, s9\_.street AS street126, s9\_.streetnumber AS streetnumber127, s9\_.zipcode AS zipcode128, s9\_.city AS city129, s10\_.id AS id130, s10\_.shippingID AS shippingID131, s10\_.text1 AS text1132, s10\_.text2 AS text2133, s10\_.text3 AS text3134, s10\_.text4 AS text4135, s10\_.text5 AS text5136, s10\_.text6 AS text6137, s11\_.id AS id138, s11\_.countryname AS countryname139, s11\_.countryiso AS countryiso140, s11\_.countryen AS countryen141, s11\_.position AS position142, s11\_.notice AS notice143, s11\_.shippingfree AS shippingfree144, s11\_.taxfree AS taxfree145, s11\_.taxfree\_ustid AS taxfree\_ustid146, s11\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked147, s11\_.active AS active148, s11\_.iso3 AS iso3149, s11\_.display\_state\_in\_registration AS display\_state\_in\_registration150, s11\_.force\_state\_in\_registration AS force\_state\_in\_registration151, s11\_.areaID AS areaID152, s12\_.id AS id153, s12\_.main\_id AS main\_id154, s12\_.category\_id AS category\_id155, s12\_.name AS name156, s12\_.title AS title157, s12\_.position AS position158, s12\_.host AS host159, s12\_.base\_path AS base\_path160, s12\_.base\_url AS base\_url161, s12\_.hosts AS hosts162, s12\_.secure AS secure163, s12\_.always\_secure AS always\_secure164, s12\_.secure\_host AS secure\_host165, s12\_.secure\_base\_path AS secure\_base\_path166, s12\_.`default` AS default167, s12\_.active AS active168, s12\_.customer\_scope AS customer\_scope169, s13\_.id AS id170, s13\_.locale AS locale171, s13\_.language AS language172, s13\_.territory AS territory173 FROM s\_order s0\_ LEFT JOIN s\_order\_documents s1\_ ON s0\_.id = s1\_.orderID LEFT JOIN s\_core\_documents s2\_ ON s1\_.type = s2\_.id LEFT JOIN s\_order\_documents\_attributes s3\_ ON s1\_.ID = s3\_.documentID LEFT JOIN s\_order\_details s4\_ ON s0\_.id = s4\_.orderID LEFT JOIN s\_order\_details\_attributes s5\_ ON s4\_.id = s5\_.detailID LEFT JOIN s\_user s6\_ ON s0\_.userID = s6\_.id LEFT JOIN s\_user\_debit s7\_ ON s6\_.id = s7\_.userID LEFT JOIN s\_core\_payment\_instance s8\_ ON s0\_.id = s8\_.order\_id LEFT JOIN s\_order\_shippingaddress s9\_ ON s0\_.id = s9\_.orderID LEFT JOIN s\_order\_shippingaddress\_attributes s10\_ ON s9\_.id = s10\_.shippingID LEFT JOIN s\_core\_countries s11\_ ON s9\_.countryID = s11\_.id LEFT JOIN s\_core\_shops s12\_ ON s0\_.language = s12\_.id LEFT JOIN s\_core\_locales s13\_ ON s12\_.locale\_id = s13\_.id WHERE s0\_.ordernumber = ?’ with params [“2715”]: ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [6. Mai 2014 um 20:54 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/12 "2014-05-06T20:54:43Z")
Hallo kann mir jemand der PayPal installiert hat etwas beim debuggen helfen ? Bekommt ihr die gleiche Ausgabe wenn ihr den SQL-Befehl absetzt ? mysql\> select id,name,description,template,class from s\_core\_paymentmeans; ±—±-----------±------------±---------------±---------------+ | id | name | description | template | class | ±—±-----------±------------±---------------±---------------+ | 2 | debit | Lastschrift | debit.tpl | debit.php | | 3 | cash | Nachnahme | cash.tpl | cash.php | | 4 | invoice | Rechnung | invoice.tpl | invoice.php | | 5 | prepayment | Vorkasse | prepayment.tpl | prepayment.php | | 6 | sepa | SEPA | sepa.tpl | sepa | | 7 | paypal | PayPal | | | ±—±-----------±------------±---------------±---------------+ 6 rows in set (0.00 sec) Auch finde ich komisch das man Paypal nicht mehr weg bekommt. Man kann es zwar deinstallieren es steht aber immer noch in Zahlungsarten, unter dem Reiter Kunden =\> Zahlungen… Gibt es dafür ein CleanUp ??? ---
**Author:** ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)\ **Post date:** [6. Mai 2014 um 21:15 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/13 "2014-05-06T21:15:06Z")
Hallo, das sieht korrekt aus. Wichtig: bei der Deinstallation des Plugins darf die Zahlungsart nicht gelöscht werden. Das würde bestehende Bestellung mit Paypal beschädigen. Das ist so also absolut korrekt. Evtl. sind deine Datenbank Beziehungen defekt. Such mal im Wiki nach Foreign Keys und führe dort genannte Reparatur durch. Sebastian ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [6. Mai 2014 um 22:02 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/14 "2014-05-06T22:02:34Z")
Habe ich gemacht. Wenn ich den Inhalt unterm Cache\doctrine\attributes leere und dann den Shop aufrufe kommen Fehlermeldungen. Kopiere ich den “gesicherten” Cache zurück ist wieder alle gut… Property Shopware\Models\Attribute\CustomerGroup::$customerGroupId does not exist in vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/RuntimeReflectionService.php on line 79 Stack trace: #0 vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/RuntimeReflectionService.php(79): ReflectionProperty-\>\_\_construct(‘Shopware\Models…’, ‘customerGroupId’) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php(889): Doctrine\Common\Persistence\Mapping\RuntimeReflectionService-\>getAccessibleProperty(‘Shopware\Models…’, ‘customerGroupId’) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(537): Doctrine\ORM\Mapping\ClassMetadataInfo-\>wakeupReflection(Object(Doctrine\Common\Persistence\Mapping\RuntimeReflectionService)) #3 vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php(209): Doctrine\ORM\Mapping\ClassMetadataFactory-\>wakeupReflection(Object(Doctrine\ORM\Mapping\ClassMetadata), Object(Doctrine\Common\Persistence\Mapping\RuntimeReflectionService)) #4 vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(295): Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory-\>getMetadataFor(‘Shopware\Models…’) #5 Doctrine/ORM/Persisters/BasicEntityPersister.php(1269): Doctrine\ORM\EntityManager-\>getClassMetadata(‘Shopware\Models…’) #6 Doctrine/ORM/Persisters/BasicEntityPersister.php(1147): Doctrine\ORM\Persisters\BasicEntityPersister-\>getSelectColumnsSQL() #7 Doctrine/ORM/Persisters/BasicEntityPersister.php(766): Doctrine\ORM\Persisters\BasicEntityPersister-\>getSelectSQL(Array, NULL, 0, NULL, NULL, NULL) #8 vendor/doctrine/orm/lib/Doctrine/ORM/Proxy/ProxyFactory.php(172): Doctrine\ORM\Persisters\BasicEntityPersister-\>load(Array, Object(Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group)) #9 cache/doctrine/proxies/201404291539/\_\_CG\_\_ShopwareModelsCustomerGroup.php(208): Doctrine\ORM\Proxy{closure}(Object(Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group), ‘getKey’, Array) #10 cache/doctrine/proxies/201404291539/\_\_CG\_\_ShopwareModelsCustomerGroup.php(208): Closure-\>\_\_invoke(Object(Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group), ‘getKey’, Array) #11 Shopware/Plugins/Default/Core/System/Bootstrap.php(102): Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group-\>getKey() #12 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_System\_Bootstrap::onInitResourceSystem(Object(Enlight\_Event\_EventArgs)) #13 Enlight/Event/EventManager.php(252): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #14 Shopware/Components/DependencyInjection/Container.php(247): Enlight\_Event\_EventManager-\>notifyUntil(‘Enlight\_Bootstr…’, Array) #15 Shopware/Components/DependencyInjection/Container.php(142): Shopware\Components\DependencyInjection\Container-\>load(‘system’) #16 Shopware/Bootstrap.php(124): Shopware\Components\DependencyInjection\Container-\>has(‘System’) #17 Enlight/Application.php(452): Shopware\_Bootstrap-\>hasResource(‘System’) #18 Shopware/Plugins/Default/Core/System/Bootstrap.php(165): Enlight\_Application-\>\_\_call(‘System’, Array) #19 Shopware/Plugins/Default/Core/System/Bootstrap.php(165): Shopware-\>System() #20 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_System\_Bootstrap::onInitResourceModules(Object(Enlight\_Event\_EventArgs)) #21 Enlight/Event/EventManager.php(252): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #22 Shopware/Components/DependencyInjection/Container.php(247): Enlight\_Event\_EventManager-\>notifyUntil(‘Enlight\_Bootstr…’, Array) #23 Shopware/Components/DependencyInjection/Container.php(188): Shopware\Components\DependencyInjection\Container-\>load(‘modules’) #24 Shopware/Bootstrap.php(149): Shopware\Components\DependencyInjection\Container-\>get(‘Modules’) #25 Shopware/Application.php(145): Shopware\_Bootstrap-\>getResource(‘Modules’) #26 Shopware/Controllers/Frontend/Index.php(44): Shopware-\>Modules() #27 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Index-\>indexAction() #28 Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch(‘indexAction’) #29 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #30 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #31 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #32 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #33 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #34 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #35 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #36 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #37 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #38 shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #39 {main} ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [6. Mai 2014 um 22:11 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/15 "2014-05-06T22:11:52Z")
Nun ist er ganz kaputt :’( Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. No mapping found for field ‚customerGroup‘ on class ‚Shopware\Models\Attribute\CustomerGroup‘. 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(1120): Doctrine\ORM\Mapping\MappingException::mappingNotFound(‚Shopware\Models…‘, ‚customerGroup‘) #1 Doctrine/ORM/Persisters/BasicEntityPersister.php(1297): Doctrine\ORM\Mapping\ClassMetadataInfo-\>getAssociationMapping(‚customerGroup‘) #2 Doctrine/ORM/Persisters/BasicEntityPersister.php(1147): Doctrine\ORM\Persisters\BasicEntityPersister-\>getSelectColumnsSQL() #3 Doctrine/ORM/Persisters/BasicEntityPersister.php(766): Doctrine\ORM\Persisters\BasicEntityPersister-\>getSelectSQL(Array, NULL, 0, NULL, NULL, NULL) #4 vendor/doctrine/orm/lib/Doctrine/ORM/Proxy/ProxyFactory.php(172): Doctrine\ORM\Persisters\BasicEntityPersister-\>load(Array, Object(Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group)) #5 cache/doctrine/proxies/201404291539/\_\_CG\_\_ShopwareModelsCustomerGroup.php(208): Doctrine\ORM\Proxy{closure}(Object(Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group), ‚getKey‘, Array) #6 cache/doctrine/proxies/201404291539/\_\_CG\_\_ShopwareModelsCustomerGroup.php(208): Closure-\>\_\_invoke(Object(Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group), ‚getKey‘, Array) #7 Shopware/Plugins/Default/Core/System/Bootstrap.php(102): Shopware\Proxies\_\_CG\_\_\Shopware\Models\Customer\Group-\>getKey() #8 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_System\_Bootstrap::onInitResourceSystem(Object(Enlight\_Event\_EventArgs)) #9 Enlight/Event/EventManager.php(252): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #10 Shopware/Components/DependencyInjection/Container.php(247): Enlight\_Event\_EventManager-\>notifyUntil(‚Enlight\_Bootstr…‘, Array) #11 Shopware/Components/DependencyInjection/Container.php(142): Shopware\Components\DependencyInjection\Container-\>load(‚system‘) #12 Shopware/Bootstrap.php(124): Shopware\Components\DependencyInjection\Container-\>has(‚System‘) #13 Enlight/Application.php(452): Shopware\_Bootstrap-\>hasResource(‚System‘) #14 Shopware/Plugins/Default/Core/System/Bootstrap.php(165): Enlight\_Application-\>\_\_call(‚System‘, Array) #15 Shopware/Plugins/Default/Core/System/Bootstrap.php(165): Shopware-\>System() #16 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_System\_Bootstrap::onInitResourceModules(Object(Enlight\_Event\_EventArgs)) #17 Enlight/Event/EventManager.php(252): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #18 Shopware/Components/DependencyInjection/Container.php(247): Enlight\_Event\_EventManager-\>notifyUntil(‚Enlight\_Bootstr…‘, Array) #19 Shopware/Components/DependencyInjection/Container.php(188): Shopware\Components\DependencyInjection\Container-\>load(‚modules‘) #20 Shopware/Bootstrap.php(149): Shopware\Components\DependencyInjection\Container-\>get(‚Modules‘) #21 Shopware/Application.php(145): Shopware\_Bootstrap-\>getResource(‚Modules‘) #22 Shopware/Controllers/Frontend/Index.php(44): Shopware-\>Modules() #23 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Index-\>indexAction() #24 Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch(‚indexAction‘) #25 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #26 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #27 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #28 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #29 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #30 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #31 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #32 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #33 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #34 shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #35 {main} ---
**Author:** ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)\ **Post date:** [6. Mai 2014 um 22:57 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/16 "2014-05-06T22:57:00Z")
Hallo, da kommt man mit den Meldungen aber schon mal weiter. Der Cache muss sich nämlich automatisch direkt neu aufbauen, sonst ist da grundlegend was nicht in Ordnung. Ggf. wurde auch ein Update nicht vollständig gemacht und das Problem sieht man erst, wenn der Cache mal komplett geleert wird. Gibt es den Ordner Shopware\Models\Attribute\ bei dir? Der darf z.B. nicht existieren, aber deine Umgebung scheint das zu finden. Lief die Korrektur überhaupt sauber in der Datenbank durch? Sebastian ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [6. Mai 2014 um 23:06 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/17 "2014-05-06T23:06:00Z")
Ja lief es. Es scheint ein Datenbank Fehler zu sein. Den Shop neuinstallieren geht schnell. Aber wie kann ich die Config aus der alten DB übernehmen ? Artikel, Kunden, Einstellungen, etc ? Wenn ich die DB komplett importiere kommt der gleiche Fehler im Frontend. Ich bekomme den auch nicht weg. Den Ordner sehe ich nicht… ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [6. Mai 2014 um 23:47 UTC](https://forum.shopware.com/t/fehler-beim-aufruf-der-bestellungen/20077/18 "2014-05-06T23:47:02Z")
So ich habe folgendes getan: - Datenbank gelöscht - shop Ordner gelöscht - Neue Datenbank erstellt (neuer Name “shopware\_lg”) - shop Ordner erstellt - unzip install\_4.2.3.zip - chown www-data.www-data -R shop - chmod 775 -R shop - installation per webbrowser - sicherung der db und des ordners (wer weiß wer weiß ;D) - alles schick bisher - db import alte db - übernahme altes template, media ordner - apache2 restart (cache?!) - es geht alles… - sicherung der db und des ordners (wer weiß ich weiß ;D) - install Paypal modul inkl. API Config - BOING Bestellübersicht hin. - Rücksicherung der db und des ordners (wer weiß wer weiß ;D) - apache2 restart (cache?!) - Alles wieder toll… Das liegt doch nicht an mir ?!