Hallo, ich bekomme ständig ein und die selbe fehlermeldung per Mail vom Shop. Das ganze hat ab der 4.0.8 vereinzelt angefangen. nach dem update auf 4.1 kommen die meldungen extrem oft. nahezu Stundenweise. Shop läuft, kann auf alles zugreifen. Immer die leiche Meldung. Kann damit absolut nichts anfangen, was diese bedeutet und wie ich diese abstellen kann. 2013-07-04T04:56:09+02:00 ERR (3): exception ‚PDOException‘ with message ‚SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: ‚ac‘‘ in /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Statement.php(320): Zend_Db_Statement_Pdo->_execute(Array) #2 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT SQL_…’, Array) #4 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT SQL_…’, Array) #5 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Adapter/Abstract.php(736): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’???SELECT SQL_…’, Array) #6 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Adodb.php(247): Zend_Db_Adapter_Abstract->fetchAll(’???SELECT SQL_…’, Array) #7 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Adodb.php(393): Enlight_Components_Adodb->GetAll(’???SELECT SQL_…’, Array) #8 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Adodb.php(410): Enlight_Components_Adodb->callCached(‚GetAll‘, 7200, ‚???SELECT SQL_…‘, false, ‚search_supplier‘) #9 /srv/www/htdocs/web53/html/engine/core/class/sArticles.php(714): Enlight_Components_Adodb->CacheGetAll(7200, ‚???SELECT SQL_…‘, false, ‚search_supplier‘) #10 /srv/www/htdocs/web53/html/engine/Shopware/Controllers/Frontend/Search.php(52): sArticles->sGetArticlesByName(‚a.name ASC‘, ‚‘, ‚supplier‘, ‚2‘) #11 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Action.php(148): Shopware_Controllers_Frontend_Search->supplierSearchAction() #12 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‚supplierSearchA…‘) #13 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #14 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/HttpKernel.php(79): Enlight_Controller_Front->dispatch() #15 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(234): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(403): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(303): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #19 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(158): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /srv/www/htdocs/web53/html/engine/Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 /srv/www/htdocs/web53/html/engine/Library/Enlight/Application.php(192): Shopware_Bootstrap->run() #24 /srv/www/htdocs/web53/html/shopware.php(83): Enlight_Application->run() #25 {main} Next exception ‚Zend_Db_Statement_Exception‘ with message ‚SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: ‚ac‘‘ in /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Statement.php(320): Zend_Db_Statement_Pdo->_execute(Array) #1 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT SQL_…’, Array) #3 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT SQL_…’, Array) #4 /srv/www/htdocs/web53/html/engine/Library/Zend/Db/Adapter/Abstract.php(736): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’???SELECT SQL_…’, Array) #5 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Adodb.php(247): Zend_Db_Adapter_Abstract->fetchAll(’???SELECT SQL_…’, Array) #6 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Adodb.php(393): Enlight_Components_Adodb->GetAll(’???SELECT SQL_…’, Array) #7 /srv/www/htdocs/web53/html/engine/Library/Enlight/Components/Adodb.php(410): Enlight_Components_Adodb->callCached(‚GetAll‘, 7200, ‚???SELECT SQL_…‘, false, ‚search_supplier‘) #8 /srv/www/htdocs/web53/html/engine/core/class/sArticles.php(714): Enlight_Components_Adodb->CacheGetAll(7200, ‚???SELECT SQL_…‘, false, ‚search_supplier‘) #9 /srv/www/htdocs/web53/html/engine/Shopware/Controllers/Frontend/Search.php(52): sArticles->sGetArticlesByName(‚a.name ASC‘, ‚‘, ‚supplier‘, ‚2‘) #10 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Action.php(148): Shopware_Controllers_Frontend_Search->supplierSearchAction() #11 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‚supplierSearchA…‘) #12 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/HttpKernel.php(79): Enlight_Controller_Front->dispatch() #14 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(234): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(403): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(303): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(158): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /srv/www/htdocs/web53/html/engine/Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 /srv/www/htdocs/web53/html/engine/Library/Enlight/Application.php(192): Shopware_Bootstrap->run() #23 /srv/www/htdocs/web53/html/shopware.php(83): Enlight_Application->run() #24 {main}
Hallo, da scheint es um eine Datenbank-Tabellen Bezeichnung „ac“ zu gehen. Wurde evtl. etwas im Bereich des Listings oder der Suche angepasst / verändert? Das scheint sich auf die Suche / Hersteller-Suche zu beziehen. Evtl. beinhaltet auch ein Plugin ein Fehler. Klickt mal auf deiner Detailseite unten auf den Punkt „Weitere Artikel von XXX“ - Evtl. kommt dann auch eine Fehlermeldung. Sebastian
Danke für die Info, aber der Shop selber front. /backend laufen ohne probleme. es geht nur das heidelpayment… plugin nicht zu updaten, da kommt immer eine fehlermeldung ob das backup wieder eingespielt werden soll. plugin ist aber nicht aktiv. heute gibt es dafür aber mal eine andere Meldung per Mail. 2013-07-05T13:19:03+02:00 ERR (3): exception ‚Enlight_Controller_Exception‘ with message ‚Unauthorized‘ in /srv/www/htdocs/web53/html/engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php:213 Stack trace: #0 /srv/www/htdocs/web53/html/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Backend_Auth_Bootstrap->onPreDispatchBackend(Object(Enlight_Event_EventArgs)) #1 /srv/www/htdocs/web53/html/engine/Library/Enlight/Event/EventManager.php(165): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Event_EventArgs)) #2 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Action.php(128): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Array) #3 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‚getVisitorsActi…‘) #4 /srv/www/htdocs/web53/html/engine/Library/Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #5 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/HttpKernel.php(79): Enlight_Controller_Front->dispatch() #6 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #7 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(234): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #8 /srv/www/htdocs/web53/html/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(230): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #9 /srv/www/htdocs/web53/html/engine/Shopware/Components/HttpCache/AppCache.php(99): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #10 /srv/www/htdocs/web53/html/engine/Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #11 /srv/www/htdocs/web53/html/engine/Library/Enlight/Application.php(192): Shopware_Bootstrap->run() #12 /srv/www/htdocs/web53/html/shopware.php(83): Enlight_Application->run() #13 {main}
Ich habe selbiges Problem. Der Fehler: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'ac' in Zend/Db/Statement/Pdo.php on line 234 Stack trace: #0 Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT SQL\_...', Array) #3 Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT SQL\_...', Array) #4 Zend/Db/Adapter/Abstract.php(736): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('????SELECT SQL\_...', Array) #5 Enlight/Components/Adodb.php(247): Zend\_Db\_Adapter\_Abstract-\>fetchAll('????SELECT SQL\_...', Array) #6 Enlight/Components/Adodb.php(393): Enlight\_Components\_Adodb-\>GetAll('????SELECT SQL\_...', Array) #7 Enlight/Components/Adodb.php(410): Enlight\_Components\_Adodb-\>callCached('GetAll', 86400, '????SELECT SQL\_...', false, 'search\_supplier') #8 engine/core/class/sArticles.php(714): Enlight\_Components\_Adodb-\>CacheGetAll(86400, '????SELECT SQL\_...', false, 'search\_supplier') #9 Shopware/Controllers/Frontend/Search.php(52): sArticles-\>sGetArticlesByName('a.name ASC', '', 'supplier', '3') #10 Enlight/Controller/Action.php(148): Shopware\_Controllers\_Frontend\_Search-\>supplierSearchAction() #11 Enlight/Controller/Dispatcher/Default.php(521): Enlight\_Controller\_Action-\>dispatch('supplierSearchA...') #12 Enlight/Controller/Front.php(214): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 Shopware/Components/HttpCache/HttpKernel.php(79): Enlight\_Controller\_Front-\>dispatch() #14 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 Shopware/Components/HttpCache/AppCache.php(234): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(403): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(303): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 Shopware/Components/HttpCache/AppCache.php(158): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #22 Enlight/Application.php(192): Shopware\_Bootstrap-\>run() Tritt auf, wenn ich versuche, nach allen Artikeln eines Herstellers zu suchen. Das Problem tritt erst jetz nach Update auf 4.1 auf. Die search.php ist unverändert! Wo könnte der Fehler liegen?
Hallo zusammen, wir konnten den Fehler nachstellen und auch beheben. Der Fehler wird mit der 4.1.1 gefixt sein. Hier der Hotfix welche den Fehler behebt: Datei: [size=150]templates/_default/frontend/detail/description.tpl[/size] Block: [size=150]frontend_detail_description_links (Für eigene Templates)[/size] Vorher: [{se name="DetailDescriptionLinkInformation"}{/se}]({$information.link}) Fix: [{se name="DetailDescriptionLinkInformation"}{/se}]({url controller='cat' sCategory=$sCategoryStart sPage=1 sSupplier=$sArticle.supplierID}) Die Funktion supplierSearchAction des Frontend Search Controllers ist nun als deprecated markiert. Statt diese Funktion zu verwenden, kann einfach die indexAction des Frontend Listing Controllers aufgerufen werden. Diese Funktion erwartet die SupplierID im Request Parameter sSupplier. [size=130]Wichtig: Dieses Verhalten tritt nur im alten Template auf. Templates die auf dem _emotion Template aufbauen (und das _emotion Template selbst) besitzen bereits das richtige Verhalten.[/size] Hoffe das hilft euch weiter Mit freundlichen Grüßen Oliver Denter
Hallo Ich bekomme in der Version 4.2.1 folgende Email 3x: [2014-04-06 19:27:45] core.ERROR: exception 'Enlight\_Controller\_Exception' with message 'Unauthorized' in /var/www/KD01/htdocs/dildo-discount.com/engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php:203 Stack trace: #0 /var/www/KD01/htdocs/dildo-discount.com/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>onPreDispatchBackend(Object(Enlight\_Controller\_ActionEventArgs)) #1 /var/www/KD01/htdocs/dildo-discount.com/engine/Library/Enlight/Event/EventManager.php(211): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Controller\_ActionEventArgs)) #2 /var/www/KD01/htdocs/dildo-discount.com/engine/Library/Enlight/Controller/Action.php(138): Enlight\_Event\_EventManager-\>notify('Enlight\_Control...', Object(Enlight\_Controller\_ActionEventArgs)) #3 /var/www/KD01/htdocs/dildo-discount.com/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('getTurnOverVisi...') #4 /var/www/KD01/htdocs/dildo-discount.com/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #5 /var/www/KD01/htdocs/dildo-discount.com/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #6 /var/www/KD01/htdocs/dildo-discount.com/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #7 /var/www/KD01/htdocs/dildo-discount.com/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #8 /var/www/KD01/htdocs/dildo-discount.com/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(244): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #9 /var/www/KD01/htdocs/dildo-discount.com/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #10 /var/www/KD01/htdocs/dildo-discount.com/shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #11 {main}... in meiner Datei steht folgenes: [{$information.description}]({$information.link}) Ich benutze das „_emotion_pink“ Template. Kann mir jemand sagen wo der Fehler liegt? Vielen Dank