Hallo!
Ist dieser Fehler oder ein Fix schon bekannt?
Kommt gleich nach Starten des Webshopabgleichs.
Danke!
German
Wawi-Version: 0.9.9.962
====================
Fehler:
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id0 FROM (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, s1_.id AS id28, s1_.paymentID AS paymentID29, s1_.customergroup AS customergroup30, s1_.subshopID AS subshopID31, s1_.pricegroupID AS pricegroupID32, s1_.encoder AS encoder33, s1_.password AS password34, s1_.active AS active35, s1_.email AS email36, s1_.firstlogin AS firstlogin37, s1_.lastlogin AS lastlogin38, s1_.accountmode AS accountmode39, s1_.confirmationkey AS confirmationkey40, s1_.sessionID AS sessionID41, s1_.newsletter AS newsletter42, s1_.validation AS validation43, s1_.affiliate AS affiliate44, s1_.paymentpreset AS paymentpreset45, s1_.language AS language46, s1_.referer AS referer47, s1_.internalcomment AS internalcomment48, s1_.failedlogins AS failedlogins49, s1_.lockedUntil AS lockedUntil50, s2_.id AS id51, s2_.orderID AS orderID52, s2_.attribute1 AS attribute153, s2_.attribute2 AS attribute254, s2_.attribute3 AS attribute355, s2_.attribute4 AS attribute456, s2_.attribute5 AS attribute557, s2_.attribute6 AS attribute658, s3_.id AS id59, s3_.orderID AS orderID60, s3_.articleID AS articleID61, s3_.taxID AS taxID62, s3_.tax_rate AS tax_rate63, s3_.status AS status64, s3_.ordernumber AS ordernumber65, s3_.articleordernumber AS articleordernumber66, s3_.price AS price67, s3_.quantity AS quantity68, s3_.name AS name69, s3_.shipped AS shipped70, s3_.shippedgroup AS shippedgroup71, s3_.releasedate AS releasedate72, s3_.modus AS modus73, s3_.esdarticle AS esdarticle74, s3_.config AS config75, s3_.ean AS ean76, s3_.unit AS unit77, s3_.pack_unit AS pack_unit78, s4_.id AS id79, s4_.tax AS tax80, s4_.description AS description81, s5_.id AS id82, s5_.orderID AS orderID83, s5_.userID AS userID84, s5_.countryID AS countryID85, s5_.company AS company86, s5_.department AS department87, s5_.salutation AS salutation88, s5_.customernumber AS customernumber89, s5_.firstname AS firstname90, s5_.lastname AS lastname91, s5_.street AS street92, s5_.streetnumber AS streetnumber93, s5_.zipcode AS zipcode94, s5_.city AS city95, s5_.phone AS phone96, s5_.fax AS fax97, s5_.ustid AS ustid98, s6_.id AS id99, s6_.orderID AS orderID100, s6_.countryID AS countryID101, s6_.userID AS userID102, s6_.company AS company103, s6_.department AS department104, s6_.salutation AS salutation105, s6_.firstname AS firstname106, s6_.lastname AS lastname107, s6_.street AS street108, s6_.streetnumber AS streetnumber109, s6_.zipcode AS zipcode110, s6_.city AS city111, s7_.id AS id112, s7_.countryname AS countryname113, s7_.countryiso AS countryiso114, s7_.countryen AS countryen115, s7_.position AS position116, s7_.notice AS notice117, s7_.shippingfree AS shippingfree118, s7_.taxfree AS taxfree119, s7_.taxfree_ustid AS taxfree_ustid120, s7_.taxfree_ustid_checked AS taxfree_ustid_checked121, s7_.active AS active122, s7_.iso3 AS iso3123, s7_.display_state_in_registration AS display_state_in_registration124, s7_.force_state_in_registration AS force_state_in_registration125, s7_.areaID AS areaID126, s8_.id AS id127, s8_.countryname AS countryname128, s8_.countryiso AS countryiso129, s8_.countryen AS countryen130, s8_.position AS position131, s8_.notice AS notice132, s8_.shippingfree AS shippingfree133, s8_.taxfree AS taxfree134, s8_.taxfree_ustid AS taxfree_ustid135, s8_.taxfree_ustid_checked AS taxfree_ustid_checked136, s8_.active AS active137, s8_.iso3 AS iso3138, s8_.display_state_in_registration AS display_state_in_registration139, s8_.force_state_in_registration AS force_state_in_registration140, s8_.areaID AS areaID141, s9_.id AS id142, s9_.orderID AS orderID143, s9_.userID AS userID144, s9_.previous_order_status_id AS previous_order_status_id145, s9_.order_status_id AS order_status_id146, s9_.previous_payment_status_id AS previous_payment_status_id147, s9_.payment_status_id AS payment_status_id148, s9_.comment AS comment149, s9_.change_date AS change_date150, s10_.id AS id151, s10_.name AS name152, s10_.description AS description153, s10_.template AS template154, s10_.class AS class155, s10_.`table` AS table156, s10_.hide AS hide157, s10_.additionaldescription AS additionaldescription158, s10_.debit_percent AS debit_percent159, s10_.surcharge AS surcharge160, s10_.surchargestring AS surchargestring161, s10_.position AS position162, s10_.active AS active163, s10_.esdactive AS esdactive164, s10_.embediframe AS embediframe165, s10_.hideprospect AS hideprospect166, s10_.action AS action167, s10_.pluginID AS pluginID168, s10_.source AS source169, s11_.id AS id170, s11_.name AS name171, s11_.type AS type172, s11_.description AS description173, s11_.comment AS comment174, s11_.active AS active175, s11_.position AS position176, s11_.calculation AS calculation177, s11_.surcharge_calculation AS surcharge_calculation178, s11_.tax_calculation AS tax_calculation179, s11_.shippingfree AS shippingfree180, s11_.multishopID AS multishopID181, s11_.customergroupID AS customergroupID182, s11_.bind_shippingFree AS bind_shippingFree183, s11_.bind_time_from AS bind_time_from184, s11_.bind_time_to AS bind_time_to185, s11_.bind_instock AS bind_instock186, s11_.bind_laststock AS bind_laststock187, s11_.bind_weekday_from AS bind_weekday_from188, s11_.bind_weekday_to AS bind_weekday_to189, s11_.bind_weight_from AS bind_weight_from190, s11_.bind_weight_to AS bind_weight_to191, s11_.bind_price_from AS bind_price_from192, s11_.bind_price_to AS bind_price_to193, s11_.bind_sql AS bind_sql194, s11_.status_link AS status_link195, s11_.calculation_sql AS calculation_sql196 FROM s_order s0_ LEFT JOIN jtl_connector_link_order j12_ ON s0_.id = j12_.order_id LEFT JOIN s_user s1_ ON s0_.userID = s1_.id LEFT JOIN s_order_attributes s2_ ON s0_.id = s2_.orderID LEFT JOIN s_order_details s3_ ON s0_.id = s3_.orderID LEFT JOIN s_core_tax s4_ ON s3_.taxID = s4_.id LEFT JOIN s_order_billingaddress s5_ ON s0_.id = s5_.orderID LEFT JOIN s_order_shippingaddress s6_ ON s0_.id = s6_.orderID LEFT JOIN s_core_countries s7_ ON s5_.countryID = s7_.id LEFT JOIN s_core_countries s8_ ON s6_.countryID = s8_.id LEFT JOIN s_order_history s9_ ON s0_.id = s9_.orderID LEFT JOIN s_core_paymentmeans s10_ ON s0_.paymentID = s10_.id LEFT JOIN s_premium_dispatch s11_ ON s0_.dispatchID = s11_.id WHERE j12_.host_id IS NULL AND s0_.status <> -1 ORDER BY s9_.change_date ASC) dctrn_result) dctrn_table':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's3_.ean' in 'field list'
Ist dieser Fehler oder ein Fix schon bekannt?
Kommt gleich nach Starten des Webshopabgleichs.
Danke!
German
Wawi-Version: 0.9.9.962
====================
Fehler:
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id0 FROM (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, s1_.id AS id28, s1_.paymentID AS paymentID29, s1_.customergroup AS customergroup30, s1_.subshopID AS subshopID31, s1_.pricegroupID AS pricegroupID32, s1_.encoder AS encoder33, s1_.password AS password34, s1_.active AS active35, s1_.email AS email36, s1_.firstlogin AS firstlogin37, s1_.lastlogin AS lastlogin38, s1_.accountmode AS accountmode39, s1_.confirmationkey AS confirmationkey40, s1_.sessionID AS sessionID41, s1_.newsletter AS newsletter42, s1_.validation AS validation43, s1_.affiliate AS affiliate44, s1_.paymentpreset AS paymentpreset45, s1_.language AS language46, s1_.referer AS referer47, s1_.internalcomment AS internalcomment48, s1_.failedlogins AS failedlogins49, s1_.lockedUntil AS lockedUntil50, s2_.id AS id51, s2_.orderID AS orderID52, s2_.attribute1 AS attribute153, s2_.attribute2 AS attribute254, s2_.attribute3 AS attribute355, s2_.attribute4 AS attribute456, s2_.attribute5 AS attribute557, s2_.attribute6 AS attribute658, s3_.id AS id59, s3_.orderID AS orderID60, s3_.articleID AS articleID61, s3_.taxID AS taxID62, s3_.tax_rate AS tax_rate63, s3_.status AS status64, s3_.ordernumber AS ordernumber65, s3_.articleordernumber AS articleordernumber66, s3_.price AS price67, s3_.quantity AS quantity68, s3_.name AS name69, s3_.shipped AS shipped70, s3_.shippedgroup AS shippedgroup71, s3_.releasedate AS releasedate72, s3_.modus AS modus73, s3_.esdarticle AS esdarticle74, s3_.config AS config75, s3_.ean AS ean76, s3_.unit AS unit77, s3_.pack_unit AS pack_unit78, s4_.id AS id79, s4_.tax AS tax80, s4_.description AS description81, s5_.id AS id82, s5_.orderID AS orderID83, s5_.userID AS userID84, s5_.countryID AS countryID85, s5_.company AS company86, s5_.department AS department87, s5_.salutation AS salutation88, s5_.customernumber AS customernumber89, s5_.firstname AS firstname90, s5_.lastname AS lastname91, s5_.street AS street92, s5_.streetnumber AS streetnumber93, s5_.zipcode AS zipcode94, s5_.city AS city95, s5_.phone AS phone96, s5_.fax AS fax97, s5_.ustid AS ustid98, s6_.id AS id99, s6_.orderID AS orderID100, s6_.countryID AS countryID101, s6_.userID AS userID102, s6_.company AS company103, s6_.department AS department104, s6_.salutation AS salutation105, s6_.firstname AS firstname106, s6_.lastname AS lastname107, s6_.street AS street108, s6_.streetnumber AS streetnumber109, s6_.zipcode AS zipcode110, s6_.city AS city111, s7_.id AS id112, s7_.countryname AS countryname113, s7_.countryiso AS countryiso114, s7_.countryen AS countryen115, s7_.position AS position116, s7_.notice AS notice117, s7_.shippingfree AS shippingfree118, s7_.taxfree AS taxfree119, s7_.taxfree_ustid AS taxfree_ustid120, s7_.taxfree_ustid_checked AS taxfree_ustid_checked121, s7_.active AS active122, s7_.iso3 AS iso3123, s7_.display_state_in_registration AS display_state_in_registration124, s7_.force_state_in_registration AS force_state_in_registration125, s7_.areaID AS areaID126, s8_.id AS id127, s8_.countryname AS countryname128, s8_.countryiso AS countryiso129, s8_.countryen AS countryen130, s8_.position AS position131, s8_.notice AS notice132, s8_.shippingfree AS shippingfree133, s8_.taxfree AS taxfree134, s8_.taxfree_ustid AS taxfree_ustid135, s8_.taxfree_ustid_checked AS taxfree_ustid_checked136, s8_.active AS active137, s8_.iso3 AS iso3138, s8_.display_state_in_registration AS display_state_in_registration139, s8_.force_state_in_registration AS force_state_in_registration140, s8_.areaID AS areaID141, s9_.id AS id142, s9_.orderID AS orderID143, s9_.userID AS userID144, s9_.previous_order_status_id AS previous_order_status_id145, s9_.order_status_id AS order_status_id146, s9_.previous_payment_status_id AS previous_payment_status_id147, s9_.payment_status_id AS payment_status_id148, s9_.comment AS comment149, s9_.change_date AS change_date150, s10_.id AS id151, s10_.name AS name152, s10_.description AS description153, s10_.template AS template154, s10_.class AS class155, s10_.`table` AS table156, s10_.hide AS hide157, s10_.additionaldescription AS additionaldescription158, s10_.debit_percent AS debit_percent159, s10_.surcharge AS surcharge160, s10_.surchargestring AS surchargestring161, s10_.position AS position162, s10_.active AS active163, s10_.esdactive AS esdactive164, s10_.embediframe AS embediframe165, s10_.hideprospect AS hideprospect166, s10_.action AS action167, s10_.pluginID AS pluginID168, s10_.source AS source169, s11_.id AS id170, s11_.name AS name171, s11_.type AS type172, s11_.description AS description173, s11_.comment AS comment174, s11_.active AS active175, s11_.position AS position176, s11_.calculation AS calculation177, s11_.surcharge_calculation AS surcharge_calculation178, s11_.tax_calculation AS tax_calculation179, s11_.shippingfree AS shippingfree180, s11_.multishopID AS multishopID181, s11_.customergroupID AS customergroupID182, s11_.bind_shippingFree AS bind_shippingFree183, s11_.bind_time_from AS bind_time_from184, s11_.bind_time_to AS bind_time_to185, s11_.bind_instock AS bind_instock186, s11_.bind_laststock AS bind_laststock187, s11_.bind_weekday_from AS bind_weekday_from188, s11_.bind_weekday_to AS bind_weekday_to189, s11_.bind_weight_from AS bind_weight_from190, s11_.bind_weight_to AS bind_weight_to191, s11_.bind_price_from AS bind_price_from192, s11_.bind_price_to AS bind_price_to193, s11_.bind_sql AS bind_sql194, s11_.status_link AS status_link195, s11_.calculation_sql AS calculation_sql196 FROM s_order s0_ LEFT JOIN jtl_connector_link_order j12_ ON s0_.id = j12_.order_id LEFT JOIN s_user s1_ ON s0_.userID = s1_.id LEFT JOIN s_order_attributes s2_ ON s0_.id = s2_.orderID LEFT JOIN s_order_details s3_ ON s0_.id = s3_.orderID LEFT JOIN s_core_tax s4_ ON s3_.taxID = s4_.id LEFT JOIN s_order_billingaddress s5_ ON s0_.id = s5_.orderID LEFT JOIN s_order_shippingaddress s6_ ON s0_.id = s6_.orderID LEFT JOIN s_core_countries s7_ ON s5_.countryID = s7_.id LEFT JOIN s_core_countries s8_ ON s6_.countryID = s8_.id LEFT JOIN s_order_history s9_ ON s0_.id = s9_.orderID LEFT JOIN s_core_paymentmeans s10_ ON s0_.paymentID = s10_.id LEFT JOIN s_premium_dispatch s11_ ON s0_.dispatchID = s11_.id WHERE j12_.host_id IS NULL AND s0_.status <> -1 ORDER BY s9_.change_date ASC) dctrn_result) dctrn_table':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's3_.ean' in 'field list'
