# Column not found: 1054 Unknown column 'doubleOptinRegister'

**URL:** <https://forum.shopware.com/t/column-not-found-1054-unknown-column-doubleoptinregister/54950>\
**Category:** Allgemein\
**Created:** [3. September 2018 um 09:26 UTC](https://forum.shopware.com/t/column-not-found-1054-unknown-column-doubleoptinregister/54950 "2018-09-03T09:26:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChrisH](https://avatars.discourse-cdn.com/v4/letter/c/6de8d8/32.png) [@ChrisH](https://forum.shopware.com/u/ChrisH)\
**Post date:** [3. September 2018 um 09:26 UTC](https://forum.shopware.com/t/column-not-found-1054-unknown-column-doubleoptinregister/54950/1 "2018-09-03T09:26:44Z")

</div>

Hallo zusammen,

wir betreiben einen Shopwareshop in der Version 5.4.5 und haben aktuell das Problem das es zu einem Fehler kommt sobald man sich als Kunde einloggen möchte. Folgender Error wird ausgegeben:

**Fatal error** : Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘doubleOptinRegister’ in ‘field list’ in /html/integration/docroot/engine/Library/Zend/Db/Statement/Pdo.php:219 Stack trace: #0 /html/integration/docroot/engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement-\>execute(Array) #1 /html/integration/docroot/engine/Library/Zend/Db/Statement.php(297): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /html/integration/docroot/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend\_Db\_Statement-\>execute(Array) #3 /html/integration/docroot/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend\_Db\_Adapter\_Abstract-\>query(‘SELECT id, doub…’, Array) #4 /html/integration/docroot/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(‘SELECT id, doub…’, Array) #5 /html/integration/docroot/engine/Library/Zend/Db/Adapter/Abstract.php(744): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(‘SELECT id, doub…’, Array) #6 /html/integration/docroot/engine in **/html/integration/docroot/engine/Library/Zend/Db/Statement/Pdo.php** on line **224**

Ich habe dabei in Erfahrung gebracht das die Felder **doubleOptinRegister,**** doubleOptInEmailSentDate **sowie** doubleOptInRegister** garnicht in der Tabelle “s\_user” existieren?! Wie kann das sein?

&nbsp;

VG Chris

&nbsp;

---

<div class="post-metadata">

**Author:** ![ChrisH](https://avatars.discourse-cdn.com/v4/letter/c/6de8d8/32.png) [@ChrisH](https://forum.shopware.com/u/ChrisH)\
**Post date:** [4. September 2018 um 15:40 UTC](https://forum.shopware.com/t/column-not-found-1054-unknown-column-doubleoptinregister/54950/2 "2018-09-04T15:40:25Z")

</div>

Hallo,

gibt es niemanden der dieses Problem schonmal hatte?

VG Chris

---

<div class="post-metadata">

**Author:** ![R4M](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/r4m/32/9983_2.png) [@R4M](https://forum.shopware.com/u/R4M)\
**Post date:** [5. September 2018 um 11:20 UTC](https://forum.shopware.com/t/column-not-found-1054-unknown-column-doubleoptinregister/54950/3 "2018-09-05T11:20:08Z")

</div>

Benutze mal die Forumsuche, dazu gibt es ähnliche Beiträge auch mit eventuellen Lösungen.

---

<div class="post-metadata">

**Author:** ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)\
**Post date:** [5. September 2018 um 13:16 UTC](https://forum.shopware.com/t/column-not-found-1054-unknown-column-doubleoptinregister/54950/4 "2018-09-05T13:16:51Z")

</div>

Weitere Details:&nbsp;[https://forum.shopware.com/discussion/comment/230125/#Comment\_230125](https://forum.shopware.com/discussion/comment/230125/#Comment_230125)