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 Shopware 5 + JTL-Connector: sporadische 500 Fehler / PHP-FPM Limit erreicht – trotz unverändertem Setup User helfen Usern - Fragen zu JTL-Wawi 0
Neu Release Shopware-Connector 2.1.6 Shopware-Connector 0
Neu Shopware 5 connector und WawI 1.11.06 bis 1.11.8 Shopware-Connector 1
Neu SaaS Connector – product.push Performance-Problem bei Shopware 6.6 Shopware-Connector 3
Neu Gutscheincodes aus Shopware 6 in JTL Wawi als Anmerkung zeigen? Shopware-Connector 0
Neu product_visibility bei JTL-Wawi und Shopware 6 Shopware-Connector 1
Neu Connectorupdates für Shopware 6.7.7 bzw 6.7.8? Shopware-Connector 34
Neu WebP Bilder von JTL zu Shopware Shopware-Connector 2
Neu Shopware 6 Kundenstornierung im Webshop Shopware-Connector 0
Neu Langfristiger JTL-Partner gesucht: Shopware 6 / Marktplätze (Mirakl, Otto, Kaufland) & Prozess-Optimierung Dienstleistung, Jobs und Ähnliches 2
Neu Artikel aus Shopware in der Wawi importieren und WMS redy machen Shopware-Connector 0
Wichtig Connectorversion 2.1.3 - Kompatibilität zu Shopware 6.7.6.0 und weitere Performanceoptimierungen Shopware-Connector 5
Neu Shopify Connector lässt sich nicht einrichten Shopify-Connector 0
Neu Störung Saas-Connector Shopware-Connector 8
Neu Fehler Saas-Connector Shopware-Connector 13
Neu Magento 2 Connector JTL Dienstleistung, Jobs und Ähnliches 0
Neu Magento 2 Connector - eCI ( ehem. Sysgrade) - Shipping 3.0 Allgemeines zu den JTL-Connectoren 0
Neu JTL-WaWi + ESL Connector — Entwicklung mit Kostenaufteilung gesucht Business Jungle 0
Statistische Auswertung mit Klar Connector oder Controlling Software? JTL-Wawi 1.10 0
Neu Connector-Core nicht PHP >= 8.4. kompatibel? Technische Fragen zu den JTL-Connectoren 3
Neu Release Shopify-Connector 2.1.0 Shopify-Connector 57
Neu Connector bleibt am Anfang stehen / Fehlermeldung Abbruch Shopify-Connector 3
Neu Shop gesperrt - Webspace überschritten - Zusatzspace buchen bringt Fehler - Support fühlt sich nicht zuständig Betrieb / Pflege von JTL-Shop 7
hipping 4.0 gibt fehler: Error converting value 500 to type 'Shipping.DHL.GKVAPI40.Shared.RequestStatus'. Path 'status', line 1, position 13. JTL-Wawi 1.11 0
Neu DHL Versenden 4.0 HS Code-Fehler bei Freiposition JTL-ShippingLabels - Fehler und Bugs 2
DHL Versenden 4.0 nicht vollständig konfigurierbar (GUI Fehler) JTL-Wawi 2.0 5
Neu Der Inhalt / Text ist verschwunden – ist das ein Fehler JTL-Shop - Fehler und Bugs 0
Neu Fehler Rechnungsupload Amazon FBA Business Kunde JTL-Wawi - Fehler und Bugs 0
Gelöst: Shipping 4.0 gibt fehler: The product entered is unknown. JTL-Wawi 1.11 3
Neu Error 500 Fehler nach Dropper Installation Betrieb / Pflege von JTL-Shop 2
JTL-Wawi 1.11.7 Sporadischer Fehler - Zugriff verweigert. JTL-Wawi 1.11 0
Neu VCS Lite / IDU blockiert – Aufträge fälschlich unter "Externe Rechnungen" (Amazon API Fehler) Amazon-Anbindung - Fehler und Bugs 0
Fehler bei Bearbeitung von Attributen via HTML-Editor JTL-Wawi 2.0 3
JTL Shop 4 Upgrade auf 5.5.0 --> Fehler 500 Upgrade JTL-Shop4 auf JTL-Shop5 3
JTL Shop 4 Upgrade auf 5.5.0 --> Fehler 404 Upgrade JTL-Shop4 auf JTL-Shop5 11
Neu Etikettendruck über Remotedesktop Fehler Arbeitsabläufe in JTL-Wawi 0
Nach Update auf Wawi 2.0.X, API v1 Fehler JTL-Wawi 2.0 9
Neu Fehler Scan Barcodes GTIN13 auf einem Lotto-Kundenbeleg JTL-POS - Fehler und Bugs 4
Update auf 2.0.1 Fehler bei eazybusiness JTL-Wawi 2.0 17
Gelöst Störung: DHL Versenden 3.0 - Fehler "Request processing failure" JTL-ShippingLabels - Fehler und Bugs 1
Neu Fehler beim Update der Datenbank von 1.11.7 auf 2.0.1 JTL-Wawi - Fehler und Bugs 7
Neu JTL Shipping Fehler bei DHL Versand über WMS ? User helfen Usern - Fragen zu JTL-Wawi 2
Gelöst Bekannte Störung: Fehler "Der Inhaltstyp text/html stimmt nicht mit text/xml überein" bei der Labelerstellung Gelöste Themen in diesem Bereich 1
Neu Fehler beim Abgleich, aber nur 1 einer von 3 Shopify Shops Shopify-Connector 2
Aufträge auf die Pikliste legen bringt Fehler DataTreeListView JTL-Wawi 1.11 2
Neu Zyklische Fehler beim Listen von T-Shirts Amazon-Lister - Fehler und Bugs 3
Neu Fehler 35 XLM entspricht nicht der Konvention Plugins für JTL-Shop 4
Neu Varkombis Import Fehler "#VARKOMBI WIRD NICHT ANGELEGT#" JTL-Ameise - Fehler und Bugs 4
Neu Kartenzahlung Total amount Fehler JTL-POS - Fehler und Bugs 1
Neu Fehler mit der Kartenzahlung Einrichtung / Updates von JTL-POS 9

Ähnliche Themen