# An exception occurred while executing CREATE TRIGGER shopwaredata.shipping\_method\_price\_new\_price\_up

**URL:** <https://forum.shopware.com/t/an-exception-occurred-while-executing-create-trigger-shopwaredata-shipping-method-price-new-price-up/72980>\
**Category:** Installation/Einstieg\
**Created:** [24. Februar 2021 um 15:26 UTC](https://forum.shopware.com/t/an-exception-occurred-while-executing-create-trigger-shopwaredata-shipping-method-price-new-price-up/72980 "2021-02-24T15:26:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hashtag\_Assist](https://avatars.discourse-cdn.com/v4/letter/h/e19b73/32.png) [@Hashtag\_Assist](https://forum.shopware.com/u/Hashtag_Assist)\
**Post date:** [24. Februar 2021 um 15:26 UTC](https://forum.shopware.com/t/an-exception-occurred-while-executing-create-trigger-shopwaredata-shipping-method-price-new-price-up/72980/1 "2021-02-24T15:26:14Z")

</div>

Hallo zusammen. Ich versuche momentan Shopware 6 zu installieren.&nbsp;

Setup:

AMD Hexa-Core 6 Cores x 2.8 GHz(3.3 GHz Turbo Core), 16 GB Ram

PHP 7.4.15

-maximale Werte die ich ausprobiert habe-&nbsp;

Memory limit 3GB

max\_execution\_time&nbsp;30000

max\_input\_time&nbsp;60000

post\_max\_size&nbsp;1024M

upload\_max\_filesize 1024M

opcache.enable on

allow\_url\_fopen on

&nbsp;

–Datenbank–

Maria DB&nbsp;

10.3.27-MariaDB-1:10.3.27+maria~bionic

* * *

Bei der Installation kommt es immer wieder zu dem Problem, mit der Fehlermeldung&nbsp;

Error

Received an error message.  
**URL:** &nbsp;importDatabase  
**Message:**

Please try to fix this error and restart the update.

Response

```
 {"valid":false,"errorMsg":"An exception occurred while executing 'CREATE TRIGGER shipping\_method\_price\_new\_price\_update BEFORE UPDATE ON shipping\_method\_price\n FOR EACH ROW\n BEGIN\n IF @TRIGGER\_DISABLED IS NULL OR @TRIGGER\_DISABLED = 0 THEN\n IF (NEW.price != OLD.price OR (NEW.price IS NOT NULL AND OLD.price IS NULL))\n OR (NEW.currency\_id != OLD.currency\_id OR (NEW.currency\_id IS NOT NULL AND OLD.currency\_id IS NULL))\n AND (NEW.currency\_price = OLD.currency\_price OR (NEW.currency\_price IS NULL AND OLD.currency\_price IS NULL)) THEN\n SET NEW.currency\_price = JSON\_OBJECT(\n CONCAT(\"c\", LOWER(HEX(NEW.currency\_id))),\n JSON\_OBJECT(\n \"net\", NEW.price,\n \"gross\", NEW.price,\n \"linked\", false,\n \"currencyId\", LOWER(HEX(NEW.currency\_id))\n )\n );\n ELSEIF (NEW.price = OLD.price OR NEW.price IS NULL)\n AND (NEW.currency\_id = OLD.currency\_id OR NEW.currency\_id IS NULL)\n AND (NEW.currency\_price != OLD.currency\_price OR (OLD.currency\_price IS NULL AND NEW.currency\_price IS NOT NULL)) THEN\n SET NEW.price = JSON\_UNQUOTE(JSON\_EXTRACT(\n NEW.currency\_price,\n CONCAT(\"$.\", JSON\_UNQUOTE(JSON\_EXTRACT(JSON\_KEYS(NEW.currency\_price), \"$[0]\")), \".gross\")\n )) + 0.0;\n\n SET NEW.currency\_id = UNHEX(JSON\_UNQUOTE(JSON\_EXTRACT(\n NEW.currency\_price,\n CONCAT(\"$.\", JSON\_UNQUOTE(JSON\_EXTRACT(JSON\_KEYS(NEW.currency\_price), \"$[0]\")), \".currencyId\")\n )));\n END IF;\n END IF;\n END;':\n\nSQLSTATE[HY000]: General error: 1359 Trigger 'shopwaredata.shipping\_method\_price\_new\_price\_update' already exists"}

```

Leider habe ich online nicht viele Informationen gefunden.  
-Installation mit frisch heruntergeladener zip von der Shopware Website.  
-Extraktion auf server im web root  
-Start des installers  
-Checks alle „grün“

Bin für jede Hilfe dankbar

Beste Grüße!