# Fehlermeldung beim Öffnen der Bestellungen **URL:** \ **Category:** Shopware 3.5\ **Tags:** administration\ **Created:** [17. März 2015 um 15:49 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669 "2015-03-17T15:49:38Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Tamira](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@Tamira](https://forum.shopware.com/u/Tamira)\ **Post date:** [17. März 2015 um 15:49 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669/1 "2015-03-17T15:49:38Z")
Ich bekomme beim Öffnen der Bestellungen unter Kunden diese Fehlermeldung: Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT s0\_.id AS id0, s0\_.ordernumber AS ordernumber1, s0\_.userID AS userID2, s0\_.status AS status3, s0\_.cleared AS cleared4, s0\_.paymentID AS paymentID5, s0\_.dispatchID AS dispatchID6, s0\_.partnerID AS partnerID7, s0\_.subshopID AS subshopID8, s0\_.invoice\_amount AS invoice\_amount9, s0\_.invoice\_amount\_net AS invoice\_amount\_net10, s0\_.invoice\_shipping AS invoice\_shipping11, s0\_.invoice\_shipping\_net AS invoice\_shipping\_net12, s0\_.ordertime AS ordertime13, s0\_.transactionID AS transactionID14, s0\_.comment AS comment15, s0\_.customercomment AS customercomment16, s0\_.internalcomment AS internalcomment17, s0\_.net AS net18, s0\_.taxfree AS taxfree19, s0\_.temporaryID AS temporaryID20, s0\_.referer AS referer21, s0\_.cleareddate AS cleareddate22, s0\_.trackingcode AS trackingcode23, s0\_.language AS language24, s0\_.currency AS currency25, s0\_.currencyfactor AS currencyfactor26, s0\_.remote\_addr AS remote\_addr27, s1\_.id AS id28, s1\_.name AS name29, s1\_.description AS description30, s1\_.template AS template31, s1\_.class AS class32, s1\_.`table` AS table33, s1\_.hide AS hide34, s1\_.additionaldescription AS additionaldescription35, s1\_.debit\_percent AS debit\_percent36, s1\_.surcharge AS surcharge37, s1\_.surchargestring AS surchargestring38, s1\_.position AS position39, s1\_.active AS active40, s1\_.esdactive AS esdactive41, s1\_.embediframe AS embediframe42, s1\_.hideprospect AS hideprospect43, s1\_.action AS action44, s1\_.pluginID AS pluginID45, s1\_.source AS source46, s2\_.id AS id47, s2\_.description AS description48, s2\_.position AS position49, s2\_.`group` AS group50, s2\_.mail AS mail51, s3\_.id AS id52, s3\_.description AS description53, s3\_.position AS position54, s3\_.`group` AS group55, s3\_.mail AS mail56, s4\_.id AS id57, s4\_.orderID AS orderID58, s4\_.userID AS userID59, s4\_.countryID AS countryID60, s4\_.company AS company61, s4\_.department AS department62, s4\_.salutation AS salutation63, s4\_.customernumber AS customernumber64, s4\_.firstname AS firstname65, s4\_.lastname AS lastname66, s4\_.street AS street67, s4\_.streetnumber AS streetnumber68, s4\_.zipcode AS zipcode69, s4\_.city AS city70, s4\_.phone AS phone71, s4\_.fax AS fax72, s4\_.ustid AS ustid73, s5\_.id AS id74, s5\_.paymentID AS paymentID75, s5\_.customergroup AS customergroup76, s5\_.subshopID AS subshopID77, s5\_.pricegroupID AS pricegroupID78, s5\_.encoder AS encoder79, s5\_.password AS password80, s5\_.active AS active81, s5\_.email AS email82, s5\_.firstlogin AS firstlogin83, s5\_.lastlogin AS lastlogin84, s5\_.accountmode AS accountmode85, s5\_.confirmationkey AS confirmationkey86, s5\_.sessionID AS sessionID87, s5\_.newsletter AS newsletter88, s5\_.validation AS validation89, s5\_.affiliate AS affiliate90, s5\_.paymentpreset AS paymentpreset91, s5\_.language AS language92, s5\_.referer AS referer93, s5\_.internalcomment AS internalcomment94, s5\_.failedlogins AS failedlogins95, s5\_.lockedUntil AS lockedUntil96, s6\_.id AS id97, s6\_.orderID AS orderID98, s6\_.articleID AS articleID99, s6\_.taxID AS taxID100, s6\_.tax\_rate AS tax\_rate101, s6\_.status AS status102, s6\_.ordernumber AS ordernumber103, s6\_.articleordernumber AS articleordernumber104, s6\_.price AS price105, s6\_.quantity AS quantity106, s6\_.name AS name107, s6\_.shipped AS shipped108, s6\_.shippedgroup AS shippedgroup109, s6\_.releasedate AS releasedate110, s6\_.modus AS modus111, s6\_.esdarticle AS esdarticle112, s6\_.config AS config113, s6\_.ean AS ean114, s6\_.unit AS unit115, s6\_.pack\_unit AS pack\_unit116, s7\_.id AS id117, s7\_.countryname AS countryname118, s7\_.countryiso AS countryiso119, s7\_.countryen AS countryen120, s7\_.position AS position121, s7\_.notice AS notice122, s7\_.shippingfree AS shippingfree123, s7\_.taxfree AS taxfree124, s7\_.taxfree\_ustid AS taxfree\_ustid125, s7\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked126, s7\_.active AS active127, s7\_.iso3 AS iso3128, s7\_.display\_state\_in\_registration AS display\_state\_in\_registration129, s7\_.force\_state\_in\_registration AS force\_state\_in\_registration130, s7\_.areaID AS areaID131, s8\_.id AS id132, s8\_.main\_id AS main\_id133, s8\_.category\_id AS category\_id134, s8\_.name AS name135, s8\_.title AS title136, s8\_.position AS position137, s8\_.host AS host138, s8\_.base\_path AS base\_path139, s8\_.base\_url AS base\_url140, s8\_.hosts AS hosts141, s8\_.secure AS secure142, s8\_.always\_secure AS always\_secure143, s8\_.secure\_host AS secure\_host144, s8\_.secure\_base\_path AS secure\_base\_path145, s8\_.`default` AS default146, s8\_.active AS active147, s8\_.customer\_scope AS customer\_scope148, s9\_.id AS id149, s9\_.name AS name150, s9\_.type AS type151, s9\_.description AS description152, s9\_.comment AS comment153, s9\_.active AS active154, s9\_.position AS position155, s9\_.calculation AS calculation156, s9\_.surcharge\_calculation AS surcharge\_calculation157, s9\_.tax\_calculation AS tax\_calculation158, s9\_.shippingfree AS shippingfree159, s9\_.multishopID AS multishopID160, s9\_.customergroupID AS customergroupID161, s9\_.bind\_shippingFree AS bind\_shippingFree162, s9\_.bind\_time\_from AS bind\_time\_from163, s9\_.bind\_time\_to AS bind\_time\_to164, s9\_.bind\_instock AS bind\_instock165, s9\_.bind\_laststock AS bind\_laststock166, s9\_.bind\_weekday\_from AS bind\_weekday\_from167, s9\_.bind\_weekday\_to AS bind\_weekday\_to168, s9\_.bind\_weight\_from AS bind\_weight\_from169, s9\_.bind\_weight\_to AS bind\_weight\_to170, s9\_.bind\_price\_from AS bind\_price\_from171, s9\_.bind\_price\_to AS bind\_price\_to172, s9\_.bind\_sql AS bind\_sql173, s9\_.status\_link AS status\_link174, s9\_.calculation\_sql AS calculation\_sql175, s10\_.id AS id176, s10\_.billingID AS billingID177, s10\_.text1 AS text1178, s10\_.text2 AS text2179, s10\_.text3 AS text3180, s10\_.text4 AS text4181, s10\_.text5 AS text5182, s10\_.text6 AS text6183, s11\_.id AS id184, s11\_.orderID AS orderID185, s11\_.attribute1 AS attribute1186, s11\_.attribute2 AS attribute2187, s11\_.attribute3 AS attribute3188, s11\_.attribute4 AS attribute4189, s11\_.attribute5 AS attribute5190, s11\_.attribute6 AS attribute6191, s11\_.swag\_payal\_billing\_agreement\_id AS swag\_payal\_billing\_agreement\_id192, s11\_.swag\_payal\_express AS swag\_payal\_express193, s11\_.swag\_dhl\_address AS swag\_dhl\_address194, s11\_.swag\_dhl\_order\_info AS swag\_dhl\_order\_info195 FROM s\_order s0\_ LEFT JOIN s\_core\_paymentmeans s1\_ ON s0\_.paymentID = s1\_.id LEFT JOIN s\_core\_states s2\_ ON s0\_.cleared = s2\_.id LEFT JOIN s\_core\_states s3\_ ON s0\_.status = s3\_.id LEFT JOIN s\_order\_billingaddress s4\_ ON s0\_.id = s4\_.orderID LEFT JOIN s\_user s5\_ ON s0\_.userID = s5\_.id LEFT JOIN s\_order\_details s6\_ ON s0\_.id = s6\_.orderID LEFT JOIN s\_core\_countries s7\_ ON s4\_.countryID = s7\_.id LEFT JOIN s\_core\_shops s8\_ ON s0\_.subshopID = s8\_.id LEFT JOIN s\_premium\_dispatch s9\_ ON s0\_.dispatchID = s9\_.id LEFT JOIN s\_order\_billingaddress\_attributes s10\_ ON s4\_.id = s10\_.billingID LEFT JOIN s\_order\_attributes s11\_ ON s0\_.id = s11\_.orderID WHERE s0\_.status NOT IN (‘-1’) AND s0\_.ordernumber IS NOT NULL AND s0\_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0\_.ordertime DESC’ with params [„85“, „81“, „78“, „73“, „69“, „67“, „65“, „60“, „52“, „47“, „45“, „27“]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s6\_.ean‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‚SELECT s0\_.id A…‘, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‚SELECT s0\_.id A…‘, Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(574): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(186): Doctrine\ORM\AbstractQuery-\>getResult(2) #6 Shopware/Controllers/Backend/Order.php(363): Doctrine\ORM\Tools\Pagination\Paginator-\>getIterator() #7 Shopware/Controllers/Backend/Order.php(333): Shopware\_Controllers\_Backend\_Order-\>getList(Array, NULL, ‚0‘, ‚20‘) #8 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Order-\>getListAction() #9 Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch(‚getListAction‘) #10 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 Shopware/Kernel.php(145): Enlight\_Controller\_Front-\>dispatch() #12 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(471): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 Shopware/Components/HttpCache/AppCache.php(257): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(242): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} Leider kann ich mit der Beschreibung des Fehlers nichts anfangen. Ich hatte zuvor das Update per Browser aufgespielt. Wer weiß Rat? Tamira ---
**Author:** ![Tamira](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@Tamira](https://forum.shopware.com/u/Tamira)\ **Post date:** [17. März 2015 um 16:59 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669/2 "2015-03-17T16:59:54Z")
Ist die Datenbank hinüber? Oder kann ich da noch was retten? ---
**Author:** ![Tamira](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@Tamira](https://forum.shopware.com/u/Tamira)\ **Post date:** [17. März 2015 um 18:08 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669/3 "2015-03-17T18:08:07Z")
Ich habe nun mal in der Datenbank in “s\_schema” nachgeschaut. Dort fehlen die Deltas 311 bis 319 komplett. Und bei den ausgeführten Deltas steht ein Datum vom letzen Jahr. Eigentlich müsste dort doch ein Datum vom Einspielen stehen oder? ---
**Author:** ![hth](https://avatars.discourse-cdn.com/v4/letter/h/b77776/32.png) [@hth](https://forum.shopware.com/u/hth)\ **Post date:** [17. März 2015 um 18:26 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669/4 "2015-03-17T18:26:42Z")
Hallo Tamira, in s\_schema sollte das Datum des Updates stehen. Du kannst die Deltas manuell durchführen. Ich empfehle dir aber das Backup einzuspielen. Hast Du ein Full-Backup (Datei und SQL-Dump der Datenbank) oder nur einen SQL-Dump? Oder hast Du gar kein Backup? Wenn das Backup eingespielt ist, kannst Du das Update über die ssh-Konsole machen. Das ist in der Regel wesentlich robuster, da Skriptlimits meist ausgeschaltet oder höher sind. Viele Grüße ---
**Author:** ![Tamira](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@Tamira](https://forum.shopware.com/u/Tamira)\ **Post date:** [17. März 2015 um 19:30 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669/5 "2015-03-17T19:30:22Z")
Ich habe ein SQL Dump. Aber das habe ich schon importiert. Muss ich die Datenbank vorher komplett löschen oder drüberinstallieren? Und wie rufe ich die ssh-Konsole auf? Ich weis wo sie liegt, aber nicht wie man sie aufruft. Und wenn das nicht funtktioniert; wie kann ich die Deltas manuell ausführen? ---
**Author:** ![hth](https://avatars.discourse-cdn.com/v4/letter/h/b77776/32.png) [@hth](https://forum.shopware.com/u/hth)\ **Post date:** [17. März 2015 um 20:10 UTC](https://forum.shopware.com/t/fehlermeldung-beim-offnen-der-bestellungen/25669/6 "2015-03-17T20:10:05Z")
[quote=“Tamira”]Ich habe ein SQL Dump. Aber das habe ich schon importiert. Muss ich die Datenbank vorher komplett löschen oder drüberinstallieren? Und wie rufe ich die ssh-Konsole auf? Ich weis wo sie liegt, aber nicht wie man sie aufruft. Und wenn das nicht funtktioniert; wie kann ich die Deltas manuell ausführen?[/quote] Mit dem Import hast Du natürlich zusätzliches Chaos erzeugt. Jetzt hast Du wahrscheinlich ein Mix aus alter Datenbank-Version sowie Teilen der neuen Version und ob dein Dateisystem der aktuellen oder der alten Shopware-Version entspricht kannst Du wahrscheinlich auch nicht mehr garantieren. Am einfachsten wäre es, Du spielst ein Backup des Hosters wieder ein (Zeitpunkt vor dem Update-Versuch). Ansonsten würde ich an deiner Stelle die Mediadaten (Bilder), den files-Ordner und dein eigenes Template sichern. Per FTP oder als ZIP-Archiv über die SSH-Konsole. Evtl. bietet dein Hoster auch ein Web-FTP an mit dem Du ZIP-Archive erstellen und dann herunterladen kannst. Installierte Plugins kannst Du vor dem ersten Aufruf des Frontends aus dem Shopware-Account herunterladen oder Du sicherst die entsprechenden Plugin-Ordner. Folgende Verzeichnisse rekursiv sichern: Medien-Daten: media/ Files: files/ Deinen Template-Ordner. Dann alle Dateien auf dem Server löschen und Shopware neu installieren. Anschließend gehst Du in die Datenbank und löschst alle Tabellen , Die Foreign Keys erfordern wahrscheinlich 2 Löschdurchgänge in der Datenbank. In die leere Datenbank importierst Du die im SQL-Dump gesicherten Tabellen. Auf SSH greifst du über einen Client zu z. B. : [http://www.heise.de/download/putty.html](http://www.heise.de/download/putty.html) Je nachdem wo du hostest, kannst Du die neue Shopwareinstallation einfach in ein neues Verzeichnis installieren und die alten media sowie files ordner dorthin kopieren (per SSH). Wo bist Du denn? Dies hätte den Vorteil, dass dein altes System als Backup erhalten bliebe. Falls durch dich oder eines deiner Plugins neue Verzeichnisse angelegt worden sind, musst Du die natürlich auch vorab sichern. Du kannst mir eine PM schicken, wenn Du unsicher bist. Wenn Du eine Standard-Shopware-Installation verwendest, dann 1. Sichern folgender Ordner als ZIP-Archiv mittels SSH oder über ein FTP-Programm sichern (inkl. Unterordner) /files /media /eigenesTemplate-Ordner