Gelöst Verbindungsfehler / Webshopabgleich

[THC_1.1]

Hallo,

nochmal eine kurze Anfrage, da die Artikelübertragung nicht reibungslos klappt. Es werden nicht alle Artikel übertragen und die Variationsartikel nicht bei Woocommerce angezeigt. Diese müssen per Hand im Webshop angelegt werden. Ich habe die Installation nach der Anleitung durchgeführt und nur die Bestandsdaten an den Webshop gesendet. Liegt es an der Einrichtung der Datenbank auf dem Server? Anbei das Fehlerprotokoll aus der Wawi /


Abgleich-Protokoll:
Prüfe Endpointkonfiguration.
Abgleich gestartet für 'WooCommerce'.
Webshopabgleich beendet für 'WooCommerce'.


Fehler:
Exception: DeserializeObject-Error: Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.
at Newtonsoft.Json.JsonTextReader.ParseValue()
at Newtonsoft.Json.JsonTextReader.ReadInternal()
at Newtonsoft.Json.JsonTextReader.Read()
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
at jtlCore.ControllerClasses. Connector.Core.Json.DeserializeObject[T](String json)

Json:<div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
SELECT checksum
FROM jtl_connector_product_checksum
WHERE product_id = 165 AND type = 1</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
INSERT IGNORE INTO jtl_connector_product_checksum (product_id, type, checksum)
VALUES (165, 1, 'fe05c7d166bb179b9fea7a14936b7ab2a54d7a68')</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
SELECT checksum
FROM jtl_connector_product_checksum
WHERE product_id = 166 AND type = 1</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
INSERT IGNORE INTO jtl_connector_product_checksum (product_id, type, checksum)
VALUES (166, 1, '4534af265b179b4047c7e353577bda480111a6ab')</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
SELECT checksum
FROM jtl_connector_product_checksum
WHERE product_id = 167 AND type = 1</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
INSERT IGNORE INTO jtl_connector_product_checksum (product_id, type, checksum)
VALUES (167, 1, '6e7e459191099fe168c7a5a180edf0809890f467')</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
SELECT checksum
FROM jtl_connector_product_checksum
WHERE product_id = 168 AND type = 1</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
INSERT IGNORE INTO jtl_connector_product_checksum (product_id, type, checksum)
VALUES (168, 1, 'd3cbb8ae328be6547e43e7af650e3076603a969a')</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
SELECT checksum
FROM jtl_connector_product_checksum
WHERE product_id = 169 AND type = 1</code></p></div><div id="error"><p class="wpdberror"><strong>WordPress-Datenbank-Fehler:</strong> [Table 'd0213073.jtl_connector_product_checksum' doesn't exist]<br /><code>
INSERT IGNORE INTO jtl_connector_product_checksum (product_id, type, checksum)
VALUES (169, 1, '6e9f71689682db1bf64044d23e8f0a83d04a4991')</code></p></div>{"result":[{"basePriceUnitId":["",0],"id":[160,79322],"manufacturerId":[null,18],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",1],"unitId":["",1],"asin":"","availableFrom":null,"basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":true,"considerVariationStock":false,"creationDate":"2015-09-04T00:00:00+0000","ean":"4524667316428","epid":"","hazardIdNumber":"","height":0,"isActive":true,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","measurementQuantity":0,"measurementUnitCode":"","minBestBeforeDate":null,"minimumOrderQuantity":0,"minimumQuantity":0," modified":"2015-09-05T16:07:38+0000","nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":false,"productWeight":0.300000011921,"purchasePrice":18.5499992371,"recommendedRetailPrice":31.512605042,"serialNumber":"","shippingWeight":0.5,"sku":"ANT\/SH\/01\/035","sort":0,"stockLevel":{"productId":[160,79322],"stockLevel":0},"supplierDeliveryTime":0,"supplierStockLevel":0,"taric":"","unNumber":"","upc":"","vat":19,"width":0,"attributes":[],"categories":[{"categoryId":[null,38],"id":["",80320],"productId":[160,79322]}],"checksums":[],"configGroups":[],"customerGroupPackagingQuantities":[],"fileDownloads":[],"i18ns":[{"productId":[160,79322],"deliveryStatus":"0 Tage","description":"","languageISO":"ger","measurementUnitName":null,"metaDescription":"","metaKeywords":"","name":"Shimano Sora RD-3500 SS","shortDescription":"","titleTag":"","unitName":"St\u00fcck","urlPath":""}],"invisibilities":[],"mediaFiles":[],"partsLists":[],"prices":[{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":[160,79322],"items":[{"productPriceId":["",0],"netPrice":31.5126,"quantity":0}]}],"specialPrices":[],"specifics":[],"varCombinations":[],"variations":[],"warehouseInfo":[]},{"basePriceUnitId":["",0],"id":[161,79528],"manufacturerId":[null,54],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",1],"unitId":["",1],"asin":"","availableFrom":"2015-09-23T16:15:32+0000","basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":true,"considerVariationStock":false,"creationDate":"2015-09-23T16:20:24+0000","ean":"401923855669","epid":"","hazardIdNumber":"","height":0,"isActive":true,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","measurementQuantity":0,"measurementUnitCode":"","minBestBeforeDate":null,"minimumOrderQuantity":0,"minimumQuantity":2,"modified":"2015-10-22T10:40:50+0000","nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":false,"productWeight":0.2,"purchasePrice":3.25,"recommendedRetailPrice":6.3025210084,"serialNumber":"","shippingWeight":0.3,"sku":"ANT\/CT\/04\/022","sort":0,"stockLevel":{"productId":[161,79528],"stockLevel":9},"supplierDeliveryTime":0,"supplierStockLevel":0,"taric":"","unNumber":"","upc":"","vat":19,"width":0,"attributes":[],"categories":[{"categoryId":[null,47],"id":["",80938],"productId":[161,79528]}],"checksums":[],"configGroups":[],"customerGroupPackagingQuantities":[],"fileDownloads":[],"i18ns":[{"productId":[161,79528],"deliveryStatus":"0 Tage","description":"","languageISO":"ger","measurementUnitName":null,"metaDescription":"","metaKeywords":"","name":"Continental MTB 26","shortDescription":"","titleTag":"","unitName":"St\u00fcck","urlPath":""}],"invisibilities":[],"mediaFiles":[],"partsLists":[],"prices":[{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":[161,79528],"items":[{"productPriceId":["",0],"netPrice":6.3025210084,"quantity":0}]}],"specialPrices":[],"specifics":[],"varCombinations":[],"variations":[],"warehouseInfo":[]},{"basePriceUnitId":["",0],"id":[162,79531],"manufacturerId":[null,176],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",0],"unitId":["",5],"asin":"","availableFrom":"2015-09-23T16:50:58+0000","basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":true,"considerVariationStock":false,"creationDate":"2015-09-23T16:53:06+0000","ean":"471778490012","epid":"","hazardIdNumber":"","height":0,"isActive":true,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","measurementQuantity":0,"measurementUnitCode":"","minBestBeforeDate":null,"minimumOrderQuantity":0,"minimumQuantity":1,"modified":"2015-11-10T15:23:50+0000","nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":false,"productWeight":0,"purchasePrice":3.25,"recommendedRetailPrice":5.46218487395,"serialNumbe


JTL Wawi / 1.0.9.2
Woocommerce / 2.5.2
Connector / 0.6.1
Php / 5.6.17
MySQL / 5.6.27

Beste Grüße,

Alex

 

[Sven M.]

AW: Verbindungsfehler / Webshopabgleich

Hallo Alex,

der Fehler deutet darauf hin, dass die Datenbank Tabelle jtl_connector_checksum bei der Aktivierung des Plugins nicht erstellt wurde. Bitte führe die Aktivierung erneut durch und überprüfe, iob die Tabelle erstellt wird. Die Produkte werden nicht korrekt übertragen, da dieser Fehler die Übertragung gestoppt hat.

Veile Grüße,
Sven

 

[THC_1.1]

AW: Verbindungsfehler / Webshopabgleich

Hallo Sven,

ich habe den Connector deaktiviert sowie erneut installiert. Dabei kam diese Fehlermeldung bei wp, die meines Erachtens nach auch das letzte Mal erschien /

Das Plugin verursachte 1291 Zeichen unerwartete Ausgabe während der Aktivierung. Sollte du Fehlermeldungen wie „headers already sent“, Probleme mit der Syndizierung der Feeds oder andere Fehler erhalten, versuche, das Plugin zu deaktivieren oder zu löschen.

Kann ich die Tabelle auch nachträglich auf dem Server anlegen, wenn sie nicht installiert wird?

Beste Grüße,

Alex

 

[Sven M.]

AW: Verbindungsfehler / Webshopabgleich

Hallo Alex,

das Problem wurde behoben. Es handelte sich dabei um einen Fehler der Auftritt, falls die Datenbank nicht die InnoDB Storage Engine sonder MyISAM verwendet. In der Version 0.7.0, welche heute released wird, ist der Fehler behoben.

Viele Grüße,
Sven