Versandkosten-Fehler durch Plugin "Versandkosten nach Entfernung "

Guten Tag,

 

wir haben ein akutes Problem. Wir haben das Plugin "Versandkosten nach Entfernung " von Kdrei ( K30 Webentwicklung ) getestet und nach dem Test wieder deinstalliert. Leider taucht nach der Deinstallation, beim Aufruf der Versandkosten im Backend folgender Fehler auf den ich nicht ganz lesen kann:

503
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing 'SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.description AS description_3, s0_.comment AS comment_4, s0_.active AS active_5, s0_.position AS position_6, s0_.calculation AS calculation_7, s0_.surcharge_calculation AS surcharge_calculation_8, s0_.tax_calculation AS tax_calculation_9, s0_.shippingfree AS shippingfree_10, s0_.multishopID AS multishopID_11, s0_.customergroupID AS customergroupID_12, s0_.bind_shippingFree AS bind_shippingFree_13, s0_.bind_time_from AS bind_time_from_14, s0_.bind_time_to AS bind_time_to_15, s0_.bind_instock AS bind_instock_16, s0_.bind_laststock AS bind_laststock_17, s0_.bind_weekday_from AS bind_weekday_from_18, s0_.bind_weekday_to AS bind_weekday_to_19, s0_.bind_weight_from AS bind_weight_from_20, s0_.bind_weight_to AS bind_weight_to_21, s0_.bind_price_from AS bind_price_from_22, s0_.bind_price_to AS bind_price_to_23, s0_.bind_sql AS bind_sql_24, s0_.status_link AS status_link_25, s0_.calculation_sql AS calculation_sql_26, s1_.id AS id_27, s1_.countryname AS countryname_28, s1_.countryiso AS countryiso_29, s1_.countryen AS countryen_30, s1_.position AS position_31, s1_.notice AS notice_32, s1_.taxfree AS taxfree_33, s1_.taxfree_ustid AS taxfree_ustid_34, s1_.taxfree_ustid_checked AS taxfree_ustid_checked_35, s1_.active AS active_36, s1_.iso3 AS iso3_37, s1_.display_state_in_registration AS display_state_in_registration_38, s1_.force_state_in_registration AS force_state_in_registration_39, s1_.areaID AS areaID_40, s2_.sorting_ids AS sorting_ids_41, s2_.hide_sortings AS hide_sortings_42, s2_.facet_ids AS facet_ids_43, s2_.id AS id_44, s2_.parent AS parent_45, s2_.stream_id AS stream_id_46, s2_.description AS description_47, s2_.position AS position_48, s2_.meta_title AS meta_title_49, s2_.metakeywords AS metakeywords_50, s2_.metadescription AS metadescription_51, s2_.cmsheadline AS cmsheadline_52, s2_.cmstext AS cmstext_53, s2_.active AS active_54, s2_.template AS template_55, s2_.product_box_layout AS product_box_layout_56, s2_.blog AS blog_57, s2_.path AS path_58, s2_.external AS external_59, s2_.external_target AS external_target_60, s2_.hidefilter AS hidefilter_61, s2_.hidetop AS hidetop_62, s2_.changed AS changed_63, s2_.added AS added_64, s2_.mediaID AS mediaID_65, s3_.id AS id_66, s3_.name AS name_67, s3_.calculation AS calculation_68, s3_.date AS date_69, s4_.id AS id_70, s4_.dispatchID AS dispatchID_71, s4_.kdrei_scbd_active AS kdrei_scbd_active_72, s4_.kdrei_scbd_storage_address AS kdrei_scbd_storage_address_73, s4_.kdrei_scbd_modus AS kdrei_scbd_modus_74, s4_.kdrei_scbd_distance_a AS kdrei_scbd_distance_a_75, s4_.kdrei_scbd_distance_b AS kdrei_scbd_distance_b_76, s4_.kdrei_scbd_free_distance AS kdrei_scbd_free_distance_77, s4_.kdrei_scbd_costs_per_km AS kdrei_scbd_costs_per_km_78, s5_.id AS id_79, s5_

Darüberhinaus lassen sich keine Bestellungen mehr abrufen.

Wir können die Webentwickler des Plugins nicht erreichen, daher hoffen wir, das uns hier schnell geholfen werden kann. Vielelicht reicht es ja schon eine Tabelle zu löschen.

 

Ich danke für die schnelle Hilfe!

 

Gregor

Die Fehlermeldung aus der Log

 

