Hi liebe Community,
wir haben ein kleines Problem und hoffen jemand von euch kann uns helfen.
Wenn man in unserem Shop eine Artikelbewertung abgibt, wird man direkt danach dem Absenden auf die Fehlerseite ‘Ups, da ist etwas schief gelaufen…’ weitergeleitet.
Die Bewertung wird jedoch trotzdem angenommen, egal ob man sie im Backend erst freischalten muss oder nicht.
Wie können wir einstellen, dass nach der Bewertungsabgabe die richtige Seite erscheint?
Vielen Dank im Voraus!
Du kannst dir am besten mal die Fehlermeldung ausgeben lassen: http://community.shopware.com/Fehlermeldungen-in-Shopware-debuggen_detail_1880.html
Dann kann man ggf. besser helfen.
Danke für die Antwort! Ich hoffe es ist das was Du brauchst:
Message:
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 ‘’ at line 1’ in /html/shopware/engine/Library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /html/shopware/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /html/shopware/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /html/shopware/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT mad_age_…’, Array)
#4 /html/shopware/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT mad_age_…’, Array)
#5 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(828): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‘SELECT mad_age_…’, Array)
#6 /html/shopware/engine/Shopware/Plugins/Community/Frontend/MadAgeVerificationDE/Bootstrap.php(278): Zend_Db_Adapter_Abstract->fetchOne()
#7 /html/shopware/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Frontend_MadAgeVerificationDE_Bootstrap->onActionPostDispatchFrontendDetail(Object(Enlight_Controller_ActionEventArgs))
#8 /html/shopware/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#9 /html/shopware/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs))
#10 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘ratingAction’)
#11 /html/shopware/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#12 /html/shopware/engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch()
#13 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#14 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(275): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(206): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#19 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#20 /html/shopware/shopware.php(101): 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 MySQL server version for the right syntax to use near ‘’ at line 1’ in /html/shopware/engine/Library/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /html/shopware/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /html/shopware/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT mad_age_…’, Array)
#3 /html/shopware/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT mad_age_…’, Array)
#4 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(828): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‘SELECT mad_age_…’, Array)
#5 /html/shopware/engine/Shopware/Plugins/Community/Frontend/MadAgeVerificationDE/Bootstrap.php(278): Zend_Db_Adapter_Abstract->fetchOne()
#6 /html/shopware/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Frontend_MadAgeVerificationDE_Bootstrap->onActionPostDispatchFrontendDetail(Object(Enlight_Controller_ActionEventArgs))
#7 /html/shopware/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#8 /html/shopware/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs))
#9 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘ratingAction’)
#10 /html/shopware/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 /html/shopware/engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch()
#12 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(275): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(206): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 /html/shopware/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 {main}
Time:
2016-09-27T19:46:42.274252+0200
Channel:
core
request:
{
“uri”: “/hardware/playstation-hardware/playstation-4-slim-500gb?action=rating”,
“method”: “POST”,
“query”: {
“action”: “rating”,
“module”: “frontend”,
“controller”: “detail”,
“sArticle”: “86”,
“rewriteUrl”: “1”
},
“post”: {
“sVoteName”: “Name”,
“sVoteSummary”: “Zusammenfassung”,
“sVoteStars”: “10”,
“sVoteComment”: “Bewertung”,
“sRand”: “oMG2s1nVFQnvBIsMtxVQlD9YCya45PuP”,
“sCaptcha”: “2b8ec”,
“Submit”: “”,
“__csrf_token”: “KeMApftCHfphjffF5nlUbucJSUIZmC”
}
}
session:
{
“sessionId”: “c88bfaf4b2e06a03f4d87e609a4e308a7183b3b12552f8f46bbb473b7ca2dcea”,
“sArea”: null,
“sCountry”: null,
“sState”: null,
“X-CSRF-Token”: “KeMApftCHfphjffF5nlUbucJSUIZmC”,
“Bot”: false,
“sOutputNet”: false,
“sNotifcationArticleWaitingForOptInApprovement”: null,
“moptMandateData”: null,
“sOrderVariables”: null,
“Admin”: null,
“connectGetBasket”: null,
“sLastArticle”: “86”,
“sArticleCommentInserts”: {
“60”: “5”,
“86”: “6”
},
“sUserId”: null
}
shopId:
1
shopName:
Hallo,
tippe auf ein Problem mit dem Plugin MadAgeVerificationDE.
Das taucht in den Meldungen auf. Hast du das mal temporär deaktiviert?
Sebastian
Gerade probiert und jetzt funktionierts.
Nur leider brauchen wir das Plugin, warum pfuscht ein Altersverifizierungsplugin bei den Artikelbewertungen rum?
Ich habe ein ähnliches Problem - hier beschrieben: https://forum.shopware.com/discussion/40498/abgabe-von-bewertungen-nicht-mehr-moeglich
Wenn der Kunde bewerten möchte, kommt die Seite Ups… es ist was schiefgelaufen. Ich bekomme aber zumindest zweitweise eine Fehlermail darüber. Öffne ich die Datenbank um die Bewertung zu übertragen, kann man anschließend auch wieder im FE normal bewerten. Nur scheinbar nicht dauerhaft.
Plötzlich gehts, dann wieder nicht…
Hi Toric,
deine Meldung ist ja eine ganz andere und sollte jetzt nicht hier mit der Fehlermeldung und dem Plugin vermischt werden…
Sebastian