Ich bekomme folgende Fehlermeldung wenn ich im Backend die Bestellungen aufrufen möchte. Anscheinend liegt das an Klarna, wenn ich das Plugin jedoch lösche, bleibt der Fehler weiterhin. Das Plugin funktioniert im übrigen im Moment nicht. [quote] 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, s0_.deviceType AS deviceType28, s1_.id AS id29, s1_.name AS name30, s1_.description AS description31, s1_.template AS template32, s1_.class AS class33, s1_.table AS table34, s1_.hide AS hide35, s1_.additionaldescription AS additionaldescription36, s1_.debit_percent AS debit_percent37, s1_.surcharge AS surcharge38, s1_.surchargestring AS surchargestring39, s1_.position AS position40, s1_.active AS active41, s1_.esdactive AS esdactive42, s1_.mobile_inactive AS mobile_inactive43, s1_.embediframe AS embediframe44, s1_.hideprospect AS hideprospect45, s1_.action AS action46, s1_.pluginID AS pluginID47, s1_.source AS source48, s2_.id AS id49, s2_.description AS description50, s2_.position AS position51, s2_.group AS group52, s2_.mail AS mail53, s3_.id AS id54, s3_.description AS description55, s3_.position AS position56, s3_.group AS group57, s3_.mail AS mail58, s4_.id AS id59, s4_.orderID AS orderID60, s4_.userID AS userID61, s4_.countryID AS countryID62, s4_.stateID AS stateID63, s4_.company AS company64, s4_.department AS department65, s4_.salutation AS salutation66, s4_.customernumber AS customernumber67, s4_.firstname AS firstname68, s4_.lastname AS lastname69, s4_.street AS street70, s4_.zipcode AS zipcode71, s4_.city AS city72, s4_.phone AS phone73, s4_.fax AS fax74, s4_.ustid AS ustid75, s4_.additional_address_line1 AS additional_address_line176, s4_.additional_address_line2 AS additional_address_line277, s5_.id AS id78, s5_.paymentID AS paymentID79, s5_.customergroup AS customergroup80, s5_.subshopID AS subshopID81, s5_.pricegroupID AS pricegroupID82, s5_.encoder AS encoder83, s5_.password AS password84, s5_.active AS active85, s5_.email AS email86, s5_.firstlogin AS firstlogin87, s5_.lastlogin AS lastlogin88, s5_.accountmode AS accountmode89, s5_.confirmationkey AS confirmationkey90, s5_.sessionID AS sessionID91, s5_.newsletter AS newsletter92, s5_.validation AS validation93, s5_.affiliate AS affiliate94, s5_.paymentpreset AS paymentpreset95, s5_.language AS language96, s5_.referer AS referer97, s5_.internalcomment AS internalcomment98, s5_.failedlogins AS failedlogins99, s5_.lockedUntil AS lockedUntil100, s6_.id AS id101, s6_.orderID AS orderID102, s6_.articleID AS articleID103, s6_.taxID AS taxID104, s6_.tax_rate AS tax_rate105, s6_.status AS status106, s6_.ordernumber AS ordernumber107, s6_.articleordernumber AS articleordernumber108, s6_.price AS price109, s6_.quantity AS quantity110, s6_.name AS name111, s6_.shipped AS shipped112, s6_.shippedgroup AS shippedgroup113, s6_.releasedate AS releasedate114, s6_.modus AS modus115, s6_.esdarticle AS esdarticle116, s6_.config AS config117, s6_.ean AS ean118, s6_.unit AS unit119, s6_.pack_unit AS pack_unit120, s7_.id AS id121, s7_.countryname AS countryname122, s7_.countryiso AS countryiso123, s7_.countryen AS countryen124, s7_.position AS position125, s7_.notice AS notice126, s7_.shippingfree AS shippingfree127, s7_.taxfree AS taxfree128, s7_.taxfree_ustid AS taxfree_ustid129, s7_.taxfree_ustid_checked AS taxfree_ustid_checked130, s7_.active AS active131, s7_.iso3 AS iso3132, s7_.display_state_in_registration AS display_state_in_registration133, s7_.force_state_in_registration AS force_state_in_registration134, s7_.areaID AS areaID135, s8_.id AS id136, s8_.countryID AS countryID137, s8_.position AS position138, s8_.name AS name139, s8_.shortcode AS shortcode140, s8_.active AS active141, s9_.id AS id142, s9_.main_id AS main_id143, s9_.category_id AS category_id144, s9_.name AS name145, s9_.title AS title146, s9_.position AS position147, s9_.host AS host148, s9_.base_path AS base_path149, s9_.base_url AS base_url150, s9_.hosts AS hosts151, s9_.secure AS secure152, s9_.always_secure AS always_secure153, s9_.secure_host AS secure_host154, s9_.secure_base_path AS secure_base_path155, s9_.template_id AS template_id156, s9_.default AS default157, s9_.active AS active158, s9_.customer_scope AS customer_scope159, s10_.id AS id160, s10_.name AS name161, s10_.type AS type162, s10_.description AS description163, s10_.comment AS comment164, s10_.active AS active165, s10_.position AS position166, s10_.calculation AS calculation167, s10_.surcharge_calculation AS surcharge_calculation168, s10_.tax_calculation AS tax_calculation169, s10_.shippingfree AS shippingfree170, s10_.multishopID AS multishopID171, s10_.customergroupID AS customergroupID172, s10_.bind_shippingFree AS bind_shippingFree173, s10_.bind_time_from AS bind_time_from174, s10_.bind_time_to AS bind_time_to175, s10_.bind_instock AS bind_instock176, s10_.bind_laststock AS bind_laststock177, s10_.bind_weekday_from AS bind_weekday_from178, s10_.bind_weekday_to AS bind_weekday_to179, s10_.bind_weight_from AS bind_weight_from180, s10_.bind_weight_to AS bind_weight_to181, s10_.bind_price_from AS bind_price_from182, s10_.bind_price_to AS bind_price_to183, s10_.bind_sql AS bind_sql184, s10_.status_link AS status_link185, s10_.calculation_sql AS calculation_sql186, s11_.id AS id187, s11_.billingID AS billingID188, s11_.text1 AS text1189, s11_.text2 AS text2190, s11_.text3 AS text3191, s11_.text4 AS text4192, s11_.text5 AS text5193, s11_.text6 AS text6194, s12_.id AS id195, s12_.orderID AS orderID196, s12_.attribute1 AS attribute1197, s12_.attribute2 AS attribute2198, s12_.attribute3 AS attribute3199, s12_.attribute4 AS attribute4200, s12_.attribute5 AS attribute5201, s12_.attribute6 AS attribute6202, s12_.swag_payal_billing_agreement_id AS swag_payal_billing_agreement_id203, s12_.swag_payal_express AS swag_payal_express204, s12_.swag_klarna_status AS swag_klarna_status205, s12_.swag_klarna_invoice_number AS swag_klarna_invoice_number206 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_countries_states s8_ ON s4_.stateID = s8_.id LEFT JOIN s_core_shops s9_ ON s0_.subshopID = s9_.id LEFT JOIN s_premium_dispatch s10_ ON s0_.dispatchID = s10_.id LEFT JOIN s_order_billingaddress_attributes s11_ ON s4_.id = s11_.billingID LEFT JOIN s_order_attributes s12_ ON s0_.id = s12_.orderID WHERE s0_.status NOT IN (’-1’) AND s0_.ordernumber IS NOT NULL AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.ordertime DESC’ with params [“908”, “843”, “816”, “803”, “796”, “712”, “700”, “679”, “668”, “651”, “649”, “647”, “635”, “625”, “617”, “598”, “576”, “567”, “565”, “563”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s12_.swag_klarna_status’ 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(702): 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(360): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #7 Shopware/Controllers/Backend/Order.php(330): Shopware_Controllers_Backend_Order->getList(NULL, NULL, ‘0’, ‘20’) #8 Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Order->getListAction() #9 Enlight/Controller/Dispatcher/Default.php(524): Enlight_Controller_Action->dispatch(‘getListAction’) #10 Enlight/Controller/Front.php(227): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #11 Shopware/Kernel.php(143): Enlight_Controller_Front->dispatch() #12 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): 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(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} [/quote]
Fehler gefunden, es lag an dem Plugin Klarna Checkout, dass hatte ich vorher mal kurz installiert und dann wieder deinstalliert. Nachdem es jetzt wieder installiert ist, funktioniert alles wieder.