# Artikelbewertung

**URL:** https://forum.shopware.com/t/artikelbewertung/40137
**Category:** Sonstiges
**Created:** [27. September 2016 um 10:07 UTC](https://forum.shopware.com/t/artikelbewertung/40137 "2016-09-27T10:07:35Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![whim](https://avatars.discourse-cdn.com/v4/letter/w/848f3c/32.png) [@whim](https://forum.shopware.com/u/whim)
#### Post date: [27. September 2016 um 10:07 UTC](https://forum.shopware.com/t/artikelbewertung/40137/1 "2016-09-27T10:07:35Z")

</div>

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?&nbsp;

Vielen Dank im Voraus!

---

<div class="post-metadata">

### Author: ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)
#### Post date: [27. September 2016 um 17:34 UTC](https://forum.shopware.com/t/artikelbewertung/40137/2 "2016-09-27T17:34:31Z")

</div>

Du kannst dir am besten mal die Fehlermeldung ausgeben lassen: [http://community.shopware.com/Fehlermeldungen-in-Shopware-debuggen\_detail\_1880.html](http://community.shopware.com/Fehlermeldungen-in-Shopware-debuggen_detail_1880.html)

Dann kann man ggf. besser helfen.

---

<div class="post-metadata">

### Author: ![whim](https://avatars.discourse-cdn.com/v4/letter/w/848f3c/32.png) [@whim](https://forum.shopware.com/u/whim)
#### Post date: [27. September 2016 um 17:53 UTC](https://forum.shopware.com/t/artikelbewertung/40137/3 "2016-09-27T17:53:09Z")

</div>

Danke für die Antwort! Ich hoffe es ist das was Du brauchst:

&nbsp;

**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}

&nbsp;

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}

---

<div class="post-metadata">

### Author: ![whim](https://avatars.discourse-cdn.com/v4/letter/w/848f3c/32.png) [@whim](https://forum.shopware.com/u/whim)
#### Post date: [27. September 2016 um 17:53 UTC](https://forum.shopware.com/t/artikelbewertung/40137/4 "2016-09-27T17:53:56Z")

</div>

**Time:**

2016-09-27T19:46:42.274252+0200

**Channel:**

core

**request:**

{

&nbsp; &nbsp; “uri”: “/hardware/playstation-hardware/playstation-4-slim-500gb?action=rating”,

&nbsp; &nbsp; “method”: “POST”,

&nbsp; &nbsp; “query”: {

&nbsp; &nbsp; &nbsp; &nbsp; “action”: “rating”,

&nbsp; &nbsp; &nbsp; &nbsp; “module”: “frontend”,

&nbsp; &nbsp; &nbsp; &nbsp; “controller”: “detail”,

&nbsp; &nbsp; &nbsp; &nbsp; “sArticle”: “86”,

&nbsp; &nbsp; &nbsp; &nbsp; “rewriteUrl”: “1”

&nbsp; &nbsp; },

&nbsp; &nbsp; “post”: {

&nbsp; &nbsp; &nbsp; &nbsp; “sVoteName”: “Name”,

&nbsp; &nbsp; &nbsp; &nbsp; “sVoteSummary”: “Zusammenfassung”,

&nbsp; &nbsp; &nbsp; &nbsp; “sVoteStars”: “10”,

&nbsp; &nbsp; &nbsp; &nbsp; “sVoteComment”: “Bewertung”,

&nbsp; &nbsp; &nbsp; &nbsp; “sRand”: “oMG2s1nVFQnvBIsMtxVQlD9YCya45PuP”,

&nbsp; &nbsp; &nbsp; &nbsp; “sCaptcha”: “2b8ec”,

&nbsp; &nbsp; &nbsp; &nbsp; “Submit”: “”,

&nbsp; &nbsp; &nbsp; &nbsp; “\_\_csrf\_token”: “KeMApftCHfphjffF5nlUbucJSUIZmC”

&nbsp; &nbsp; }

}

**session:**

{

&nbsp; &nbsp; “sessionId”: “c88bfaf4b2e06a03f4d87e609a4e308a7183b3b12552f8f46bbb473b7ca2dcea”,

&nbsp; &nbsp; “sArea”: null,

&nbsp; &nbsp; “sCountry”: null,

&nbsp; &nbsp; “sState”: null,

&nbsp; &nbsp; “X-CSRF-Token”: “KeMApftCHfphjffF5nlUbucJSUIZmC”,

&nbsp; &nbsp; “Bot”: false,

&nbsp; &nbsp; “sOutputNet”: false,

&nbsp; &nbsp; “sNotifcationArticleWaitingForOptInApprovement”: null,

&nbsp; &nbsp; “moptMandateData”: null,

&nbsp; &nbsp; “sOrderVariables”: null,

&nbsp; &nbsp; “Admin”: null,

&nbsp; &nbsp; “connectGetBasket”: null,

&nbsp; &nbsp; “sLastArticle”: “86”,

&nbsp; &nbsp; “sArticleCommentInserts”: {

&nbsp; &nbsp; &nbsp; &nbsp; “60”: “5”,

&nbsp; &nbsp; &nbsp; &nbsp; “86”: “6”

&nbsp; &nbsp; },

&nbsp; &nbsp; “sUserId”: null

}

**shopId:**

1

**shopName:**

[whimGames.com](http://whimgames.com/)

---

<div class="post-metadata">

### Author: ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)
#### Post date: [27. September 2016 um 17:56 UTC](https://forum.shopware.com/t/artikelbewertung/40137/5 "2016-09-27T17:56:40Z")

</div>

Hallo,

tippe auf ein Problem mit dem Plugin&nbsp;MadAgeVerificationDE.

Das taucht in den Meldungen auf. Hast du das mal temporär deaktiviert?

Sebastian

---

<div class="post-metadata">

### Author: ![whim](https://avatars.discourse-cdn.com/v4/letter/w/848f3c/32.png) [@whim](https://forum.shopware.com/u/whim)
#### Post date: [27. September 2016 um 18:03 UTC](https://forum.shopware.com/t/artikelbewertung/40137/6 "2016-09-27T18:03:03Z")

</div>

Gerade probiert und jetzt funktionierts.

Nur leider brauchen wir das Plugin, warum pfuscht ein Altersverifizierungsplugin bei den Artikelbewertungen rum?

---

<div class="post-metadata">

### Author: ![Toric](https://avatars.discourse-cdn.com/v4/letter/t/bbe5ce/32.png) [@Toric](https://forum.shopware.com/u/Toric)
#### Post date: [27. September 2016 um 18:24 UTC](https://forum.shopware.com/t/artikelbewertung/40137/7 "2016-09-27T18:24:16Z")

</div>

Ich habe ein ähnliches Problem - hier beschrieben: [https://forum.shopware.com/discussion/40498/abgabe-von-bewertungen-nicht-mehr-moeglich](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…

---

<div class="post-metadata">

### Author: ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)
#### Post date: [27. September 2016 um 19:06 UTC](https://forum.shopware.com/t/artikelbewertung/40137/8 "2016-09-27T19:06:59Z")

</div>

Hi Toric,

deine Meldung ist ja eine ganz andere und sollte jetzt nicht hier mit der Fehlermeldung und dem Plugin vermischt werden…

Sebastian
