# SW6 - SQLSTATE\[42S21\] - Coloumn already exsists - Paypal

**URL:** https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747
**Category:** Allgemein
**Created:** [19. Mai 2023 um 19:14 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747 "2023-05-19T19:14:33Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![moellerb92](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@moellerb92](https://forum.shopware.com/u/moellerb92)
#### Post date: [19. Mai 2023 um 19:14 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/1 "2023-05-19T19:14:33Z")

</div>

Moin Zusammen,

wir haben leider nach einer frischen Installation auf 6.5 das Problem, dass wir u.A. kein Paypal installieren können.

Jemand eine Idee, wie wir das kurzfristig gefixt bekommen?

Danke!

FEHLERMELDUNG:

Uncaught PHP Exception Doctrine\DBAL\Exception\NonUniqueFieldNameException: „An exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‚status‘“ at /var/www/vhosts/rr-dsign.net/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 72 {„exception“:„[object] (Doctrine\DBAL\Exception\NonUniqueFieldNameException(code: 1060): An exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‚status‘ at /var/www/vhosts/rr-dsign.net/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:72)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1060): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‚status‘ at /var/www/vhosts/rr-dsign.net/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‚status‘ at /var/www/vhosts/rr-dsign.net/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32)“}

---

<div class="post-metadata">

### Author: ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)
#### Post date: [20. Mai 2023 um 13:52 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/2 "2023-05-20T13:52:00Z")

</div>

Daten aus der Spalte kopieren, Spalte löschen, PayPal installieren, Daten in die Spalte zurück kopieren.

---

<div class="post-metadata">

### Author: ![moellerb92](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@moellerb92](https://forum.shopware.com/u/moellerb92)
#### Post date: [20. Mai 2023 um 16:23 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/3 "2023-05-20T16:23:50Z")

</div>

Du meinst in der Datenbank?

---

<div class="post-metadata">

### Author: ![SmartStylez](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@SmartStylez](https://forum.shopware.com/u/SmartStylez)
#### Post date: [20. Mai 2023 um 20:50 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/4 "2023-05-20T20:50:49Z")

</div>

So sollte es klappen, genau.

---

<div class="post-metadata">

### Author: ![moellerb92](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@moellerb92](https://forum.shopware.com/u/moellerb92)
#### Post date: [21. Mai 2023 um 18:22 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/5 "2023-05-21T18:22:48Z")

</div>

Dumme Frage, WELCHE Tabelle? Ich habe in der ganzen Datenbank keine Spalte mit Inhalt Status.

---

<div class="post-metadata">

### Author: ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)
#### Post date: [22. Mai 2023 um 07:30 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/6 "2023-05-22T07:30:09Z")

</div>

Komisch, dass das PayPal Plugin behauptet. Vielleicht liegt es aber auch an einer fehlerhaften Migration, die den Status zweimal anlegt. Wobei dann vermutlich alle betroffen wären mit dem Problem.

---

<div class="post-metadata">

### Author: ![moellerb92](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@moellerb92](https://forum.shopware.com/u/moellerb92)
#### Post date: [22. Mai 2023 um 08:50 UTC](https://forum.shopware.com/t/sw6-sqlstate-42s21-coloumn-already-exsists-paypal/99747/7 "2023-05-22T08:50:52Z")

</div>

Komisch ist es aufjedenfall, nur es löst mein Problem nicht.

In welcher Tabelle muss ich Status löschen?
