Hallo allerseits
Nach dem Import über das Migrationstool meiner Bestellungen aus einem Xtcommerce 3.04 Shop, erhalte ich beim Klick auf “Bestellungen” leider nur folgende Fehlermeldung. Da ich keinerlei Ahnung habe, was diese Fehlermeldung mir sagen möchte, hoffe ich, dass mir hier jemand einen Tipp hat.
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing '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_.customernumber AS customernumber_29, s1_.id AS id_30, s1_.paymentID AS paymentID_31, s1_.customergroup AS customergroup_32, s1_.subshopID AS subshopID_33, s1_.pricegroupID AS pricegroupID_34, s1_.encoder AS encoder_35, s1_.password AS password_36, s1_.active AS active_37, s1_.email AS email_38, s1_.firstlogin AS firstlogin_39, s1_.lastlogin AS lastlogin_40, s1_.accountmode AS accountmode_41, s1_.confirmationkey AS confirmationkey_42, s1_.sessionID AS sessionID_43, s1_.newsletter AS newsletter_44, s1_.validation AS validation_45, s1_.affiliate AS affiliate_46, s1_.paymentpreset AS paymentpreset_47, s1_.language AS language_48, s1_.referer AS referer_49, s1_.internalcomment AS internalcomment_50, s1_.failedlogins AS failedlogins_51, s1_.lockedUntil AS lockedUntil_52, s1_.salutation AS salutation_53, s1_.title AS title_54, s1_.firstname AS firstname_55, s1_.lastname AS lastname_56, s1_.birthday AS birthday_57, s1_.doubleOptinRegister AS doubleOptinRegister_58, s1_.doubleOptinEmailSentDate AS doubleOptinEmailSentDate_59, s1_.doubleOptinConfirmDate AS doubleOptinConfirmDate_60, s2_.title AS title_61, s2_.additional_address_line1 AS additional_address_line1_62, s2_.additional_address_line2 AS additional_address_line2_63, s2_.id AS id_64, s2_.orderID AS orderID_65, s2_.countryID AS countryID_66, s2_.stateID AS stateID_67, s2_.userID AS userID_68, s2_.company AS company_69, s2_.department AS department_70, s2_.salutation AS salutation_71, s2_.firstname AS firstname_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, s3_.id AS id_78, s3_.countryID AS countryID_79, s3_.position AS position_80, s3_.name AS name_81, s3_.shortcode AS shortcode_82, s3_.active AS active_83, s4_.id AS id_84, s4_.countryname AS countryname_85, s4_.countryiso AS countryiso_86, s4_.countryen AS countryen_87, s4_.position AS position_88, s4_.notice AS notice_89, s4_.taxfree AS taxfree_90, s4_.taxfree_ustid AS taxfree_ustid_91, s4_.taxfree_ustid_checked AS taxfree_ustid_checked_92, s4_.active AS active_93, s4_.iso3 AS iso3_94, s4_.display_state_in_registration AS display_state_in_registration_95, s4_.force_state_in_registration AS force_state_in_registration_96, s4_.areaID AS areaID_97, s5_.id AS id_98, s5_.main_id AS main_id_99, s5_.category_id AS category_id_100, s5_.name AS name_101, s5_.title AS title_102, s5_.position AS position_103, s5_.host AS host_104, s5_.base_path AS base_path_105, s5_.base_url AS base_url_106, s5_.hosts AS hosts_107, s5_.secure AS secure_108, s5_.template_id AS template_id_109, s5_.`default` AS default_110, s5_.active AS active_111, s5_.customer_scope AS customer_scope_112, s6_.id AS id_113, s6_.locale AS locale_114, s6_.language AS language_115, s6_.territory AS territory_116, s7_.id AS id_117, s7_.name AS name_118, s7_.description AS description_119, s7_.template AS template_120, s7_.class AS class_121, s7_.`table` AS table_122, s7_.hide AS hide_123, s7_.additionaldescription AS additionaldescription_124, s7_.debit_percent AS debit_percent_125, s7_.surcharge AS surcharge_126, s7_.surchargestring AS surchargestring_127, s7_.position AS position_128, s7_.active AS active_129, s7_.esdactive AS esdactive_130, s7_.mobile_inactive AS mobile_inactive_131, s7_.embediframe AS embediframe_132, s7_.hideprospect AS hideprospect_133, s7_.action AS action_134, s7_.pluginID AS pluginID_135, s7_.source AS source_136, s8_.id AS id_137, s8_.name AS name_138, s8_.description AS description_139, s8_.position AS position_140, s8_.`group` AS group_141, s8_.mail AS mail_142, s9_.id AS id_143, s9_.name AS name_144, s9_.description AS description_145, s9_.position AS position_146, s9_.`group` AS group_147, s9_.mail AS mail_148, s10_.title AS title_149, s10_.additional_address_line1 AS additional_address_line1_150, s10_.additional_address_line2 AS additional_address_line2_151, s10_.id AS id_152, s10_.orderID AS orderID_153, s10_.userID AS userID_154, s10_.countryID AS countryID_155, s10_.stateID AS stateID_156, s10_.company AS company_157, s10_.department AS department_158, s10_.salutation AS salutation_159, s10_.customernumber AS customernumber_160, s10_.firstname AS firstname_161, s10_.lastname AS lastname_162, s10_.street AS street_163, s10_.zipcode AS zipcode_164, s10_.city AS city_165, s10_.phone AS phone_166, s10_.ustid AS ustid_167, s11_.id AS id_168, s11_.countryname AS countryname_169, s11_.countryiso AS countryiso_170, s11_.countryen AS countryen_171, s11_.position AS position_172, s11_.notice AS notice_173, s11_.taxfree AS taxfree_174, s11_.taxfree_ustid AS taxfree_ustid_175, s11_.taxfree_ustid_checked AS taxfree_ustid_checked_176, s11_.active AS active_177, s11_.iso3 AS iso3_178, s11_.display_state_in_registration AS display_state_in_registration_179, s11_.force_state_in_registration AS force_state_in_registration_180, s11_.areaID AS areaID_181, s12_.id AS id_182, s12_.countryID AS countryID_183, s12_.position AS position_184, s12_.name AS name_185, s12_.shortcode AS shortcode_186, s12_.active AS active_187, s13_.id AS id_188, s13_.main_id AS main_id_189, s13_.category_id AS category_id_190, s13_.name AS name_191, s13_.title AS title_192, s13_.position AS position_193, s13_.host AS host_194, s13_.base_path AS base_path_195, s13_.base_url AS base_url_196, s13_.hosts AS hosts_197, s13_.secure AS secure_198, s13_.template_id AS template_id_199, s13_.`default` AS default_200, s13_.active AS active_201, s13_.customer_scope AS customer_scope_202, s14_.id AS id_203, s14_.name AS name_204, s14_.type AS type_205, s14_.description AS description_206, s14_.comment AS comment_207, s14_.active AS active_208, s14_.position AS position_209, s14_.calculation AS calculation_210, s14_.surcharge_calculation AS surcharge_calculation_211, s14_.tax_calculation AS tax_calculation_212, s14_.shippingfree AS shippingfree_213, s14_.multishopID AS multishopID_214, s14_.customergroupID AS customergroupID_215, s14_.bind_shippingFree AS bind_shippingFree_216, s14_.bind_time_from AS bind_time_from_217, s14_.bind_time_to AS bind_time_to_218, s14_.bind_instock AS bind_instock_219, s14_.bind_laststock AS bind_laststock_220, s14_.bind_weekday_from AS bind_weekday_from_221, s14_.bind_weekday_to AS bind_weekday_to_222, s14_.bind_weight_from AS bind_weight_from_223, s14_.bind_weight_to AS bind_weight_to_224, s14_.bind_price_from AS bind_price_from_225, s14_.bind_price_to AS bind_price_to_226, s14_.bind_sql AS bind_sql_227, s14_.status_link AS status_link_228, s14_.calculation_sql AS calculation_sql_229 FROM s_order s0_ LEFT JOIN s_user s1_ ON s0_.userID = s1_.id LEFT JOIN s_order_shippingaddress s2_ ON s0_.id = s2_.orderID LEFT JOIN s_core_countries_states s3_ ON s2_.stateID = s3_.id LEFT JOIN s_core_countries s4_ ON s2_.countryID = s4_.id LEFT JOIN s_core_shops s5_ ON s0_.language = s5_.id LEFT JOIN s_core_locales s6_ ON s5_.locale_id = s6_.id LEFT JOIN s_core_paymentmeans s7_ ON s0_.paymentID = s7_.id LEFT JOIN s_core_states s8_ ON s0_.cleared = s8_.id LEFT JOIN s_core_states s9_ ON s0_.status = s9_.id LEFT JOIN s_order_billingaddress s10_ ON s0_.id = s10_.orderID LEFT JOIN s_core_countries s11_ ON s10_.countryID = s11_.id LEFT JOIN s_core_countries_states s12_ ON s10_.stateID = s12_.id LEFT JOIN s_core_shops s13_ ON s0_.subshopID = s13_.id LEFT JOIN s_premium_dispatch s14_ ON s0_.dispatchID = s14_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
LG Mercator