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
Shopware-6-Connector (SaaS) – image.push meldet Erfolg, Bild kommt aber nie in Shopware an (reproduzierbar, mehrere Artikel) Shopware-Connector 1
Neu Release Shopware-Connector 2.1.8 Shopware-Connector 3
Vaterartikel wird trotz Varianten eigenständig im Shopware-6-Storefront angezeigt, 0 €, kein Bild, falscher Bestand Shopware-Connector 1
Neu Shopify-Connector auf neues JTL-Kundenkonto umstellen – App bleibt altem Konto zugeordnet Shopify-Connector 4
Neu Drittanbieter Connector Technische Fragen zu den JTL-Connectoren 1
Neu Release Shopify-Connector 2.1.10 Shopify-Connector 9
Neu Connector 2.1.6 ist Live ! Releaseforum 0
Neu Release Shopify-Connector 2.1.6 ist Live Shopify-Connector 49
Eigener Drittshop-Connector (jtl/connector 5.3): valide Variationskombinationen werden mit „besitzt keine Variationen" nicht gesendet JTL-Wawi 1.11 1
Neu Problem mit dem JTL-Connector – Invalid Shopify connection credentials. Shopify-Connector 3
Neu JTL → Shopify Connector: MappingTablesException / „Endpoint id is empty“ – betroffene Artikel aus Logs per SQL finden Shopify-Connector 2
JTL ERP-Connector JTL-Wawi 2.0 0
Neu Fragen zum SaaS-Connector / Shopware6 bei Lagerbestandskorrektur Shopware-Connector 0
Neu Dhl Authorization Fehler 15 JTL-ShippingLabels - Fehler und Bugs 31
Zugferd XML Daten Fehler JTL-Wawi 2.0 6
Neu Vorlage enthält ein Syntax Fehler eBay-Anbindung - Fehler und Bugs 1
Neu Fehler beim öffnen von JTL Hub JTL-ShippingLabels - Fehler und Bugs 2
Fehler bei Installation: Powershell V2 JTL-Wawi 2.0 8
Neu Fehler DHL Versenden 4.0 - DHL Authorisation Server. JTL-ShippingLabels - Fehler und Bugs 1
Neu Fehler nach Update auf Version 5.7.2 beim Bestellabschluß Betrieb / Pflege von JTL-Shop 7
Neu Fehler Datenbank auf neuem Server mit Wawi 2.0.6 JTL-Wawi - Fehler und Bugs 5
Neu Kein Datenaustausch – Timeout-Fehler Shopify-Connector 0
Neu DHL 4.0 API Fehler - Could not cast or convert from System.Int64 JTL-ShippingLabels - Fehler und Bugs 7
Neu Wawi 2.0.6 Fehler bei Druckerzuordnung und Nachdruck JTL-ShippingLabels - Fehler und Bugs 12
Neu Amazonpay Fehler nach Anbindung von Datev - bitte helfen Schnittstellen Import / Export 0
Neu Artikeldetails -> Bilder Plattform "Alle" Fehler oder kein Fehler JTL-Wawi - Fehler und Bugs 1
Neu Login-Fehler 403 bei app.shipping.jtl-cloud.com seit 17.07.2026 JTL-ShippingLabels - Fehler und Bugs 7
Lexware Office von Kunden meldet Arithmetik Fehler in Zugferd 2 XRechnung JTL-Wawi 1.11 9
Neu DHL Versenden 4.0 Fehler: Please enter a house number JTL-ShippingLabels - Fehler und Bugs 5
Neu 500er Fehler im Shop nach aktivierung des Nova Child Templates für JTL-Shop 3
Neu Rechte-Fehler im J10n Modul und Auswirkung auf base.mo.php in div. Plugins (Shop 5.7.1) JTL-Shop - Fehler und Bugs 0
Neu Shop zeigt keine Artikel mehr Fehler 500 Betrieb / Pflege von JTL-Shop 9
Neu Paypal 2.2.1; Fehler "Der Zahlungsanbieter hat eine Anmeldung gefordert" Plugins für JTL-Shop 2
Neu Keine Warenpost Int. Labels hsCode - Fehler? JTL-ShippingLabels - Fehler und Bugs 8
Fehler mit Zahlungsabgleich JTL-Wawi 1.11 11
Neu JTL-Wawi Shopabgleich per E-Mail überwachen (Warnungen & Fehler) Onlineshop-Anbindung 1
Fehler beim Abgleich mit Amazon JTL-Wawi 2.0 10
Fehler nach Update auf Version 1.11.11 und 2.0.4 JTL-Wawi 2.0 7
Neu DHL 4.0 Versandexport Fehler JTL-ShippingLabels - Ideen, Lob und Kritik 15
Fehler beim Abgleich mit dem JTL-Shop JTL-Wawi 2.0 12

Ähnliche Themen