# SQL Fehler beim Statuswechsel von Bestellungen
**URL:** https://forum.shopware.com/t/sql-fehler-beim-statuswechsel-von-bestellungen/89800
**Category:** Shopware 5
**Created:** [16. August 2021 um 19:26 UTC](https://forum.shopware.com/t/sql-fehler-beim-statuswechsel-von-bestellungen/89800 "2021-08-16T19:26:13Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@premium-dog](https://forum.shopware.com/u/premium-dog)
#### Post date: [16. August 2021 um 19:26 UTC](https://forum.shopware.com/t/sql-fehler-beim-statuswechsel-von-bestellungen/89800/1 "2021-08-16T19:26:13Z")
Diesen Fehler bekomme ich, wenn ich einen Status umstellen will bei den Bestellungen:
An exception occurred while executing ‚SELECT t0.id AS id\_1, t0.name AS name\_2, t0.description AS description\_3, t0.template AS template\_4, t0.class AS class\_5, t0.`table` AS table\_6, t0.hide AS hide\_7, t0.additionaldescription AS additionaldescription\_8, t0.debit\_percent AS debit\_percent\_9, t0.surcharge AS surcharge\_10, t0.surchargestring AS surchargestring\_11, t0.position AS position\_12, t0.active AS active\_13, t0.esdactive AS esdactive\_14, t0.mobile\_inactive AS mobile\_inactive\_15, t0.embediframe AS embediframe\_16, t0.hideprospect AS hideprospect\_17, t0.action AS action\_18, t0.pluginID AS pluginID\_19, t0.source AS source\_20, t21.id AS id\_22, t21.paymentmeanID AS paymentmeanID\_23, t21.blur\_payment\_logo AS blur\_payment\_logo\_24, t21.swag\_paypal\_unified\_display\_in\_plus\_iframe AS swag\_paypal\_unified\_display\_in\_plus\_iframe\_25, t21.swag\_paypal\_unified\_plus\_iframe\_payment\_logo AS swag\_paypal\_unified\_plus\_iframe\_payment\_logo\_26, t21.paymentmeanID AS paymentmeanID\_27, t0.pluginID AS pluginID\_28 FROM s\_core\_paymentmeans t0 LEFT JOIN s\_core\_paymentmeans\_attributes t21 ON t21.paymentmeanID = t0.id WHERE t0.name = ? LIMIT 1‘ with params [„SwagPaymentPayPalUnified“]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚t21.blur\_payment\_logo‘ in ‚field list‘|[image][image]|
---
### Author:  [@R4M](https://forum.shopware.com/u/R4M)
#### Post date: [17. August 2021 um 06:31 UTC](https://forum.shopware.com/t/sql-fehler-beim-statuswechsel-von-bestellungen/89800/2 "2021-08-17T06:31:06Z")
> [@premium-dog](#):
>
> Unknown column ‚t21.blur\_payment\_logo‘
Ja das System versucht auf eine Spalte zuzugreifen, die es aber nicht mehr gibt. Vermutlich mal ein Plugin deinstalliert was nicht korrekt funktionierte. Möglichkeit: Den Cache mal komplett zu löschen (also nicht übers Backend) - - also den Ordner var/cache/production\_xxx komplett per FTP/SSH löschen. Dann schauen ob es geht.
---
### Author:  [@premium-dog](https://forum.shopware.com/u/premium-dog)
#### Post date: [17. August 2021 um 06:36 UTC](https://forum.shopware.com/t/sql-fehler-beim-statuswechsel-von-bestellungen/89800/3 "2021-08-17T06:36:39Z")
Ohhh das hat geholfen :))))
Vielen Dank