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
Ist die Datenbank hinüber? Oder kann ich da noch was retten?
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?
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
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=“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 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