Neu Shopware Connector Fehler Exception category level

Schoppe

Aktives Mitglied
8. Januar 2020
7
1
Shopware Connector Fehler Exception category level

Hallo ich habe ein Problem bei der Verbindung zu unserem Shopware Shop.

Wawi-Version : 1.5.16.1
Shopware-Version : 5.5.10
Connector-Version : 2.2.5.1

Wir sind dabei das erste mal Daten vom Shop abzurufen. Leider erhalten wir die angehängte Fehlermeldung:

Fehler:
Exception: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.shops AS shops_3, s0_.id AS id_4, s0_.parent AS parent_5, s0_.stream_id AS stream_id_6, s0_.description AS description_7, s0_.position AS position_8, s0_.meta_title AS meta_title_9, s0_.metakeywords AS metakeywords_10, s0_.metadescription AS metadescription_11, s0_.cmsheadline AS cmsheadline_12, s0_.cmstext AS cmstext_13, s0_.active AS active_14, s0_.template AS template_15, s0_.product_box_layout AS product_box_layout_16, s0_.blog AS blog_17, s0_.path AS path_18, s0_.external AS external_19, s0_.external_target AS external_target_20, s0_.hidefilter AS hidefilter_21, s0_.hidetop AS hidetop_22, s0_.changed AS changed_23, s0_.added AS added_24, s0_.mediaID AS mediaID_25, j1_.level AS level_26, s2_.id AS id_27, s2_.categoryID AS categoryID_28, s2_.attribute1 AS attribute1_29, s2_.attribute2 AS attribute2_30, s2_.attribute3 AS attribute3_31, s2_.attribute4 AS attribute4_32, s2_.attribute5 AS attribute5_33, s2_.attribute6 AS attribute6_34, s3_.id AS id_35, s3_.groupkey AS groupkey_36, s3_.description AS description_37, s3_.tax AS tax_38, s3_.taxinput AS taxinput_39, s3_.mode AS mode_40, s3_.discount AS discount_41, s3_.minimumorder AS minimumorder_42, s3_.minimumordersurcharge AS minimumordersurcharge_43, j1_.category_id AS category_id_44 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12819946-riemchenshop.jtl_connector_category_level' doesn't exist
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.shops AS shops_3, s0_.id AS id_4, s0_.parent AS parent_5, s0_.stream_id AS stream_id_6, s0_.description AS description_7, s0_.position AS position_8, s0_.meta_title AS meta_title_9, s0_.metakeywords AS metakeywords_10, s0_.metadescription AS metadescription_11, s0_.cmsheadline AS cmsheadline_12, s0_.cmstext AS cmstext_13, s0_.active AS active_14, s0_.template AS template_15, s0_.product_box_layout AS product_box_layout_16, s0_.blog AS blog_17, s0_.path AS path_18, s0_.external AS external_19, s0_.external_target AS external_target_20, s0_.hidefilter AS hidefilter_21, s0_.hidetop AS hidetop_22, s0_.changed AS changed_23, s0_.added AS added_24, s0_.mediaID AS mediaID_25, j1_.level AS level_26, s2_.id AS id_27, s2_.categoryID AS categoryID_28, s2_.attribute1 AS attribute1_29, s2_.attribute2 AS attribute2_30, s2_.attribute3 AS attribute3_31, s2_.attribute4 AS attribute4_32, s2_.attribute5 AS attribute5_33, s2_.attribute6 AS attribute6_34, s3_.id AS id_35, s3_.groupkey AS groupkey_36, s3_.description AS description_37, s3_.tax AS tax_38, s3_.taxinput AS taxinput_39, s3_.mode AS mode_40, s3_.discount AS discount_41, s3_.minimumorder AS minimumorder_42, s3_.minimumordersurcharge AS minimumordersurcharge_43, j1_.category_id AS category_id_44 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12819946-riemchenshop.jtl_connector_category_level' doesn't exist
Exception bei Category.statistic: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.shops AS shops_3, s0_.id AS id_4, s0_.parent AS parent_5, s0_.stream_id AS stream_id_6, s0_.description AS description_7, s0_.position AS position_8, s0_.meta_title AS meta_title_9, s0_.metakeywords AS metakeywords_10, s0_.metadescription AS metadescription_11, s0_.cmsheadline AS cmsheadline_12, s0_.cmstext AS cmstext_13, s0_.active AS active_14, s0_.template AS template_15, s0_.product_box_layout AS product_box_layout_16, s0_.blog AS blog_17, s0_.path AS path_18, s0_.external AS external_19, s0_.external_target AS external_target_20, s0_.hidefilter AS hidefilter_21, s0_.hidetop AS hidetop_22, s0_.changed AS changed_23, s0_.added AS added_24, s0_.mediaID AS mediaID_25, j1_.level AS level_26, s2_.id AS id_27, s2_.categoryID AS categoryID_28, s2_.attribute1 AS attribute1_29, s2_.attribute2 AS attribute2_30, s2_.attribute3 AS attribute3_31, s2_.attribute4 AS attribute4_32, s2_.attribute5 AS attribute5_33, s2_.attribute6 AS attribute6_34, s3_.id AS id_35, s3_.groupkey AS groupkey_36, s3_.description AS description_37, s3_.tax AS tax_38, s3_.taxinput AS taxinput_39, s3_.mode AS mode_40, s3_.discount AS discount_41, s3_.minimumorder AS minimumorder_42, s3_.minimumordersurcharge AS minimumordersurcharge_43, j1_.category_id AS category_id_44 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12819946-riemchenshop.jtl_connector_category_level' doesn't exist

