Error productQuickView

Shopware 5 Allgemein
1

Liebes Forum :slight_smile: :slight_smile:

ich habe eben folgende Fehlermeldung erhalten:

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 MariaDB server version for the right syntax to use near ‚)‘ at line 1‘ in /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‚SELECT * FROM b…‘, Array)
#4 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(‚SELECT * FROM b…‘, Array)
#5 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(776): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‚SELECT * FROM b…‘, Array)
#6 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Plugins/Community/Frontend/kkOptionPictures/Bootstrap.php(228): Zend_Db_Adapter_Abstract->fetchAssoc(‚SELECT * FROM b…‘)
#7 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Frontend_kkOptionPictures_Bootstrap->onPostDispatchDetail(Object(Enlight_Controller_ActionEventArgs))
#8 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#9 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Object(Enlight_Controller_ActionEventArgs))
#10 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚productQuickVie…‘)
#11 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#12 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Kernel.php(177): Enlight_Controller_Front->dispatch()
#13 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#14 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#15 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#19 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#20 /var/www/vhosts/meinshop.de/httpdocs/shopware.php(113): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#21 {main}

Next exception ‚Zend_Db_Statement_Exception‘ 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 MariaDB server version for the right syntax to use near ‚)‘ at line 1‘ in /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‚SELECT * FROM b…‘, Array)
#3 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(‚SELECT * FROM b…‘, Array)
#4 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(776): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‚SELECT * FROM b…‘, Array)
#5 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Plugins/Community/Frontend/kkOptionPictures/Bootstrap.php(228): Zend_Db_Adapter_Abstract->fetchAssoc(‚SELECT * FROM b…‘)
#6 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Frontend_kkOptionPictures_Bootstrap->onPostDispatchDetail(Object(Enlight_Controller_ActionEventArgs))
#7 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#8 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Object(Enlight_Controller_ActionEventArgs))
#9 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚productQuickVie…‘)
#10 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Kernel.php(177): Enlight_Controller_Front->dispatch()
#12 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 /var/www/vhosts/meinshop.de/httpdocs/shopware.php(113): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 {main}
2017-01-22T11:08:23.948906+0100
core
{
    „uri“: „/detail/productQuickView/ordernumber/s20147.2?isXHR=1“,
    „method“: „GET“,
    „query“: {
        „isXHR“: „1“,
        „module“: „frontend“,
        „controller“: „detail“,
        „action“: „productQuickView“,
        „ordernumber“: „s20147.2“
    },
    „post“:
}
No session data available
1
meinshop

Da scheint etwas mit einer „productQuickView“ zu sein. Im habe mal gegoogelt. Quick View scheint es als Plugin zu geben, ein solches Plugin habe ich aber nicht. Als eigenes Plugin sieht man in der Fehlermeldung kkOptionPictures. Kann es daran liegen ?

Was könnte das sein ?

Liebe Grüße

Kerstin

2

Also im Stacktrace ist das Plugin, dass den Fehler verursacht ja erwähnt: Shopware_Plugins_Frontend_kkOptionPictures_Bootstrap

3

Danke. Ja, deswegen bin ich ja darauf gekommen :slight_smile:  Aber es ist ja auch vieles andere erwähnt. Gibt es einen Hinweis darauf, dass es an dem Plugin liegt ?

Was ist die productQuickView (wie gesagt ich habe kein entsprechendes Plugin) ?

4

@Kerstin83 schrieb:

Danke. Ja, deswegen bin ich ja darauf gekommen :)  Aber es ist ja auch vieles andere erwähnt. Gibt es einen Hinweis darauf, dass es an dem Plugin liegt ?

Was ist die productQuickView (wie gesagt ich habe kein entsprechendes Plugin) ?

Hallo,

ja na klar gibt es einen Hinweis darauf, dass es an diesem Plugin liegt (in der Bootstrap.php des genannten Plugins innerhalb einer Datenbankabfrage) - deshalb ist es doch auch in der Fehlermeldung erwähnt. Deaktiviere doch einfach einmal das Plugin, leere den kompletten Shop Cache und schau dann noch einmal nach, ob es dann funktioniert.

Beste Grüße

Sebastian

5

Ich habe mal diese URL eingegeben:

www.meinshop.de/detail/productQuickView/ordernumber/s20147.2?isXHR=1

Und es kommt zu diesem Error, auch bei anderen Artikeln.

Wie kommt man normalerweise dahin (über den Shop) ? 

6

Auch diese URL macht schon einen Fehler:

Die Fehlermeldung:

exception ‚InvalidArgumentException‘ with message ‚Argument ordernumber missing‘ in /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Controllers/Frontend/Detail.php:194
Stack trace:
#0 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Detail->productQuickViewAction()
#1 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚productQuickVie…‘)
#2 /var/www/vhosts/meinshop.de/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#3 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Kernel.php(177): Enlight_Controller_Front->dispatch()
#4 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#5 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#6 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#7 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#8 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#9 /var/www/vhosts/meinshop.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#10 /var/www/vhosts/meinshop.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /var/www/vhosts/meinshop.de/httpdocs/shopware.php(113): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#12 {main}
2017-01-22T14:23:04.706506+0100
core
{
    „uri“: „/detail/productQuickView/“,
    „method“: „GET“,
    „query“: {
        „module“: „frontend“,
        „controller“: „detail“,
        „action“: „productQuickView“
    },
    „post“:
}
No session data available
1
meinshop

In ihr ist das Plugin nicht zu finden…

Liebe Grüße

Kerstin