# Bestellungen im Backend lassen sich nicht aufrufen
**URL:** https://forum.shopware.com/t/bestellungen-im-backend-lassen-sich-nicht-aufrufen/27156
**Category:** Allgemein
**Tags:** resolved-topics
**Created:** [12. Mai 2015 um 10:19 UTC](https://forum.shopware.com/t/bestellungen-im-backend-lassen-sich-nicht-aufrufen/27156 "2015-05-12T10:19:48Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@konsi](https://forum.shopware.com/u/konsi)
#### Post date: [12. Mai 2015 um 10:19 UTC](https://forum.shopware.com/t/bestellungen-im-backend-lassen-sich-nicht-aufrufen/27156/1 "2015-05-12T10:19:48Z")
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]
---
### Author:  [@konsi](https://forum.shopware.com/u/konsi)
#### Post date: [12. Mai 2015 um 10:22 UTC](https://forum.shopware.com/t/bestellungen-im-backend-lassen-sich-nicht-aufrufen/27156/2 "2015-05-12T10:22:25Z")
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.