An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.shops AS shops_3, s0_.id AS id_4, s0_.parent AS parent_5, s0_.stream_id AS stream_id_6, s0_.description AS description_7, s0_.position AS position_8, s0_.meta_title AS meta_title_9, s0_.metakeywords AS metakeywords_10, s0_.metadescription AS metadescription_11, s0_.cmsheadline AS cmsheadline_12, s0_.cmstext AS cmstext_13, s0_.active AS active_14, s0_.template AS template_15, s0_.product_box_layout AS product_box_layout_16, s0_.blog AS blog_17, s0_.path AS path_18, s0_.external AS external_19, s0_.external_target AS external_target_20, s0_.hidefilter AS hidefilter_21, s0_.hidetop AS hidetop_22, s0_.changed AS changed_23, s0_.added AS added_24, s0_.mediaID AS mediaID_25, j1_.level AS level_26, s2_.id AS id_27, s2_.categoryID AS categoryID_28, s2_.attribute1 AS attribute1_29, s2_.attribute2 AS attribute2_30, s2_.attribute3 AS attribute3_31, s2_.attribute4 AS attribute4_32, s2_.attribute5 AS attribute5_33, s2_.attribute6 AS attribute6_34, s3_.id AS id_35, s3_.groupkey AS groupkey_36, s3_.description AS description_37, s3_.tax AS tax_38, s3_.taxinput AS taxinput_39, s3_.mode AS mode_40, s3_.discount AS discount_41, s3_.minimumorder AS minimumorder_42, s3_.minimumordersurcharge AS minimumordersurcharge_43, j1_.category_id AS category_id_44 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12819946-riemchenshop.jtl_connector_category_level' doesn't exist

