Gelöst Kein Abgleich mehr möglich...

[Roger_Han]

Hallo,

test grad Shopware mit JTL Wawi, bisher hat alles funktioniert. Heute bekam ich jedoch diese Fehlermeldung.
Woran könnte das liegen?

Abgleich-Protokoll:
Onlineshop-Abgleich beendet für 'xxx'.


Fehler:
Exception: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.ordernumber AS ordernumber_1, s0_.userID AS userID_2, s0_.status AS status_3, s0_.cleared AS cleared_4, s0_.paymentID AS paymentID_5, s0_.dispatchID AS dispatchID_6, s0_.partnerID AS partnerID_7, s0_.subshopID AS subshopID_8, s0_.invoice_amount AS invoice_amount_9, s0_.invoice_amount_net AS invoice_amount_net_10, s0_.invoice_shipping AS invoice_shipping_11, s0_.invoice_shipping_net AS invoice_shipping_net_12, s0_.ordertime AS ordertime_13, s0_.transactionID AS transactionID_14, s0_.comment AS comment_15, s0_.customercomment AS customercomment_16, s0_.internalcomment AS internalcomment_17, s0_.net AS net_18, s0_.taxfree AS taxfree_19, s0_.temporaryID AS temporaryID_20, s0_.referer AS referer_21, s0_.cleareddate AS cleareddate_22, s0_.trackingcode AS trackingcode_23, s0_.language AS language_24, s0_.currency AS currency_25, s0_.currencyfactor AS currencyfactor_26, s0_.remote_addr AS remote_addr_27, s0_.deviceType AS deviceType_28, s1_.id AS id_29, s1_.paymentID AS paymentID_30, s1_.customergroup AS customergroup_31, s1_.subshopID AS subshopID_32, s1_.pricegroupID AS pricegroupID_33, s1_.encoder AS encoder_34, s1_.password AS password_35, s1_.active AS active_36, s1_.email AS email_37, s1_.firstlogin AS firstlogin_38, s1_.lastlogin AS lastlogin_39, s1_.accountmode AS accountmode_40, s1_.confirmationkey AS confirmationkey_41, s1_.sessionID AS sessionID_42, s1_.newsletter AS newsletter_43, s1_.validation AS validation_44, s1_.affiliate AS affiliate_45, s1_.paymentpreset AS paymentpreset_46, s1_.language AS language_47, s1_.referer AS referer_48, s1_.internalcomment AS internalcomment_49, s1_.failedlogins AS failedlogins_50, s1_.lockedUntil AS lockedUntil_51, s1_.salutation AS salutation_52, s1_.title AS title_53, s1_.firstname AS firstname_54, s1_.customernumber AS customernumber_55, s1_.lastname AS lastname_56, s1_.birthday AS birthday_57, s2_.id AS id_58, s2_.userID AS userID_59, s2_.company AS company_60, s2_.department AS department_61, s2_.salutation AS salutation_62, s2_.title AS title_63, s2_.firstname AS firstname_64, s2_.lastname AS lastname_65, s2_.street AS street_66, s2_.zipcode AS zipcode_67, s2_.city AS city_68, s2_.stateID AS stateID_69, s2_.countryID AS countryID_70, s2_.additional_address_line1 AS additional_address_line1_71, s2_.additional_address_line2 AS additional_address_line2_72, s3_.id AS id_73, s3_.shippingID AS shippingID_74, s3_.text1 AS text1_75, s3_.text2 AS text2_76, s3_.text3 AS text3_77, s3_.text4 AS text4_78, s3_.text5 AS text5_79, s3_.text6 AS text6_80, s4_.id AS id_81, s4_.payment_mean_id AS payment_mean_id_82, s4_.use_billing_data AS use_billing_data_83, s4_.bankname AS bankname_84, s4_.bic AS bic_85, s4_.iban AS iban_86, s4_.account_number AS account_number_87, s4_.bank_code AS bank_code_88, s4_.account_holder AS account_holder_89, s4_.created_at AS created_at_90, s5_.id AS id_91, s5_.orderID AS orderID_92, s5_.attribute1 AS attribute1_93, s5_.attribute2 AS attribute2_94, s5_.attribute3 AS attribute3_95, s5_.attribute4 AS attribute4_96, s5_.attribute5 AS attribute5_97, s5_.attribute6 AS attribute6_98, s5_.swag_payal_billing_agreement_id AS swag_payal_billing_agreement_id_99, s5_.swag_payal_express AS swag_payal_express_100, s5_.hm_order_id AS hm_order_id_101, s5_.bestit_amazon_capture_id AS bestit_amazon_capture_id_102, s5_.bestit_amazon_capture_reference AS bestit_amazon_capture_reference_103, s5_.bestit_amazon_authorization_id AS bestit_amazon_authorization_id_104, s5_.bestit_amazon_authorisation_reference AS bestit_amazon_authorisation_reference_105, s5_.bestit_amazon_refund_id AS bestit_amazon_refund_id_106, s5_.bestit_amazon_refund_reference AS bestit_amazon_refund_reference_107, s5_.bestit_amazon_cancel AS bestit_amazon_cancel_108, s5_.bestit_amazon_invoice_amount AS bestit_amazon_invoice_amount_109, s5_.bestit_amazon_simulation_code AS bestit_amazon_simulation_code_110, s5_.ott_idealo_ordernumber AS ott_idealo_ordernumber_111, s5_.payever_payment_details AS payever_payment_details_112, s6_.id AS id_113, s6_.orderID AS orderID_114, s6_.articleID AS articleID_115, s6_.taxID AS taxID_116, s6_.tax_rate AS tax_rate_117, s6_.status AS status_118, s6_.ordernumber AS ordernumber_119, s6_.articleordernumber AS articleordernumber_120, s6_.price AS price_121, s6_.quantity AS quantity_122, s6_.name AS name_123, s6_.shipped AS shipped_124, s6_.shippedgroup AS shippedgroup_125, s6_.releasedate AS releasedate_126, s6_.modus AS modus_127, s6_.esdarticle AS esdarticle_128, s6_.config AS config_129, s6_.ean AS ean_130, s6_.unit AS unit_131, s6_.pack_unit AS pack_unit_132, s7_.id AS id_133, s7_.tax AS tax_134, s7_.description AS description_135, s8_.id AS id_136, s8_.orderID AS orderID_137, s8_.userID AS userID_138, s8_.countryID AS countryID_139, s8_.stateID AS stateID_140, s8_.company AS company_141, s8_.department AS department_142, s8_.salutation AS salutation_143, s8_.title AS title_144, s8_.customernumber AS customernumber_145, s8_.firstname AS firstname_146, s8_.lastname AS lastname_147, s8_.street AS street_148, s8_.zipcode AS zipcode_149, s8_.city AS city_150, s8_.phone AS phone_151, s8_.ustid AS ustid_152, s8_.additional_address_line1 AS additional_address_line1_153, s8_.additional_address_line2 AS additional_address_line2_154, s9_.id AS id_155, s9_.orderID AS orderID_156, s9_.countryID AS countryID_157, s9_.stateID AS stateID_158, s9_.userID AS userID_159, s9_.company AS company_160, s9_.department AS department_161, s9_.salutation AS salutation_162, s9_.firstname AS firstname_163, s9_.title AS title_164, s9_.lastname AS lastname_165, s9_.street AS street_166, s9_.zipcode AS zipcode_167, s9_.city AS city_168, s9_.additional_address_line1 AS additional_address_line1_169, s9_.additional_address_line2 AS additional_address_line2_170, s10_.id AS id_171, s10_.countryname AS countryname_172, s10_.countryiso AS countryiso_173, s10_.countryen AS countryen_174, s10_.position AS position_175, s10_.notice AS notice_176, s10_.shippingfree AS shippingfree_177, s10_.taxfree AS taxfree_178, s10_.taxfree_ustid AS taxfree_ustid_179, s10_.taxfree_ustid_checked AS taxfree_ustid_checked_180, s10_.active AS active_181, s10_.iso3 AS iso3_182, s10_.display_state_in_registration AS display_state_in_registration_183, s10_.force_state_in_registration AS force_state_in_registration_184, s10_.areaID AS areaID_185, s11_.id AS id_186, s11_.countryname AS countryname_187, s11_.countryiso AS countryiso_188, s11_.countryen AS countryen_189, s11_.position AS position_190, s11_.notice AS notice_191, s11_.shippingfree AS shippingfree_192, s11_.taxfree AS taxfree_193, s11_.taxfree_ustid AS taxfree_ustid_194, s11_.taxfree_ustid_checked AS taxfree_ustid_checked_195, s11_.active AS active_196, s11_.iso3 AS iso3_197, s11_.display_state_in_registration AS display_state_in_registration_198, s11_.force_state_in_registration AS force_state_in_registration_199, s11_.areaID AS areaID_200, s12_.id AS id_201, s12_.orderID AS orderID_202, s12_.userID AS userID_203, s12_.previous_order_status_id AS previous_order_status_id_204, s12_.order_status_id AS order_status_id_205, s12_.previous_payment_status_id AS previous_payment_status_id_206, s12_.payment_status_id AS payment_status_id_207, s12_.comment AS comment_208, s12_.change_date AS change_date_209, s13_.id AS id_210, s13_.name AS name_211, s13_.description AS description_212, s13_.template AS template_213, s13_.class AS class_214, s13_.`table` AS table_215, s13_.hide AS hide_216, s13_.additionaldescription AS additionaldescription_217, s13_.debit_percent AS debit_percent_218, s13_.surcharge AS surcharge_219, s13_.surchargestring AS surchargestring_220, s13_.position AS position_221, s13_.active AS active_222, s13_.esdactive AS esdactive_223, s13_.mobile_inactive AS mobile_inactive_224, s13_.embediframe AS embediframe_225, s13_.hideprospect AS hideprospect_226, s13_.action AS action_227, s13_.pluginID AS pluginID_228, s13_.source AS source_229, s14_.id AS id_230,

Fehlermeldung ist gekürtzt, da länger als 10000 Zeichen.

Kann, das evtl. an neuinstallierten Plugins liegen?

 

[Daniel B.]

Wenn es vorher funktioniert hat, muss etwas zwischendurch passiert sein. Hast du vlt. etwas geupdated? Oder etwas im Shop Backend eingestellt? Ein Plugin installiert oder sowas?