# Fehler beim Löschen des Gutschein
**URL:** https://forum.shopware.com/t/fehler-beim-loschen-des-gutschein/69502
**Category:** Administration
**Created:** [10. September 2020 um 10:03 UTC](https://forum.shopware.com/t/fehler-beim-loschen-des-gutschein/69502 "2020-09-10T10:03:17Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@ildiko](https://forum.shopware.com/u/ildiko)
#### Post date: [10. September 2020 um 10:03 UTC](https://forum.shopware.com/t/fehler-beim-loschen-des-gutschein/69502/1 "2020-09-10T10:03:17Z")
Hallo, ich habe ein Plugin für Neukunden-Rabatt installiert, aber da es nicht so war wie ich es mir vorgestellt habe gelöscht. Wollte auch unter „Marketing/Gutscheine“ das Gutschein entfernen - es geht nicht.
Kommt dieser fehlermeldung:
503 - Service Unavailable
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
An exception occurred while executing ‚SELECT s0\_.id AS id\_0, s0\_.description AS description\_1,
s0\_.vouchercode AS vouchercode\_2, s0\_.numberofunits AS numberofunits\_3, s0\_.value AS value\_4,
s0\_.minimumcharge AS minimumcharge\_5, s0\_.shippingfree AS shippingfree\_6, s0\_.bindtosupplier AS bindtosupplier\_7,
s0\_.valid\_from AS valid\_from\_8, s0\_.valid\_to AS valid\_to\_9, s0\_.ordercode AS ordercode\_10, s0\_.modus AS modus\_11,
s0\_.percental AS percental\_12, s0\_.numorder AS numorder\_13, s0\_.customergroup AS customergroup\_14, s0\_.restrictarticles AS restrictarticles\_15,
s0\_.strict AS strict\_16, s0\_.subshopID AS subshopID\_17, s0\_.taxconfig AS taxconfig\_18, s0\_.customer\_stream\_ids AS customer\_stream\_ids\_19, s1\_.id AS id\_20,
s1\_.voucherID AS voucherID\_21, s1\_.newcustomer AS newcustomer\_22, s1\_.voucherID AS voucherID\_23 FROM s\_emarketing\_vouchers s0\_ LEFT JOIN s\_emarketing\_vouchers\_attributes s1\_ ON s0\_.id = s1\_.voucherID WHERE s0\_.id = ?‘ with params [2]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1\_.newcustomer‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 179 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚An exception oc…‘) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT s0\_.id A…‘, Array) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‚SELECT s0\_.id A…‘, Array, Array, NULL) #3 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(968):
Doctrine\ORM\Query-\>\_doExecute() #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(923): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 1) #6 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(765): Doctrine\ORM\AbstractQuery-\>execute(NULL, 1) #7 engine/Shopware/Controllers/Backend/Voucher.php(262): Doctrine\ORM\AbstractQuery-\>getOneOrNullResult(1) #8 engine/Library/Enlight/Controller/Action.php(192): Shopware\_Controllers\_Backend\_Voucher-\>getVoucherDetailAction() #9 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight\_Controller\_Action-\>dispatch(‚getVoucherDetai…‘) #10 engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 engine/Shopware/Kernel.php(188): Enlight\_Controller\_Front-\>dispatch() #12 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel),
Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 engine/Shopware/Components/HttpCache/AppCache.php(261):
Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238):
Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main}
Kann mir jemanden weiterhelfen, wie ich die Gutscheine löschen kann?
DANKESCHÖN!
---
### Author:  [@R4M](https://forum.shopware.com/u/R4M)
#### Post date: [10. September 2020 um 10:33 UTC](https://forum.shopware.com/t/fehler-beim-loschen-des-gutschein/69502/2 "2020-09-10T10:33:11Z")
Mal den kompletten Cache gelöscht?