Response: {"result":null,"error":{"code":0,"message":"An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.shops AS shops_3, s0_.id AS id_4, s0_.parent AS parent_5, s0_.stream_id AS stream_id_6, s0_.description AS description_7, s0_.position AS position_8, s0_.meta_title AS meta_title_9, s0_.metakeywords AS metakeywords_10, s0_.metadescription AS metadescription_11, s0_.cmsheadline AS cmsheadline_12, s0_.cmstext AS cmstext_13, s0_.active AS active_14, s0_.template AS template_15, s0_.product_box_layout AS product_box_layout_16, s0_.blog AS blog_17, s0_.path AS path_18, s0_.external AS external_19, s0_.external_target AS external_target_20, s0_.hidefilter AS hidefilter_21, s0_.hidetop AS hidetop_22, s0_.changed AS changed_23, s0_.added AS added_24, s0_.mediaID AS mediaID_25, j1_.level AS level_26, s2_.id AS id_27, s2_.categoryID AS categoryID_28, s2_.attribute1 AS attribute1_29, s2_.attribute2 AS attribute2_30, s2_.attribute3 AS attribute3_31, s2_.attribute4 AS attribute4_32, s2_.attribute5 AS attribute5_33, s2_.attribute6 AS attribute6_34, s3_.id AS id_35, s3_.groupkey AS groupkey_36, s3_.description AS description_37, s3_.tax AS tax_38, s3_.taxinput AS taxinput_39, s3_.mode AS mode_40, s3_.discount AS discount_41, s3_.minimumorder AS minimumorder_42, s3_.minimumordersurcharge AS minimumordersurcharge_43, j1_.category_id AS category_id_44 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level

Die Onlineshop-Anbingung funktioniert und eine Verbindung ist hergestellt.

Leider kommt immer wieder die Fehlermeldung. Auch ein Löschen des Proxie und Meto-Caches hat nicht funktioniert.

Würde mich sehr über eine Antwort freuen.
 

Anhänge

  • Shopware-Connector-Fehler_1.JPG
    Shopware-Connector-Fehler_1.JPG
    83,7 KB · Aufrufe: 3

Immanuel

Gesperrter Benutzer
24. August 2016
1.542
329
Hallo @Schoppe,

grundsätzlich sollte das Problem mit dem Löschen der Caches für "Proxies und Meta-Daten" behoben sein. Dafür muss der Webserver aber auch über Schreibrechte auf den Ordner "var/ cache" im Wurzelverzeichnis des Shops verfügen.
 

Schoppe

Aktives Mitglied
8. Januar 2020
7
1
Hallo Immanuel,
vielen Dank für deine schnelle Antwort.

Ich habe den proxie und Meta-Daten Cache im Backend von Shopware geleert. Das hatte keinen Erfolg.
Um sicher zu gehen habe ich dann nochmal den Cache manuell auf dem Server gelöscht. Leider hat es danach noch immer die gleiche Fehlermeldung gegeben.

Hast du evtl. noch eine andere Idee. Ich bin einfach ratlos.
 
Ähnliche Themen
Titel Forum Antworten Datum
Neu JTL Connector - Shopware 5 / 6: keine Erstübertragung der Daten Shopware-Connector 2
Einzelartikel als Kindartikel zu einem neuen Vaterartikel zusammenführen (JTL-Wawi + Shopware Connector) JTL-Wawi 1.8 0
Neu Mediendateien nicht mit Shopware synchronisiert Shopware-Connector 0
Neu Connectorversion 2.1.0 - Kompatibilität zu Shopware 6.7 und Performanceoptimierungen Shopware-Connector 15
Neu PIM -> Shopware 6 <-> JTL Shopware-Connector 12
Neu Fehler beim Übertragen von Bildern JTL - Shopware Thumbnail Problem height width dürfen nicht leer sein Shopware-Connector 11
ERP Connector Shopify JTL-Wawi 1.10 3
Neu Verbindung zu Shopify Connector (App) -> "Lizensdaten ungültig" Shopify-Connector 1
Neu JTL Shopify Connector selektiver Import in JTL Shopify-Connector 2
Neu Fehler Connector Shopify Collection not found Shopify-Connector 8
Neu Update: JTL-Gambio-Connector Gambio-Connector 0
Neu Download Connector Modul .zip PrestaShop-Connector 0
Neu Biete Connector-Tools für vollautomatische Lieferantenbestellungen an uvm. Dienstleistung, Jobs und Ähnliches 2
Neu Woocommerce + JTL Connector + Litespeed Cache WooCommerce-Connector 0
Neu Probleme bei WooCommerce JTL-Connector, keine Aktivierung möglich, Bestands-Shop lahmgelegt Onlineshop-Anbindung 0
Neu Wawi zu Shopify connector Funktionseinstellungen ändern Allgemeines zu den JTL-Connectoren 0
Neu Connector extrem langsam Shopify-Connector 17
Neu JTL Connector Shopware-Connector 10
Neu Probleme beim Abgleich mit dem WooCommerce-Connector WooCommerce-Connector 0
Neu Abgleich WooCommerce / JTL mit dem Connector – Fehlermeldung WooCommerce-Connector 0
Neu Connector - benötigte Berechtigungen Shopware-Connector 4
Neu Connector schickt jede Nacht Category Bilder neu an Woocommerce WooCommerce-Connector 2
Neu eBay Angebotsimport : Fehler bei der Kommunikation mit dem eA-Server eBay-Anbindung - Fehler und Bugs 0
Neu Wo kann ich mich über JTL Kundencenter beschweren? 20 Minuten Lang einen Bug im Ticket dokumentiert, und am Ende "ein Fehler ist aufgetreten" Smalltalk 3
Neu Seit Update auf 1.10.15.0: eBay Fahrzeugverwendungsliste Fehler eBay-Anbindung - Fehler und Bugs 3
Fehler seit Version 1.10.15 bei Artikel Auslieferung über Bestandsmenge JTL-Wawi 1.10 0
Beantwortet Workflow Datei schreiben Dateiname per Dotliquid Fehler Illegales Zeichen im Pfad. callerMemberName : WriteFile JTL-Workflows - Fehler und Bugs 1
Neu Unterstützung bei JTL FFN Retouren – Fehler in der API-Übertragung von Returnless Starten mit JTL: Projektabwicklung & Migration 0
Fehler beim Verknüpfen von JTL-FFN mit Wawi – „Anmeldung nicht möglich“ JTL-Wawi 1.11 1
Neu Fehler eBay-Abgleich eBay-Anbindung - Fehler und Bugs 21
Neu Anmeise Mediendateien Import Fehler JTL-Ameise - Fehler und Bugs 4
Wawi API REST-Server lässt sich nicht einrichten / Fehler 404 JTL-Wawi 1.11 1
Neu Fehler beim Shopabgleich - Duplicate Entry Allgemeine Fragen zu JTL-Shop 2
Neu eazyAuction holt keine Bestellung mehr von Amazon ab, im Logbuch "Fehler" ohne weitere Angabe Amazon-Anbindung - Fehler und Bugs 1
Neu JTL Track&Trace API Fehler derzeit? seit 15:50 Uhr JTL-Track&Trace - Fehler und Bugs 2
Neu Aktuellen JTL Shop installieren *Fehler* Installation / Updates von JTL-Shop 0
Neu FBA-Lagerbestand wird nicht mehr eingelesen - Fehler beim Verarbeiten von Amazon Events - FbaInventoryImported: Das angegebene Argument liegt außerha Amazon-Anbindung - Fehler und Bugs 13
Fehler Export PDF Datei / Senden per Email JTL-Wawi 1.11 2
Neu Amazon Bestellungen werden nicht abgerufen - Fehler bei Account 'XXX' []: Ihr Account ist nicht aktiv. Amazon-Anbindung - Fehler und Bugs 5
Neu Amazon eazyAuction Lizenz Fehler? Amazon-Anbindung - Fehler und Bugs 1
AmzLister 2.0 Fehler 99022 beim Vaterartikel Amazon-Lister - Fehler und Bugs 0
Bis alle Fehler behoben sind, nicht installieren. JTL-Wawi 1.11 40
Neu Abgleich bricht mit Fehler 503 ab Shopware-Connector 3
Verkauf - Fehler beim Laden der Daten JTL-Wawi 1.11 6
Neu Tagesabschluss Fehler BAR Bruttoumsatz / Fehler Zahlungsart BAR JTL-POS - Fehler und Bugs 0
Neu Worker Fehler - Fehlende Relation JTL-Wawi - Fehler und Bugs 1
Beantwortet Fehler bei Erstimport: Explicit Move is not supported for HerstellerSortMode.Alphabetical Shopware-Connector 1
Neu Bestellvorgang – Land und Postleitzahl werden nicht erkannt und HTTP-Fehler 500 bei der Lieferadresse JTL-Shop - Fehler und Bugs 11
Neu Fehler beim Bearbeiten der eMail-Templates JTL-Shop - Fehler und Bugs 2
Neu Fehler nach Update Produktseiten nicht mehr aufrufbar Installation / Updates von JTL-Shop 1

Ähnliche Themen