# Actindo Fehler beim Wechsel des SOFORT-Plugins: Column not found: 1054 Unknown column 's1\_.sofort\_id **URL:** \ **Category:** Plugins\ **Tags:** drittanbieter-plugin\ **Created:** [22. November 2017 um 08:00 UTC](https://forum.shopware.com/t/actindo-fehler-beim-wechsel-des-sofort-plugins-column-not-found-1054-unknown-column-s1-sofort-id/49637 "2017-11-22T08:00:51Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![bluewolf](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/bluewolf/32/7886_2.png) [@bluewolf](https://forum.shopware.com/u/bluewolf)\ **Post date:** [22. November 2017 um 08:00 UTC](https://forum.shopware.com/t/actindo-fehler-beim-wechsel-des-sofort-plugins-column-not-found-1054-unknown-column-s1-sofort-id/49637/1 "2017-11-22T08:00:51Z")
Hallo, in der Updatevorbereitung von 5.2 auf 5.3 & PHP7 haben wir in einem Shop das alte SOFORT-Plugin durch das neue ersetzt. Leider hatte dann Actindo Probleme, die Bestellungen abzurufen, das es versucht, auf alte Tabellen von SOFORT Überweisung zuzugreifen. Kennt einer das Problem und hat es gelöst? Der Actindo Support steht wohl völlig auf dem Schlauch…  **Column not found: 1054 Unknown column ‘s1\_.sofort\_ideal\_bank’ in 'field list’**   Gesamte Fehlermeldung: Fehler Fehler beim laden der Tabelle: Verbindungsfehler mit dem Shop beim holen der Bestellungs-Liste: An exception occurred while executing ‘SELECT s0\_.customernumber AS customernumber\_0, s0\_.id AS id\_1, s0\_.paymentID AS paymentID\_2, s0\_.customergroup AS customergroup\_3, s0\_.subshopID AS subshopID\_4, s0\_.pricegroupID AS pricegroupID\_5, s0\_.encoder AS encoder\_6, s0\_.password AS password\_7, s0\_.active AS active\_8, s0\_.email AS email\_9, s0\_.firstlogin AS firstlogin\_10, s0\_.lastlogin AS lastlogin\_11, s0\_.accountmode AS accountmode\_12, s0\_.confirmationkey AS confirmationkey\_13, s0\_.sessionID AS sessionID\_14, s0\_.newsletter AS newsletter\_15, s0\_.validation AS validation\_16, s0\_.affiliate AS affiliate\_17, s0\_.paymentpreset AS paymentpreset\_18, s0\_.language AS language\_19, s0\_.referer AS referer\_20, s0\_.internalcomment AS internalcomment\_21, s0\_.failedlogins AS failedlogins\_22, s0\_.lockedUntil AS lockedUntil\_23, s0\_.salutation AS salutation\_24, s0\_.title AS title\_25, s0\_.firstname AS firstname\_26, s0\_.lastname AS lastname\_27, s0\_.birthday AS birthday\_28, s1\_.id AS id\_29, s1\_.userID AS userID\_30, s1\_.bestit\_amazon\_user\_id AS bestit\_amazon\_user\_id\_31, s1\_.bestit\_amazon\_user\_name AS bestit\_amazon\_user\_name\_32, s1\_.mad\_age\_verified AS mad\_age\_verified\_33, s1\_.sofort\_ideal\_bank AS sofort\_ideal\_bank\_34, s2\_.id AS id\_35, s2\_.company AS company\_36, s2\_.department AS department\_37, s2\_.salutation AS salutation\_38, s2\_.firstname AS firstname\_39, s2\_.title AS title\_40, s2\_.lastname AS lastname\_41, s2\_.street AS street\_42, s2\_.zipcode AS zipcode\_43, s2\_.city AS city\_44, s2\_.phone AS phone\_45, s2\_.ustid AS ustid\_46, s2\_.additional\_address\_line1 AS additional\_address\_line1\_47, s2\_.additional\_address\_line2 AS additional\_address\_line2\_48, s2\_.country\_id AS country\_id\_49, s2\_.state\_id AS state\_id\_50, s3\_.payment\_mean\_id AS payment\_mean\_id\_51, s3\_.use\_billing\_data AS use\_billing\_data\_52, s3\_.bankname AS bankname\_53, s3\_.bic AS bic\_54, s3\_.iban AS iban\_55, s3\_.account\_number AS account\_number\_56, s3\_.bank\_code AS bank\_code\_57, s3\_.account\_holder AS account\_holder\_58, s3\_.created\_at AS created\_at\_59, s3\_.id AS id\_60, s4\_.id AS id\_61, s4\_.address\_id AS address\_id\_62, s4\_.text1 AS text1\_63, s4\_.text2 AS text2\_64, s4\_.text3 AS text3\_65, s4\_.text4 AS text4\_66, s4\_.text5 AS text5\_67, s4\_.text6 AS text6\_68, s4\_.swag\_dhl\_packstation AS swag\_dhl\_packstation\_69, s4\_.swag\_dhl\_postoffice AS swag\_dhl\_postoffice\_70, s4\_.swag\_dhl\_postnumber AS swag\_dhl\_postnumber\_71, s5\_.id AS id\_72, s5\_.company AS company\_73, s5\_.department AS department\_74, s5\_.salutation AS salutation\_75, s5\_.firstname AS firstname\_76, s5\_.title AS title\_77, s5\_.lastname AS lastname\_78, s5\_.street AS street\_79, s5\_.zipcode AS zipcode\_80, s5\_.city AS city\_81, s5\_.phone AS phone\_82, s5\_.ustid AS ustid\_83, s5\_.additional\_address\_line1 AS additional\_address\_line1\_84, s5\_.additional\_address\_line2 AS additional\_address\_line2\_85, s5\_.country\_id AS country\_id\_86, s5\_.state\_id AS state\_id\_87, s6\_.id AS id\_88, s6\_.address\_id AS address\_id\_89, s6\_.text1 AS text1\_90, s6\_.text2 AS text2\_91, s6\_.text3 AS text3\_92, s6\_.text4 AS text4\_93, s6\_.text5 AS text5\_94, s6\_.text6 AS text6\_95, s6\_.swag\_dhl\_packstation AS swag\_dhl\_packstation\_96, s6\_.swag\_dhl\_postoffice AS swag\_dhl\_postoffice\_97, s6\_.swag\_dhl\_postnumber AS swag\_dhl\_postnumber\_98, s7\_.id AS id\_99, s7\_.countryname AS countryname\_100, s7\_.countryiso AS countryiso\_101, s7\_.countryen AS countryen\_102, s7\_.position AS position\_103, s7\_.notice AS notice\_104, s7\_.shippingfree AS shippingfree\_105, s7\_.taxfree AS taxfree\_106, s7\_.taxfree\_ustid AS taxfree\_ustid\_107, s7\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_108, s7\_.active AS active\_109, s7\_.iso3 AS iso3\_110, s7\_.display\_state\_in\_registration AS display\_state\_in\_registration\_111, s7\_.force\_state\_in\_registration AS force\_state\_in\_registration\_112, s7\_.areaID AS areaID\_113, s8\_.id AS id\_114, s8\_.countryname AS countryname\_115, s8\_.countryiso AS countryiso\_116, s8\_.countryen AS countryen\_117, s8\_.position AS position\_118, s8\_.notice AS notice\_119, s8\_.shippingfree AS shippingfree\_120, s8\_.taxfree AS taxfree\_121, s8\_.taxfree\_ustid AS taxfree\_ustid\_122, s8\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_123, s8\_.active AS active\_124, s8\_.iso3 AS iso3\_125, s8\_.display\_state\_in\_registration AS display\_state\_in\_registration\_126, s8\_.force\_state\_in\_registration AS force\_state\_in\_registration\_127, s8\_.areaID AS areaID\_128, s9\_.id AS id\_129, s9\_.countryID AS countryID\_130, s9\_.position AS position\_131, s9\_.name AS name\_132, s9\_.shortcode AS shortcode\_133, s9\_.active AS active\_134, s10\_.id AS id\_135, s10\_.countryID AS countryID\_136, s10\_.position AS position\_137, s10\_.name AS name\_138, s10\_.shortcode AS shortcode\_139, s10\_.active AS active\_140 FROM s\_user s0\_ LEFT JOIN s\_user\_attributes s1\_ ON s0\_.id = s1\_.userID LEFT JOIN s\_user\_addresses s2\_ ON s0\_.default\_billing\_address\_id = s2\_.id LEFT JOIN s\_core\_payment\_data s3\_ ON s0\_.id = s3\_.user\_id AND (s3\_.payment\_mean\_id = s0\_.paymentID) LEFT JOIN s\_user\_addresses\_attributes s4\_ ON s2\_.id = s4\_.address\_id LEFT JOIN s\_user\_addresses s5\_ ON s0\_.default\_shipping\_address\_id = s5\_.id LEFT JOIN s\_user\_addresses\_attributes s6\_ ON s5\_.id = s6\_.address\_id LEFT JOIN s\_core\_countries s7\_ ON s2\_.country\_id = s7\_.id LEFT JOIN s\_core\_countries s8\_ ON s5\_.country\_id = s8\_.id LEFT JOIN s\_core\_countries\_states s9\_ ON s2\_.state\_id = s9\_.id LEFT JOIN s\_core\_countries\_states s10\_ ON s5\_.state\_id = s10\_.id WHERE s0\_.id = ?’ with params [40735]: SQLSTATE[42S22]: **Column not found: 1054 Unknown column ‘s1\_.sofort\_ideal\_bank’ in 'field list’** ---
**Author:** ![malzfons](https://avatars.discourse-cdn.com/v4/letter/m/58956e/32.png) [@malzfons](https://forum.shopware.com/u/malzfons)\ **Post date:** [22. November 2017 um 19:28 UTC](https://forum.shopware.com/t/actindo-fehler-beim-wechsel-des-sofort-plugins-column-not-found-1054-unknown-column-s1-sofort-id/49637/2 "2017-11-22T19:28:44Z")
Keine ahnung. Da die sofort plugs immer schon ärger machten kommt für uns nur noch sofort via stripe in frage. Läuft ohne jegliche probleme. ---
**Author:** ![bluewolf](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/bluewolf/32/7886_2.png) [@bluewolf](https://forum.shopware.com/u/bluewolf)\ **Post date:** [23. November 2017 um 07:28 UTC](https://forum.shopware.com/t/actindo-fehler-beim-wechsel-des-sofort-plugins-column-not-found-1054-unknown-column-s1-sofort-id/49637/3 "2017-11-23T07:28:15Z")
> [@malzfons schrieb:](https://forum.shopware.com/profile/22034/malzfons "malzfons") > > Keine ahnung. Da die sofort plugs immer schon ärger machten kommt für uns nur noch sofort via stripe in frage. Läuft ohne jegliche probleme. Eigentlich suchte ich nach hilfreichen Antworten…