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’