Neu Fehlermeldung beim ersten Onlineshop-Abgleich

RenéLi

Neues Mitglied
29. Dezember 2020
1
0
Hallo,
ich erhalte folgende Fehlermeldung:
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_.changed AS changed_1, s0_.ordernumber AS ordernumber_2, s0_.userID AS userID_3, s0_.status AS status_4, s0_.cleared AS cleared_5, s0_.paymentID AS paymentID_6, s0_.dispatchID AS dispatchID_7, s0_.partnerID AS partnerID_8, s0_.subshopID AS subshopID_9, s0_.invoice_amount AS invoice_amount_10, s0_.invoice_amount_net AS invoice_amount_net_11, s0_.invoice_shipping AS invoice_shipping_12, s0_.invoice_shipping_net AS invoice_shipping_net_13, s0_.invoice_shipping_tax_rate AS invoice_shipping_tax_rate_14, s0_.ordertime AS ordertime_15, s0_.transactionID AS transactionID_16, s0_.comment AS comment_17, s0_.customercomment AS customercomment_18, s0_.internalcomment AS internalcomment_19, s0_.net AS net_20, s0_.taxfree AS taxfree_21, s0_.temporaryID AS temporaryID_22, s0_.referer AS referer_23, s0_.cleareddate AS cleareddate_24, s0_.trackingcode AS trackingcode_25, s0_.language AS language_26, s0_.currency AS currency_27, s0_.currencyfactor AS currencyfactor_28, s0_.remote_addr AS remote_addr_29, s0_.deviceType AS deviceType_30, s0_.is_proportional_calculation AS is_proportional_calculation_31, s1_.customernumber AS customernumber_32, s1_.id AS id_33, s1_.changed AS changed_34, s1_.paymentID AS paymentID_35, s1_.customergroup AS customergroup_36, s1_.subshopID AS subshopID_37, s1_.pricegroupID AS pricegroupID_38, s1_.encoder AS encoder_39, s1_.password AS password_40, s1_.active AS active_41, s1_.email AS email_42, s1_.firstlogin AS firstlogin_43, s1_.lastlogin AS lastlogin_44, s1_.accountmode AS accountmode_45, s1_.confirmationkey AS confirmationkey_46, s1_.sessionID AS sessionID_47, s1_.newsletter AS newsletter_48, s1_.validation AS validation_49, s1_.affiliate AS affiliate_50, s1_.paymentpreset AS paymentpreset_51, s1_.language AS language_52, s1_.referer AS referer_53, s1_.internalcomment AS internalcomment_54, s1_.failedlogins AS failedlogins_55, s1_.lockedUntil AS lockedUntil_56, s1_.salutation AS salutation_57, s1_.title AS title_58, s1_.firstname AS firstname_59, s1_.lastname AS lastname_60, s1_.birthday AS birthday_61, s1_.doubleOptinRegister AS doubleOptinRegister_62, s1_.doubleOptinEmailSentDate AS doubleOptinEmailSentDate_63, s1_.doubleOptinConfirmDate AS doubleOptinConfirmDate_64, s1_.password_change_date AS password_change_date_65, s1_.register_opt_in_id AS register_opt_in_id_66, s2_.id AS id_67, s2_.company AS company_68, s2_.department AS department_69, s2_.salutation AS salutation_70, s2_.firstname AS firstname_71, s2_.title AS title_72, s2_.lastname AS lastname_73, s2_.street AS street_74, s2_.zipcode AS zipcode_75, s2_.city AS city_76, s2_.phone AS phone_77, s2_.ustid AS ustid_78, s2_.additional_address_line1 AS additional_address_line1_79, s2_.additional_address_line2 AS additional_address_line2_80, s2_.country_id AS country_id_81, s2_.state_id AS state_id_82, s3_.id AS id_83, s3_.address_id AS address_id_84, s3_.text1 AS text1_85, s3_.text2 AS text2_86, s3_.text3 AS text3_87, s3_.text4 AS text4_88, s3_.text5 AS text5_89, s3_.text6 AS text6_90, s4_.payment_mean_id AS payment_mean_id_91, s4_.use_billing_data AS use_billing_data_92, s4_.bankname AS bankname_93, s4_.bic AS bic_94, s4_.iban AS iban_95, s4_.account_number AS account_number_96, s4_.bank_code AS bank_code_97, s4_.account_holder AS account_holder_98, s4_.created_at AS created_at_99, s4_.id AS id_100, s5_.id AS id_101, s5_.orderID AS orderID_102, s5_.attribute1 AS attribute1_103, s5_.attribute2 AS attribute2_104, s5_.attribute3 AS attribute3_105, s5_.attribute4 AS attribute4_106, s5_.attribute5 AS attribute5_107, s5_.attribute6 AS attribute6_108, s5_.swag_paypal_unified_payment_type AS swag_paypal_unified_payment_type_109, s6_.id AS id_110, s6_.orderID AS orderID_111, s6_.articleID AS articleID_112, s6_.taxID AS taxID_113, s6_.tax_rate AS tax_rate_114, s6_.status AS status_115, s6_.articleDetailID AS articleDetailID_116, s6_.ordernumber AS ordernumber_117, s6_.articleordernumber AS articleordernumber_118, s6_.price AS price_119, s6_.quantity AS quantity_120, s6_.name AS name_121, s6_.shipped AS shipped_122, s6_.shippedgroup AS shippedgroup_123, s6_.releasedate AS releasedate_124, s6_.modus AS modus_125, s6_.esdarticle AS esdarticle_126, s6_.config AS config_127, s6_.ean AS ean_128, s6_.unit AS unit_129, s6_.pack_unit AS pack_unit_130, s7_.id AS id_131, s7_.tax AS tax_132, s7_.description AS description_133, s8_.title AS title_134, s8_.additional_address_line1 AS additional_address_line1_135, s8_.additional_address_line2 AS additional_address_line2_136, s8_.id AS id_137, s8_.orderID AS orderID_138, s8_.userID AS userID_139, s8_.countryID AS countryID_140, s8_.stateID AS stateID_141, s8_.company AS company_142, s8_.department AS department_143, s8_.salutation AS salutation_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, s9_.title AS title_153, s9_.additional_address_line1 AS additional_address_line1_154, s9_.additional_address_line2 AS additional_address_line2_155, s9_.id AS id_156, s9_.orderID AS orderID_157, s9_.countryID AS countryID_158, s9_.stateID AS stateID_159, s9_.userID AS userID_160, s9_.company AS company_161, s9_.department AS department_162, s9_.salutation AS salutation_163, s9_.firstname AS firstname_164, s9_.lastname AS lastname_165, s9_.street AS street_166, s9_.zipcode AS zipcode_167, s9_.city AS city_168, s9_.phone AS phone_169, s10_.id AS id_170, s10_.countryname AS countryname_171, s10_.countryiso AS countryiso_172, s10_.countryen AS countryen_173, s10_.position AS position_174, s10_.notice AS notice_175, s10_.taxfree AS taxfree_176, s10_.taxfree_ustid AS taxfree_ustid_177, s10_.taxfree_ustid_checked AS taxfree_ustid_checked_178, s10_.active AS active_179, s10_.iso3 AS iso3_180, s10_.display_state_in_registration AS display_state_in_registration_181, s10_.force_state_in_registration AS force_state_in_registration_182, s10_.allow_shipping AS allow_shipping_183, s10_.areaID AS areaID_184, s11_.id AS id_185, s11_.countryname AS countryname_186, s11_.countryiso AS countryiso_187, s11_.countryen AS countryen_188, s11_.position AS position_189, s11_.notice AS notice_190, s11_.taxfree AS taxfree_191, s11_.taxfree_ustid AS taxfree_ustid_192, s11_.taxfree_ustid_checked AS taxfree_ustid_checked_193, s11_.active AS active_194, s11_.iso3 AS iso3_195, s11_.display_state_in_registration AS display_state_in_registration_196, s11_.force_state_in_registration AS force_state_in_registration_197, s11_.allow_shipping AS allow_shipping_198, s11_.areaID AS areaID_199, s12_.id AS id_200, s12_.orderID AS orderID_201, s12_.userID AS userID_202, s12_.previous_order_status_id AS previous_order_status_id_203, s12_.order_status_id AS order_status_id_204, s12_.previous_payment_status_id AS previous_payment_status_id_205, s12_.payment_status_id AS payment_status_id_206, s12_.comment AS comment_207, s12_.change_date AS change_date_208, s13_.id AS id_209, s13_.name AS name_210, s13_.description AS description_211, s13_.template AS template_212, s13_.class AS class_213, s13_.`table` AS table_214, s13_.hide AS hide_215, s13_.additionaldescription AS additionaldescription_216, s13_.debit_percent AS debit_percent_217, s13_.surcharge AS surcharge_218, s13_.surchargestring AS surchargestring_219, s13_.position AS position_220, s13_.active AS active_221, s13_.esdactive AS esdactive_222, s13_.mobile_inactive AS mobile_inactive_223, s13_.embediframe AS embediframe_224, s13_.hideprospect AS hideprospect_225, s13_.action AS action_226, s13_.pluginID AS pluginID_227, s13_.source AS source_228, s14_.id AS id_229, s14_.name AS name_230, s14_.type AS type_231, s14_.description AS description_232, s14_.comment AS comment_233, s14_.active AS active_234, s14_.position AS position_235, s14_.calculation AS calculation_236, s14_.surcharge_calculation AS surcharge_calculation_237, s14_.tax_calculation AS tax_calculation_238, s14_.shippingfree AS shippingfree_239, s14_.multishopID AS multishopID_240, s14_.customergroupID AS customergroupID_241, s14_.bind_shippingFree AS bind_shippingFree_242, s14_.bind_time_from AS bind_time_from_243, s14_.bind_time_to AS bind_time_to_244, s14_.bind_instock AS bind_instock_245, s14_.bind_laststock AS bind_laststock_246, s14_.bind_weekday_from AS bind_weekday_from_247, s14_.bind_weekday_to AS bind_weekday_to_248, s14_.bind_weight_from AS bind_weight_from_249, s14_.bind_weight_to AS bind_weight_to_250, s14_.bind_price_from AS bind_price_from_251, s14_.bind_price_to AS bind_price_to_252, s14_.bind_sql AS bind_sql_253, s14_.status_link AS status_link_254, s14_.calculation_sql AS calculation_sql_255 FROM s_order s0_ LEFT JOIN jtl_connector_link_order j15_ ON s0_.id = j15_.order_id LEFT JOIN s_user s1_ ON s0_.userID = s1_.id LEFT JOIN s_user_addresses s2_ ON s1_.default_shipping_address_id = s2_.id LEFT JOIN s_user_addresses_attributes s3_ ON s2_.id = s3_.address_id LEFT JOIN s_core_payment_data s4_ ON s1_.id = s4_.user_id LEFT JOIN s_order_attributes s5_ ON s0_.id = s5_.orderID INNER JOIN s_order_details s6_ ON s0_.id = s6_.orderID LEFT JOIN s_core_tax s7_ ON s6_.taxID = s7_.id LEFT JOIN s_order_billingaddress s8_ ON s0_.id = s8_.orderID LEFT JOIN s_order_shippingaddress s9_ ON s0_.id = s9_.orderID LEFT JOIN s_core_countries s10_ ON s8_.countryID = s10_.id LEFT JOIN s_core_countries s11_ ON s9_.countryID = s11_.id LEFT JOIN s_order_history s12_ ON s0_.id = s12_.orderID LEFT JOIN s_core_paymentmeans s13_ ON s0_.paymentID = s13_.id LEFT JOIN s_premium_dispatch s14_ ON s0_.dispatchID = s14_.id WHERE j15_.host_id IS NULL AND s0_.status <> -1 AND s0_.id IS NOT NULL ORDER BY s6_.id ASC) dctrn_result) dctrn_table':

