Hallo, von jetzt auf gleich erhalte ich in meinem Shop eine Fehlermeldung. Wenn ich einen Artikel bearbeiten will und auf den Bleistift zum ändern klicken will kommt [quote]Ups! Ein Fehler ist aufgetreten! Wir wurden bereits über das Problem informiert und arbeiten an einer Lösung, bitte versuchen Sie es in Kürze erneut. [/quote] Ich habe Debug aktiviert und in der Log gesucht. Dort bekomme ich folgende Fehler angezeigt: [2014-10-20 14:04:26] core.ERROR: exception 'PDOException' with message '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\_.id = '4353'' at line 1' in /www/htdocs/xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 Stack trace: #0 /www/htdocs/xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(693): PDOStatement-\>execute() #1 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 /www/htdocs/xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1713): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 /www/htdocs/xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(2011): Shopware\_Controllers\_Backend\_Article-\>getArticleData('4353') #7 /www/htdocs/xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('4353') #8 /www/htdocs/xxxx/shopware42/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 /www/htdocs/xxxx/shopware42/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 /www/htdocs/xxxx/shopware42/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /www/htdocs/xxxx/shopware42/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 /www/htdocs/xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /www/htdocs/xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /www/htdocs/xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /www/htdocs/xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 /www/htdocs/xxxx/shopware42/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'SELECT s0\_.id AS id0, s0\_.main\_detail\_id AS main\_detail\_id1, s0\_.supplierID AS supplierID2, s0\_.taxID AS taxID3, s0\_.pricegroupID AS pricegroupID4, s0\_.filtergroupID AS filtergroupID5, s0\_.configurator\_set\_id AS configurator\_set\_id6, s0\_.name AS name7, s0\_.description AS description8, s0\_.description\_long AS description\_long9, s0\_.datum AS datum10, s0\_.active AS active11, s0\_.pseudosales AS pseudosales12, s0\_.topseller AS topseller13, s0\_.keywords AS keywords14, s0\_.metaTitle AS metaTitle15, s0\_.changetime AS changetime16, s0\_.pricegroupActive AS pricegroupActive17, s0\_.laststock AS laststock18, s0\_.crossbundlelook AS crossbundlelook19, s0\_.notification AS notification20, s0\_.template AS template21, s0\_.mode AS mode22, s0\_.available\_from AS available\_from23, s0\_.available\_to AS available\_to24, s1\_.id AS id25, s1\_.articleID AS articleID26, s1\_.unitID AS unitID27, s1\_.ordernumber AS ordernumber28, s1\_.suppliernumber AS suppliernumber29, s1\_.kind AS kind30, s1\_.additionaltext AS additionaltext31, s1\_.active AS active32, s1\_.instock AS instock33, s1\_.stockmin AS stockmin34, s1\_.weight AS weight35, s1\_.width AS width36, s1\_.length AS length37, s1\_.height AS height38, s1\_.ean AS ean39, s1\_.position AS position40, s1\_.minpurchase AS minpurchase41, s1\_.purchasesteps AS purchasesteps42, s1\_.maxpurchase AS maxpurchase43, s1\_.purchaseunit AS purchaseunit44, s1\_.referenceunit AS referenceunit45, s1\_.packunit AS packunit46, s1\_.shippingfree AS shippingfree47, s1\_.releasedate AS releasedate48, s1\_.shippingtime AS shippingtime49, s2\_.id AS id50, s2\_.tax AS tax51, s2\_.description AS description52, s3\_.id AS id53, s3\_.articleID AS articleID54, s3\_.articledetailsID AS articledetailsID55, s3\_.attr1 AS attr156, s3\_.attr2 AS attr257, s3\_.attr3 AS attr358, s3\_.attr4 AS attr459, s3\_.attr5 AS attr560, s3\_.attr6 AS attr661, s3\_.attr7 AS attr762, s3\_.attr8 AS attr863, s3\_.attr9 AS attr964, s3\_.attr10 AS attr1065, s3\_.attr11 AS attr1166, s3\_.attr12 AS attr1267, s3\_.attr13 AS attr1368, s3\_.attr14 AS attr1469, s3\_.attr15 AS attr1570, s3\_.attr16 AS attr1671, s3\_.attr17 AS attr1772, s3\_.attr18 AS attr1873, s3\_.attr19 AS attr1974, s3\_.attr20 AS attr2075, s3\_.article\_Keynet AS article\_Keynet76 FROM s\_articles s0\_ LEFT JOIN s\_articles\_details s1\_ ON s0\_.main\_detail\_id = s1\_.id LEFT JOIN s\_core\_tax s2\_ ON s0\_.taxID = s2\_.id LEFT JOIN WHERE s0\_.id = ?' with params ["4353"]: 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\_.id = '4353'' at line 1' in /www/htdocs/xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /www/htdocs/xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT s0\_.id A...', Array) #1 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 /www/htdocs/xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 /www/htdocs/xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1713): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 /www/htdocs/xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(2011): Shopware\_Controllers\_Backend\_Article-\>getArticleData('4353') #7 /www/htdocs/xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('4353') #8 /www/htdocs/xxxx/shopware42/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 /www/htdocs/xxxx/shopware42/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 /www/htdocs/xxxx/shopware42/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /www/htdocs/xxxx/shopware42/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 /www/htdocs/xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /www/htdocs/xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /www/htdocs/xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /www/htdocs/xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 /www/htdocs/xxxx/shopware42/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} [] {"uid":"17ee407"} Der Fehler kam von jetzt auf gleich, vor einer Woche ging noch alles ohne Probleme. Kann mir wer helfen?
Konnte das Problem lösen - einfach Shopcache leeren. K.A. wieso dieser Fehler kam.
Hallo, nix ist gelöst. Das Problem kommt immer wieder nach ein paar Stunden. Cache leeren und es geht wieder für eine Weile, dann kommt der Fehler wieder. Ich hoffe jemand kann helfen.
Hallo, ich bin nach wievor mit diesem Problem am verzweifeln. Ich möchte einen Artikel bearbeiten und es kommt die Meldung: „Ups! Ein Fehler ist aufgetreten! Wir wurden bereits über das Problem informiert und arbeiten an einer Lösung, bitte versuchen Sie es in Kürze erneut.“ Das bleibt so lange bis ich den Cache komplett lösche, dann funktioniert es wieder - bis zu einer geraumen Zeit, dann kommt der Fehler wieder. In der Logs wird dazu ausgespuckt: [2015-02-10 21:39:16] core.ERROR: exception 'PDOException' with message '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\_.id = '4353'' at line 1' in /www/htdocs/xxxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 Stack trace: #0 /www/htdocs/xxxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(693): PDOStatement-\>execute() #1 /www/htdocs/xxxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 /www/htdocs/xxxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /www/htdocs/xxxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 /www/htdocs/xxxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 /www/htdocs/xxxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1713): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 /www/htdocs/xxxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(2011): Shopware\_Controllers\_Backend\_Article-\>getArticleData('4353') #7 /www/htdocs/xxxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('4353') #8 /www/htdocs/xxxxx/shopware42/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 /www/htdocs/xxxxx/shopware42/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 /www/htdocs/xxxxx/shopware42/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /www/htdocs/xxxxx/shopware42/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 /www/htdocs/xxxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /www/htdocs/xxxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /www/htdocs/xxxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /www/htdocs/xxxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 /www/htdocs/xxxxx/shopware42/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'SELECT s0\_.id AS id0, s0\_.main\_detail\_id AS main\_detail\_id1, s0\_.supplierID AS supplierID2, s0\_.taxID AS taxID3, s0\_.pricegroupID AS pricegroupID4, s0\_.filtergroupID AS filtergroupID5, s0\_.configurator\_set\_id AS configurator\_set\_id6, s0\_.name AS name7, s0\_.description AS description8, s0\_.description\_long AS description\_long9, s0\_.datum AS datum10, s0\_.active AS active11, s0\_.pseudosales AS pseudosales12, s0\_.topseller AS topseller13, s0\_.keywords AS keywords14, s0\_.metaTitle AS metaTitle15, s0\_.changetime AS changetime16, s0\_.pricegroupActive AS pricegroupActive17, s0\_.laststock AS laststock18, s0\_.crossbundlelook AS crossbundlelook19, s0\_.notification AS notification20, s0\_.template AS template21, s0\_.mode AS mode22, s0\_.available\_from AS available\_from23, s0\_.available\_to AS available\_to24, s1\_.id AS id25, s1\_.articleID AS articleID26, s1\_.unitID AS unitID27, s1\_.ordernumber AS ordernumber28, s1\_.suppliernumber AS suppliernumber29, s1\_.kind AS kind30, s1\_.additionaltext AS additionaltext31, s1\_.active AS active32, s1\_.instock AS instock33, s1\_.stockmin AS stockmin34, s1\_.weight AS weight35, s1\_.width AS width36, s1\_.length AS length37, s1\_.height AS height38, s1\_.ean AS ean39, s1\_.position AS position40, s1\_.minpurchase AS minpurchase41, s1\_.purchasesteps AS purchasesteps42, s1\_.maxpurchase AS maxpurchase43, s1\_.purchaseunit AS purchaseunit44, s1\_.referenceunit AS referenceunit45, s1\_.packunit AS packunit46, s1\_.shippingfree AS shippingfree47, s1\_.releasedate AS releasedate48, s1\_.shippingtime AS shippingtime49, s2\_.id AS id50, s2\_.tax AS tax51, s2\_.description AS description52, s3\_.id AS id53, s3\_.articleID AS articleID54, s3\_.articledetailsID AS articledetailsID55, s3\_.attr1 AS attr156, s3\_.attr2 AS attr257, s3\_.attr3 AS attr358, s3\_.attr4 AS attr459, s3\_.attr5 AS attr560, s3\_.attr6 AS attr661, s3\_.attr7 AS attr762, s3\_.attr8 AS attr863, s3\_.attr9 AS attr964, s3\_.attr10 AS attr1065, s3\_.attr11 AS attr1166, s3\_.attr12 AS attr1267, s3\_.attr13 AS attr1368, s3\_.attr14 AS attr1469, s3\_.attr15 AS attr1570, s3\_.attr16 AS attr1671, s3\_.attr17 AS attr1772, s3\_.attr18 AS attr1873, s3\_.attr19 AS attr1974, s3\_.attr20 AS attr2075, s3\_.article\_Keynet AS article\_Keynet76 FROM s\_articles s0\_ LEFT JOIN s\_articles\_details s1\_ ON s0\_.main\_detail\_id = s1\_.id LEFT JOIN s\_core\_tax s2\_ ON s0\_.taxID = s2\_.id LEFT JOIN WHERE s0\_.id = ?' with params ["4353"]: Weiss keiner weiter wie ich das in den Griff bekomme? kweb