# Bestellungen im Backend wirft einen 503er raus.

**URL:** <https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333>\
**Category:** Programmierung\
**Created:** [13. Oktober 2019 um 14:55 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333 "2019-10-13T14:55:39Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![TB88](https://avatars.discourse-cdn.com/v4/letter/t/9fc29f/32.png) [@TB88](https://forum.shopware.com/u/TB88)\
**Post date:** [13. Oktober 2019 um 14:55 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/1 "2019-10-13T14:55:39Z")

</div>

Hallo,

&nbsp;

seit gestern Abend wirft das Bestellungen Modul nur noch einen 503 aus und zeigt keine Bestellungen mehr an.

&nbsp;

Folgende Fehlermeldung :

&nbsp;

> Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.ping AS allow\_shipping\_103, s4\_.areaID AS areaID\_104, s5\_.id AS id\_105, s5\_.main\_id AS main\_id\_106, s5\_.category\_id AS category\_id\_107, s5\_.name AS name\_108, s5\_.title AS title\_109, s5\_.position AS position\_110, s5\_.host AS host\_111, s5\_.base\_path AS base\_path\_112, s5\_.base\_url […]lockedUntil\_56, s1\_.salutation AS salutation\_57, s1\_.title AS title\_58, s1\_.firstname AS firstname\_59, s1\_.lastname AS lastname\_60, s1\_.birthday AS birthday\_61, s1\_.doubleOptinRegister AS doubleOptinRegister\_62, s1\_.doubleOptinEmailSentDate AS doubleOptinEmailSentDate\_63, s1\_.doubleOptinConfirmDate AS doubleOptinConfirmDate\_64, s1\_.password\_change\_date AS password\_change\_date\_65, s1\_.register\_opt\_in\_id AS register\_opt\_in\_id\_66, s2\_.title AS title\_67, s2\_.additional\_address\_line1 AS additional\_address\_line1\_68, s2\_.additional\_address\_line2 AS additional\_address\_line2\_69, s2\_.id AS id\_70, s2\_.orderID AS orderID\_71, s2\_.countryID AS countryID\_72, s2\_.stateID AS stateID\_73, s2\_.userID AS userID\_74, s2\_.company AS company\_75, s2\_.department AS department\_76, s2\_.salutation AS salutation\_77, s2\_.firstname AS firstname\_78, s2\_.lastname AS lastname\_79, s2\_.street AS street\_80, s2\_.zipcode AS zipcode\_81, s2\_.city AS city\_82, s2\_.phone AS phone\_83, s3\_.id AS id\_84, s3\_.countryID AS countryID\_85, s3\_.position AS position\_86, s3\_.name AS name\_87, s3\_.shortcode AS shortcode\_88, s3\_.active AS active\_89, s4\_.id AS id\_90, s4\_.countryname AS countryname\_91, s4\_.countryiso AS countryiso\_92, s4\_.countryen AS countryen\_93, s4\_.position AS position\_94, s4\_.notice AS notice\_95, s4\_.taxfree AS taxfree\_96, s4\_.taxfree\_ustid AS taxfree\_ustid\_97, s4\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_98, s4\_.active AS active\_99, s4\_.iso3 AS iso3\_100, s4\_.display\_state\_in\_registration AS display\_state\_in\_registration\_101, s4\_.force\_state\_in\_registration AS force\_state\_in\_registration\_102, s4\_.allow\_ship s10\_.zipcode AS zipcode\_169, s10\_.city AS city\_170, s10\_.phone AS phone\_171, s10\_.ustid AS ustid\_172, s11\_.id AS id\_173, s11\_.countryname AS countryname\_174, s11\_.countryiso AS countryiso\_175, s11\_.countryen AS countryen\_176, s11\_.position AS position\_177, s11\_.notice AS notice\_178, s11\_.taxfree AS taxfree\_179, s11\_.taxfree\_ustid AS taxfree\_ustid\_180, s11\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_181, s11\_.active AS active\_182, s11\_.iso3 AS iso3\_183, s11\_.display\_state\_in\_registration AS display\_state\_in\_registration\_184, s11\_.force\_state\_in\_registration AS force\_state\_in\_registration\_185, s11\_.allow\_shipping AS allow\_shipping\_186, s11\_.areaID AS areaID\_187, s12\_.id AS id\_188, s12\_.countryID AS countryID\_189, s12\_.position AS position\_190, s12\_.name AS name\_191, s12\_.shortcode AS shortcode\_192, s12\_.active AS active\_193, s13\_.id AS id\_194, s13\_.main\_id AS main\_id\_195, s13\_.category\_id AS category\_id\_196, s13\_.name AS name\_197, s13\_.title AS title\_198, s13\_.position AS position\_199, s13\_.host AS host\_200, s13\_.base\_path AS base\_path\_201, s13\_.base\_url AS base\_url\_202, s13\_.hosts AS hosts\_203, s13\_.secure AS secure\_204, s13\_.template\_id AS template\_id\_205, s13\_.`default` AS default\_206, s13\_.active AS active\_207, s13\_.customer\_scope AS customer\_scope\_208, s14\_.id AS id\_209, s14\_.name AS name\_210, s14\_.type AS type\_211, s14\_.description AS description\_212, s14\_.comment AS comment\_213, s14\_.active AS active\_214, s14\_.position AS position\_215, s14\_.calculation AS calculation\_216, s14\_.surcharge\_calculation AS surcharge\_calculation\_217, s14\_.tax\_calculation AS tax\_calculation\_218, s14\_.shippingfree AS shippingfree\_219, s14\_.multishopID AS multishopID\_220, s14\_.customergroupID AS customergroupID\_221, s14\_.bind\_shippingFree AS bind\_shippingFree\_222, s14\_.bind\_time\_from AS bind\_time\_from\_223, s14\_.bind\_time\_to AS bind\_time\_to\_224, s14\_.bind\_instock AS bind\_instock\_225, s14\_.bind\_laststock AS bind\_laststock\_226, s14\_.bind\_weekday\_from AS bind\_weekday\_from\_227, s14\_.bind\_weekday\_to AS bind\_weekday\_to\_228, s14\_.bind\_weight\_from AS bind\_weight\_from\_229, s14\_.bind\_weight\_to AS bind\_weight\_to\_230, s14\_.bind\_price\_from AS bind\_price\_from\_231, s14\_.bind\_price\_to AS bind\_price\_to\_232, s14\_.bind\_sql AS bind\_sql\_233, s14\_.status\_link AS status\_link\_234, s14\_.calculation\_sql AS calculation\_sql\_235 FROM s\_order s0\_ LEFT JOIN s\_user s1\_ ON s0\_.userID = s1\_.id LEFT JOIN s\_order\_shippingaddress s2\_ ON s0\_.id = s2\_.orderID LEFT JOIN s\_core\_countries\_states s3\_ ON s2\_.stateID = s3\_.id LEFT JOIN s\_core\_countries s4\_ ON s2\_.countryID = s4\_.id LEFT JOIN s\_core\_shops s5\_ ON s0\_.language = s5\_.id LEFT JOIN s\_core\_locales s6\_ ON s5\_.locale\_id = s6\_.id LEFT JOIN s\_core\_paymentmeans s7\_ ON s0\_.paymentID = s7\_.id LEFT JOIN s\_core\_states s8\_ ON s0\_.cleared = s8\_.id LEFT JOIN s\_core\_states s9\_ ON s0\_.status = s9\_.id LEFT JOIN s\_order\_billingaddress s10\_ ON s0\_.id = s10\_.orderID LEFT JOIN s\_core\_countries s11\_ ON s10\_.countryID = s11\_.id LEFT JOIN s\_core\_countries\_states s12\_ ON s10\_.stateID = s12\_.id LEFT JOIN s\_core\_shops s13\_ ON s0\_.subshopID = s13\_.id LEFT JOIN s\_premium\_dispatch s14\_ ON s0\_.dispatchID = s14\_.id WHERE s0\_.id IN (?, ?, ?, ?, ?, ?, ?)’ with params [131, 129, 127, 125, 123, 121, 109]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1\_.password\_change\_date‘ 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(334): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(967): Doctrine\ORM\Query-\>\_doExecute() #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(922): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 2) #6 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(738): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #7 engine/Shopware/Models/Order/Repository.php(405): Doctrine\ORM\AbstractQuery-\>getArrayResult() #8 engine/Shopware/Controllers/Backend/Order.php(1389): Shopware\Models\Order\Repository-\>getList(Array) #9 engine/Shopware/Controllers/Backend/Order.php(335): Shopware\_Controllers\_Backend\_Order-\>getList(Array, Array, 0, 20) #10 engine/Library/Enlight/Controller/Action.php(192): Shopware\_Controllers\_Backend\_Order-\>getListAction() #11 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight\_Controller\_Action-\>dispatch(‚getListAction‘) #12 engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 engine/Shopware/Kernel.php(185): Enlight\_Controller\_Front-\>dispatch() #14 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 engine/Shopware/Components/HttpCache/AppCache.php(99): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #19 shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}&nbsp;

&nbsp;

Anscheinden Fehlt die Column ‚s1\_.password\_change\_date‘. Aber bevor ich die jetzt einfach wieder da rein klatsche, zumal ich so spontan auch nicht im Kopft hätte wo die hingehört, wollte ich zumindest mal fragen, ob jemand mit der Fehlermeldung was anfangen kann.

&nbsp;

Mit besten Grüßen

&nbsp;

Florian.

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [14. Oktober 2019 um 08:47 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/2 "2019-10-14T08:47:20Z")

</div>

Eine Spalte wird ja nicht einfach so auf einmal fehlen. Da Du aber Deinen Shop schon quasi geschrottet hast, vermutlich mit einem Update auf 5.6, kann es die Sache nicht mehr verschlimmern, wenn Du&nbsp;die&nbsp;fehlende Spalte in&nbsp;s\_user hinzuzufügst.

---

<div class="post-metadata">

**Author:** ![TB88](https://avatars.discourse-cdn.com/v4/letter/t/9fc29f/32.png) [@TB88](https://forum.shopware.com/u/TB88)\
**Post date:** [14. Oktober 2019 um 10:06 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/3 "2019-10-14T10:06:58Z")

</div>

Das Update auf 5.6 hat bisher nur zwei Fehler produziert. (Was für dieses Update schon eigentlich ein guter Schnitt ist.) Witzigerweise lässt sich diese Column ohnehin, unter den Einschränkungen der gültigen SQL Benennungsregeln, so nicht einfügen. Wenn ich den Namen so anpasse, dass Sie erstellt wird, ändert das freilich nichts am generierten Fehler. -\_-

---

<div class="post-metadata">

**Author:** ![Ake](https://avatars.discourse-cdn.com/v4/letter/a/ee59a6/32.png) [@Ake](https://forum.shopware.com/u/Ake)\
**Post date:** [14. Oktober 2019 um 10:38 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/4 "2019-10-14T10:38:31Z")

</div>

Die Lösungsvorschläge würden mich hier auch mal interessieren. Das Problem ist bei mir ebenfalls vorhanden nach dem Update.

---

<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:** [14. Oktober 2019 um 10:45 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/5 "2019-10-14T10:45:45Z")

</div>

> Das Problem ist bei mir ebenfalls vorhanden nach dem Update.

Das ist komisch, wiel das Update genau diese Änderung enthällt:

```
class Migrations_Migration1626 extends Shopware\Components\Migrations\AbstractMigration
{
    public function up($modus)
    {
        $exist = $this->connection->query('SHOW COLUMNS FROM `s_user` LIKE \'password_change_date\';')->fetch();

        if ($exist !== false) {
            return;
        }

        $this->addSql('ALTER TABLE `s_user` ADD `password_change_date` datetime NOT NULL DEFAULT NOW();');
        $this->addSql('UPDATE s_user SET `password_change_date` = `firstlogin`');
    }
}

```

&nbsp;

---

<div class="post-metadata">

**Author:** ![Ake](https://avatars.discourse-cdn.com/v4/letter/a/ee59a6/32.png) [@Ake](https://forum.shopware.com/u/Ake)\
**Post date:** [14. Oktober 2019 um 11:32 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/6 "2019-10-14T11:32:15Z")

</div>

Lösen konntest du es bislang noch nicht oder ? Das ist so ein Misst aktuell. Aber irgendwie muss es zu lösen sein.

---

<div class="post-metadata">

**Author:** ![TB88](https://avatars.discourse-cdn.com/v4/letter/t/9fc29f/32.png) [@TB88](https://forum.shopware.com/u/TB88)\
**Post date:** [14. Oktober 2019 um 11:42 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/7 "2019-10-14T11:42:52Z")

</div>

> [@Ake schrieb:](https://forum.shopware.com/profile/32920/Ake "Ake")
> 
> Lösen konntest du es bislang noch nicht oder ? Das ist so ein Misst aktuell. Aber irgendwie muss es zu lösen sein.
> 
> &nbsp;
> 
> &nbsp;

Nein, konnt das leider auch bisher nicht weiterkommen. :/&nbsp;

---

<div class="post-metadata">

**Author:** ![TB88](https://avatars.discourse-cdn.com/v4/letter/t/9fc29f/32.png) [@TB88](https://forum.shopware.com/u/TB88)\
**Post date:** [14. Oktober 2019 um 12:58 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/8 "2019-10-14T12:58:49Z")

</div>

Okay, die „password\_change\_data“ habe ich rein bekommen. Jetzt möchte es noch die „register\_opt\_in\_id“. Da ich vermute, dass da noch ein paar kommen werden wäre meine Frage, ob es eine Dokumentation gibt, wo ich mir das alles selber rauspuhlen kann? Dann brauche ich euch hier nicht weiter auf die Nerven fallen.

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [14. Oktober 2019 um 13:13 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/9 "2019-10-14T13:13:01Z")

</div>

> [@TB88 schrieb:](https://forum.shopware.com/profile/32900/TB88 "TB88")
> 
> Okay, die „password\_change\_data“ habe ich rein bekommen. Jetzt möchte es noch die „register\_opt\_in\_id“. Da ich vermute, dass da noch ein paar kommen werden wäre meine Frage, ob es eine Dokumentation gibt, wo ich mir das alles selber rauspuhlen kann? Dann brauche ich euch hier nicht weiter auf die Nerven fallenn

Versuche mal das Update sauber durchzuführen. Checke mal die Doku ob die Vorausssetzungen dafür erfüllt sind:&nbsp;[https://docs.shopware.com/de/shopware-5-de/update-guides/update-guide-shopware-56](https://docs.shopware.com/de/shopware-5-de/update-guides/update-guide-shopware-56)

---

<div class="post-metadata">

**Author:** ![TB88](https://avatars.discourse-cdn.com/v4/letter/t/9fc29f/32.png) [@TB88](https://forum.shopware.com/u/TB88)\
**Post date:** [14. Oktober 2019 um 13:32 UTC](https://forum.shopware.com/t/bestellungen-im-backend-wirft-einen-503er-raus/62333/10 "2019-10-14T13:32:02Z")

</div>

Das ist ja was ich sage,

ich habe extra alle Voraussetzungen umgesetzt. Habe Template-Keys händisch geändert. Das Update lief durch. Und die zwei drei Einträge jetzt nochmal händisch in die SQL packen ist bestimmt weniger riskant, als das Update erneut fahren und ein zweites mal zu würfeln.