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 ?
Ich hatte gestern zum Testen das Paypal Modul installiert, und gerade zum testen auch wieder deinstalliert. Kann das damit zusammenhängen ?
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…
Kennt sich keiner mit dem SQL-Skript dafür aus ?
[...] LEFT JOIN WHERE [...] Da fehlt definitiv die Hälfte. Hier müsste man erst untersuchen, warum die Angabe der Tabelle fehlt. Viele Grüße
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 ?
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 ?
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?
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?
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…
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”]:
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 ???
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
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}
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}
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
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…
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 ?!