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 Exception bei core.connector.auth: Invalid shop url. https://XYZ.de does not point to a shopware 6 instance. Please check the Shop URL. Shopware-Connector 1
Shopware 5 Connector und WaWi 1.9.7.1 / 1.9.8.0 JTL-Wawi 1.9 12
Neu Keine Verbindung zu Shopware Connector möglich Shopware-Connector 1
Neu Tax rate not found - Shopware 6 Shopware-Connector 6
Neu Freitexte aus Shopware in JTL Allgemeine Fragen zu JTL-Shop 7
Neu Shopware 6.6.10.2 Abgleich zu JTL | Bilder Übertragung Fehler: Path cannot be empty Shopware-Connector 0
Neu Keine Verbindung zu Shopware Shopware-Connector 39
Neu Lieferzeiten für Dropshipping und eigene Artikel richtig in Shopware 6 bzw. Wawi anzeigen Schnittstellen Import / Export 1
Neu Umstellung auf JTL Shop - Risk Management wie in Shopware ?! Allgemeine Fragen zu JTL-Shop 7
Neu Verkaufskanalverwaltung Shopware lässt sich nicht löschen Shopware-Connector 3
Neu Zusatzfelder aus Shopware 6 an WAWI übertragen Shopware-Connector 3
Neu JTL Connector Allgemeines zu den JTL-Connectoren 1
Shopify-Connector Down? Shopware-Connector 0
Neu Shopware6 Connector + Funktionsattribute Shopware-Connector 0
JTL Connector Steuersatz Mapping JTL-Wawi 1.6 0
Neu Shopify-Connector: Fehler "delivery_note table doesn't exist" beim Lieferschein-Abgleich Shopify-Connector 4
Neu Änderungen Shopify-Connector 29.07.2025 Shopify-Connector 27
Neu Dringendes Problem: Bildabgleich nach Connector-Fix – "Parameter resourceUrl is empty" Fehler Shopify-Connector 4
Neu Massive Probleme mit JTL-Connector zu Shopify – lohnt sich der Einsatz überhaupt? Shopify-Connector 10
Neu JTL Connector Shopify Abgleich Problem Shopify-Connector 1
JTL Connector <-> JTL WAWI Keine neune Importe von Aufträgen JTL-Wawi 1.9 0
Neu WICHTIG: Änderungen Shopify-Connector 30.06.2025 Shopify-Connector 77
Neu JTL-Connector (Drittanbieter) Auftragsnummer und Ext. Belegnummer setzen Onlineshop-Anbindung 0
Neu Connector funktioniert seit Fehler E-Mail nicht mehr Shopify-Connector 3
Shopify-Connector deaktiviert (no primary tax rate found) Shopify-Connector 3
Neu Connector-Anbindung nicht möglich Shopware-Connector 1
Neu JTL-Connector: Wie kann man Bestände nur von einem Lager (WMS) übertragen? WooCommerce-Connector 3
Neu Shopify-Connector bei Bildübertragung: The filename provided already exists Shopify-Connector 9
Online-Shop abgleich via Shopify Connector geht nicht mehr JTL-Wawi 1.9 4
Neu Connector funktioniert nicht (und täglich grüßt das Murmeltier) Shopify-Connector 2
Neu Shopify Connector Fehler bezüglich "unique key" bei den Kategorien Shopify-Connector 5
Neu Artikel werden nach JTL-Abgleich aus Google & YouTube Vertriebskanal entfernt – seit letztem Connector-Update Shopify-Connector 3
Neu Der Connector funktioniert plötzlich nicht mehr Shopify-Connector 1
Neu Shopify Connector - Verbindungsfehler zum Shop & Kein Abgleich mehr möglich Shopify-Connector 14
Neu WICHTIG: Änderungen Shopify-Connector 21.05.2025 Shopify-Connector 0
Neu WICHTIG: Änderungen Shopify-Connector 21.05.2025 Shopify-Connector 114
Neu Problem Verkaufskanalverwaltung / Connector-Anbindungen WooCommerce-Connector 5
Neu Umstellung JTL-Connector auf Shopify APP – Wer hat Erfahrung? Shopify-Connector 3
Neu Fehlende Mollie-Zahlungsart im JTL-Connector. WooCommerce-Connector 0
Neu alte Bestellungen und Rechnungen per Connector importieren WooCommerce-Connector 2
Neu unicorn2 Etsy listen nicht möglich - Fehler Artikelgewicht Schnittstellen Import / Export 5
Neu Fehler bei Versandbestätigung seit 28.07.2025 Amazon-Anbindung - Fehler und Bugs 1
Hood SCX Schnittstelle mit Listing Fehler JTL-Wawi 1.10 1
Neu PHP message: PHP Fatal error -> Seite nicht mehr aufrufbar (Fehler 500) Installation / Updates von JTL-Shop 1
Neu FEHLER: eBay-Auktionen Upload nicht möglich, Fehlercodes helfen nicht weiter [Error 21917328 & 21920203] eBay-Anbindung - Fehler und Bugs 2
Neu Unnötiger Fehler beim Import von Kundendaten JTL-Shop - Fehler und Bugs 0
Abgleich wird abgebrochen durch diesen Fehler Shopify-Connector 7
Neu Worker macht Fehler nach Update. kein Abgleich möglich Betrieb / Pflege von JTL-Shop 1
Neu Fehler Sie können aktuell keine Benutzer-Lizenzen für WMS bzw. WMS Mobile buchen Installation von JTL-WMS / JTL-Packtisch+ 9
Neu Fehler bei Abgleich WooCommerce-Connector 1

Ähnliche Themen