SW6 Config Issue

Shopware 6 (English)
1

I am testing SW6 on my hosting platform WHC.ca. This installation completed, but having an issue with configuration. As I am new to Shopware I have no clue what this mean or how to fix.

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (bpdesign_growzwerg.sales_channel_domain, CONSTRAINT fk.sales_channel_domain.currency_id FOREIGN KEY (currency_id) REFERENCES currency (id) ON UPDATE CASCADE)
#0 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Install/src/app.php(464): Shopware\Recovery\Install\Service\ShopService->updateShop(Object(Shopware\Recovery\Install\Struct\Shop))
#1 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#2 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#3 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#4 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#5 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#6 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#7 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Install/src/app.php(168): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#8 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#9 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#10 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#11 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#12 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#13 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#14 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
#15 /home/bpdesign/betag.2bpdesign.com/vendor/shopware/recovery/Install/index.php(55): Slim\App->run()
#16 /home/bpdesign/betag.2bpdesign.com/public/recovery/install/index.php(6): require_once(’/home/bpdesign/…’)
#17 {main}

Any suggestions?

2

Hi Scott,
it seems you got some trouble with the currency configuration in your sales channel. Especially the your domain / URL. This part described here: https://docs.shopware.com/en/shopware-6-en/settings/saleschannel#domain.

What are you trying to do when the error is raised?

Markus

3

the problem has been resolved.