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
Abkündigung Shopware 5 Connector Shopware-Connector 1
JTL WAWI 1.8.11.1 / JTL CONNECTOR / Shopware 6 JTL-Wawi 1.8 4
Neu Shopware 6 Connector = Mangelhaftes Produkt! Shopware-Connector 0
Wichtig 👉 Wichtiger Hinweis: Abkündigungsfristen JTL-Wawi 1.5 / MSQL-Server 2014 / JTL-POS für Android 7 / JTL-Connector für Shopware 5 News, Events und Umfragen 2
Neu JTL <-> Shopware 6 - Maximale Anzahl von Kundengruppen? Shopware-Connector 4
Neu Migration Shopware 5 auf 6 mit JTL-Wawi ohne Datenverlust Shopware-Connector 1
Neu Datenimport über Ameise in JTL für Shopware Shopware-Connector 1
Neu Best Pratices Shopware - JTL - Buchhaltung User helfen Usern - Fragen zu JTL-Wawi 4
Blowfishkey Shopware 5 Einrichtung JTL-Shop5 3
Neu SEO URL der Kategorien wird nicht an Shopware 6 übertragen Shopware-Connector 0
Neu Umstieg von Shopware 5 zu JTL Shop 5 - Ranking behalten Allgemeine Fragen zu JTL-Shop 2
Neu JTL-Wawi mit Shopware/Magnalister User helfen Usern - Fragen zu JTL-Wawi 3
Neu Einstellung: "Bilder des Vaterartikels un der folgenden Variationswerte übernehmen" und der Shopware Server "explodiert" Shopware-Connector 11
Neu Label mit Anrede "Keine Angabe", Shopware JTL-ShippingLabels - Fehler und Bugs 1
Neu Nutzt jemand Ratepay mit Shopware 6? Shopware-Connector 2
Abbruch bei Abgleich Shopware 6 mit JTL Wawi Shopware-Connector 0
Neu BETA aktuelle Connector Version mit WPML Unterstützung WooCommerce-Connector 0
Wichtig Beta Connector für Presta 8 mit PHP 8+ PrestaShop-Connector 42
Neu PrestaShop Connector für Prestashop 8 mit PHP 8.2 wird nicht unterstützt PrestaShop-Connector 3
Neu Passenden WooCommerce Connector zu meinem WordPress WooCommerce-Connector 8
Neu JTL Shopify Connector und Billbee frage Shopify-Connector 0
Neu JTL Connector zu SW6 auch als Testumgebung möglich ? Onlineshop-Anbindung 3
Neu Shopify Erhöhung der Varianten von 100 auf 2000 - Connector App Problem Shopify-Connector 4
Neu Greyhound JTL-Connector funktioniert nach Update auf 1.8.12 nicht mehr richtig Technische Fragen zu den JTL-Connectoren 5
Neu Connector anlegen in Verkaufskanälen nicht möglich, Verbindungstest schlägt fehl Shopware-Connector 2
Neu JTL Connector Woocomerce für PHP Version 7.4 WooCommerce-Connector 2
Fehler beim Datenbank - JTL WAWI Connector WooCommerce-Connector 1
Neu Woocommerce mit JTL Connector "Die Shop-URL verweist nicht auf einen gültigen Shop" WooCommerce-Connector 4
Neu Connector für php 8.3 / Prestashop 8.1.3 PrestaShop-Connector 6
Neu Migration von eCommerce-Integrator auf JTL Connector - Software 5 Shop Onlineshop-Anbindung 2
Neu JTL Connector WooCommerce überträgt keine Bestellungen mehr WooCommerce-Connector 3
Neu JTL Connector Woocommerce nicht möglich WooCommerce-Connector 9
Neu Woran kann es liegen, dass ein neu erstellter Connector-Verkaufskanal nicht in der Statusliste des Workers vorkommt? Shopify-Connector 2
Neu Connector überträgt keine Bilder Shopify-Connector 1
Neu JTL Connector Plugin Aktivierunf [Fehlermeldung] WooCommerce-Connector 2
Neu Shopify Connector Abgleich endet nicht Shopify-Connector 6
Neu WooCommerce Connector - Keine Produkte in link_product Tabelle WooCommerce-Connector 0
Connector übernimmt nicht alle Bestellungen WooCommerce-Connector 0
Neu Keine Übertragung der Preise mehr seit Connector Update von 1.41.2 auf 1.42.0 WooCommerce-Connector 9
Neu Fehler beim Hochladen der Datei JTL-Shop - Fehler und Bugs 0
Barcodescanner Fehler mit ein "U" am Ende JTL-Wawi 1.8 0
Fehler beim erstellen von Aufträgen JTL-Wawi App 2
Neu Fehler bei Sprach- und Währungsumstellung Allgemeine Fragen zu JTL-Shop 0
Nach Aufruf von Stored Procedure 'Kunde.spKundeUpdate' schwere Fehler in JTL (z.B. Kundenliste, Workflow-Editor) JTL-Wawi 1.8 2
Fehler beim importieren eines Backups JTL-Wawi 1.8 2
Neu Fehler: Footer/Boxen - Kategoriefilter löscht Boxensortierung Allgemeine Fragen zu JTL-Shop 0
Neu Stripe - Fehler icomoon.ttf Plugins für JTL-Shop 0
Neu Gravierender Fehler in der Shop Software Betrieb / Pflege von JTL-Shop 3
Neu Fehler beim Bearbeiten von PLZ & Ort im Kundenkonto (Update 5.3.0) JTL-Shop - Fehler und Bugs 6
Neu Fehler bei Bearbeitung von Designvorlagen eBay-Designvorlagen - Fehler und Bugs 0

Ähnliche Themen