An exception occurred while executing ‘SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.description AS description_3, s0_.comment AS comment_4, s0_.active AS active_5, s0_.position AS position_6, s0_.calculation AS calculation_7, s0_.surcharge_calculation AS surcharge_calculation_8, s0_.tax_calculation AS tax_calculation_9, s0_.shippingfree AS shippingfree_10, s0_.multishopID AS multishopID_11, s0_.customergroupID AS customergroupID_12, s0_.bind_shippingFree AS bind_shippingFree_13, s0_.bind_time_from AS bind_time_from_14, s0_.bind_time_to AS bind_time_to_15, s0_.bind_instock AS bind_instock_16, s0_.bind_laststock AS bind_laststock_17, s0_.bind_weekday_from AS bind_weekday_from_18, s0_.bind_weekday_to AS bind_weekday_to_19, s0_.bind_weight_from AS bind_weight_from_20, s0_.bind_weight_to AS bind_weight_to_21, s0_.bind_price_from AS bind_price_from_22, s0_.bind_price_to AS bind_price_to_23, s0_.bind_sql AS bind_sql_24, s0_.status_link AS status_link_25, s0_.calculation_sql AS calculation_sql_26, s1_.id AS id_27, s1_.countryname AS countryname_28, s1_.countryiso AS countryiso_29, s1_.countryen AS countryen_30, s1_.position AS position_31, s1_.notice AS notice_32, s1_.taxfree AS taxfree_33, s1_.taxfree_ustid AS taxfree_ustid_34, s1_.taxfree_ustid_checked AS taxfree_ustid_checked_35, s1_.active AS active_36, s1_.iso3 AS iso3_37, s1_.display_state_in_registration AS display_state_in_registration_38, s1_.force_state_in_registration AS force_state_in_registration_39, s1_.areaID AS areaID_40, s2_.sorting_ids AS sorting_ids_41, s2_.hide_sortings AS hide_sortings_42, s2_.facet_ids AS facet_ids_43, s2_.id AS id_44, s2_.parent AS parent_45, s2_.stream_id AS stream_id_46, s2_.description AS description_47, s2_.position AS position_48, s2_.meta_title AS meta_title_49, s2_.metakeywords AS metakeywords_50, s2_.metadescription AS metadescription_51, s2_.cmsheadline AS cmsheadline_52, s2_.cmstext AS cmstext_53, s2_.active AS active_54, s2_.template AS template_55, s2_.product_box_layout AS product_box_layout_56, s2_.blog AS blog_57, s2_.path AS path_58, s2_.external AS external_59, s2_.external_target AS external_target_60, s2_.hidefilter AS hidefilter_61, s2_.hidetop AS hidetop_62, s2_.changed AS changed_63, s2_.added AS added_64, s2_.mediaID AS mediaID_65, s3_.id AS id_66, s3_.name AS name_67, s3_.calculation AS calculation_68, s3_.date AS date_69, s4_.id AS id_70, s4_.dispatchID AS dispatchID_71, s4_.kdrei_scbd_active AS kdrei_scbd_active_72, s4_.kdrei_scbd_storage_address AS kdrei_scbd_storage_address_73, s4_.kdrei_scbd_modus AS kdrei_scbd_modus_74, s4_.kdrei_scbd_distance_a AS kdrei_scbd_distance_a_75, s4_.kdrei_scbd_distance_b AS kdrei_scbd_distance_b_76, s4_.kdrei_scbd_free_distance AS kdrei_scbd_free_distance_77, s4_.kdrei_scbd_costs_per_km AS kdrei_scbd_costs_per_km_78, s5_.id AS id_79, s5_.name AS name_80, s5_.description AS description_81, s5_.template AS template_82, s5_.class AS class_83, s5_.table AS table_84, s5_.hide AS hide_85, s5_.additionaldescription AS additionaldescription_86, s5_.debit_percent AS debit_percent_87, s5_.surcharge AS surcharge_88, s5_.surchargestring AS surchargestring_89, s5_.position AS position_90, s5_.active AS active_91, s5_.esdactive AS esdactive_92, s5_.mobile_inactive AS mobile_inactive_93, s5_.embediframe AS embediframe_94, s5_.hideprospect AS hideprospect_95, s5_.action AS action_96, s5_.pluginID AS pluginID_97, s5_.source AS source_98 FROM s_premium_dispatch s0_ LEFT JOIN s_premium_dispatch_countries s6_ ON s0_.id = s6_.dispatchID LEFT JOIN s_core_countries s1_ ON s1_.id = s6_.countryID LEFT JOIN s_premium_dispatch_categories s7_ ON s0_.id = s7_.dispatchID LEFT JOIN s_categories s2_ ON s2_.id = s7_.categoryID LEFT JOIN s_premium_dispatch_holidays s8_ ON s0_.id = s8_.dispatchID LEFT JOIN s_premium_holidays s3_ ON s3_.id = s8_.holidayID LEFT JOIN s_premium_dispatch_attributes s4_ ON s0_.id = s4_.dispatchID LEFT JOIN s_premium_dispatch_paymentmeans s9_ ON s0_.id = s9_.dispatchID LEFT JOIN s_core_paymentmeans s5_ ON s5_.id = s9_.paymentID WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.name ASC’ with params

Lösung vom Entwickler:

„s_premium_dispatch_attributes“ in der Freitextverwaltung neu generieren, hat beide Probleme gelöst.