SQLSTATE[42S22]: Column not found: 1054 Unkno
 

Enrico W.

Administrator
Mitarbeiter
27. November 2014
8.218
1.608
Statt den Inhalt eines Errrorlogs zu posten kannst du diesen direkt an das Thema anhängen.
Wichtig für das Thema wäre noch zu wissen, um was für einen Shop es sich handelt und in welcher Version er vorliegt.
 
Ähnliche Themen
Titel Forum Antworten Datum
Beim Datei hinzufügen kommt eine Fehlermeldung JTL-Wawi 1.8 5
Neu Fehlermeldung 1101 JTL-ShippingLabels - Fehler und Bugs 1
Neu Versandschein für Schweiz kann nicht gedruckt werden folgende Fehlermeldung JTL-ShippingLabels - Fehler und Bugs 1
Neu fehlermeldung update 1.5 > 1.7 Installation von JTL-Wawi 1
Login Failed Fehlermeldung JTL-Wawi 1.7 1
Bilder Upload und Fehlermeldung WooCommerce-Connector 0
Fehlermeldung nach Speichern vom Auftrag in der Wawi JTL-Wawi 1.6 5
Neu JTL Connector Plugin Aktivierunf [Fehlermeldung] WooCommerce-Connector 1
Neu Fehlermeldung bei Installation (Warning: Cannot declare class Event, because the name is already in use ) Installation / Updates von JTL-Shop 0
Fehlermeldung in der Suche Einrichtung JTL-Shop5 0
Neu Fehlermeldung Allgemeine Fragen zu JTL-Shop 0
Neu ECO DMS - Fehlermeldung im Outlook (Versionsfehler) User helfen Usern 1
Neu beim Umstieg von unicorn auf SCX Bilder aktivieren Otto.de - Anbindung (SCX) 0
Neu Fehler beim Bearbeiten von PLZ & Ort im Kundenkonto (Update 5.3.0) JTL-Shop - Fehler und Bugs 1
Neu Überverkäufe aktiviert doch beim Artikel steht Ausverkauft JTL-Shop - Fehler und Bugs 1
Neu E-Mail-Adresse beim Versand von Lieferantenbestellungen User helfen Usern - Fragen zu JTL-Wawi 0
Fehler beim Rendering der Attribute bei SCX Abgleich kaufland.de - Anbindung (SCX) 1
Neu Fehler beim Zahlungsabgleich - Zahlungsmodul - Wawi 1.5.55.6 Gelöste Themen in diesem Bereich 14
Neu Sendeverzögerung (in Stunden) beim Newsletter Allgemeine Fragen zu JTL-Shop 1
Neu Fehler beim erstellen von Aufträgen. Digitale Unterschrift im Auftrag. JTL-Wawi - Fehler und Bugs 0
In Diskussion Fehler beim Versenden von E-Mails: "Could not convert socket to TLS" JTL-POS - Fehler und Bugs 1
Neu Error beim öffnen von Artikeln und Unterkategorien in zweiter Sprache JTL-Shop - Fehler und Bugs 1
Neu Kann uns jemand beim Otto einrichten helfen? Dienstleistung, Jobs und Ähnliches 3
Gelöst WMS 1.8.11.2 friert beim Starten ein JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 5
Fehler beim Datenbank - JTL WAWI Connector WooCommerce-Connector 1
Neu Mögliche steuerrechtliche Verstöße beim Nutzen der JTL Druckvorlagen Druck-/ E-Mail-/ Exportvorlagen in JTL-Wawi 4
Gelöst Zebra T21 Scanner mit Installierten JTL POS 1.0.9.3 beim Bon versuche Ich einfach zu Scannen er sucht aber kein Artikel JTL-POS - Fehler und Bugs 1
Lieferanten EK wird nicht auf Artikelebene kopiert? EK ist überall 0 beim Artikel. JTL-Wawi 1.8 8
GLN-Nummer beim Kunden hinterlegen JTL-Wawi 1.8 3
Neu Wawi Artikelattribut = externer Link wie am besten darstellen beim Artikel? Allgemeine Fragen zu JTL-Shop 0
Neu Beim duplizieren von Aufträgen werden alte Daten übernommen Arbeitsabläufe in JTL-Wawi 11
Neu Dotliqid Artikelnummer beim letzten Bindestrich aufsplitten User helfen Usern - Fragen zu JTL-Wawi 0
Beschreibung wird beim Import fehlerhaft übernommen JTL-Wawi 1.8 0
Neu Menü, Logo und Suche beim Scrollen anzeigen / Mobilansicht Templates für JTL-Shop 0
Gelöst GLS Probleme beim Erstellen von Versandetiketten Gelöste Themen in diesem Bereich 1
Neu Mehrsprachiges Menü - Beim ersten Seitenaufruf falsche Sprache Gelöste Themen in diesem Bereich 11
Neu Webp Bild aufruf Fehler beim ersten mal laden JTL-Shop - Fehler und Bugs 2
RLIMIT_NPROC is exceeded & fehler 503 beim Abgleich und beim Bestellabschluss Einrichtung JTL-Shop5 0
Neu ebay- Angebote-laufende Angebote: Fehler beim Laden der Daten, der mehrteilige Bezeichner "Custom-fWawiArtikelpreisBrutto" konnte nicht gebunden werde JTL-Wawi - Fehler und Bugs 2
Neu Bitte um Hilfe beim Export/Import von Attributen JTL Ameise - Eigene Exporte 0
Neu Problem beim Update von 5.0.0 auf 5.2.4 (Integrity constraint violation: 1062 Duplicate entry 'COUNTRY_VIEW' for key 'PRIMARY'") Installation / Updates von JTL-Shop 3
Neu Zahlungsart beim Import ändern User helfen Usern - Fragen zu JTL-Wawi 0
Neu Fehler beim Update von Exportformat Google Shopping JTL-Shop - Fehler und Bugs 1
Issue angelegt [WAWI-57041] Identifikation von Amazon-Retouren beim FFN-Partner User helfen Usern - Fragen zu JTL-Wawi 1
Absturz beim Umlagern von Bestellvorschlägen auf die Einkaufsliste JTL-Wawi 1.7 0
In Diskussion Kassenschublade öffnet nicht beim ersten Vorgang des Tages. JTL-POS - Fehler und Bugs 10
Fehler beim Artikelupload nach Ebay 21917328, 21916619, 21916970, 21919420 JTL WAWI 1.7.12.1 JTL-Wawi 1.7 0
Worker in der 1.7.15.3 hängt ständig beim Shopabgleich JTL-Wawi 1.7 18
Neu Auswahl der Charge beim Verpacken Arbeitsabläufe in JTL-WMS / JTL-Packtisch+ 0
Neu Vorgabeplätze beim Nachschub anzeigen Arbeitsabläufe in JTL-WMS / JTL-Packtisch+ 0

Ähnliche Themen