Sebastian Lochbronner
Neues Mitglied
Hallo,
ich habe heute einen ersten Shopabgleich WaWi - WooCommerce versucht und folgenden Fehler erhalten (tritt bei Konfiguration als auch Abgleich auf). Sowohl WaWi als auch WooCommerce sind bereits live im Betrieb. (hier getestet mit duplizierten Versionen)
WaWi: 1.4.33.0
WooCommerce: 3.6.5
Connector: 1.8.2.3
Plugins:
Germanized
Slider Revolution
The Events Calendar
WooCommerce Table Rate Shipping
DHL for WooCommerce
WPBakery Page Builder
Yoast SEO
ich habe heute einen ersten Shopabgleich WaWi - WooCommerce versucht und folgenden Fehler erhalten (tritt bei Konfiguration als auch Abgleich auf). Sowohl WaWi als auch WooCommerce sind bereits live im Betrieb. (hier getestet mit duplizierten Versionen)
WaWi: 1.4.33.0
WooCommerce: 3.6.5
Connector: 1.8.2.3
Plugins:
Germanized
Slider Revolution
The Events Calendar
WooCommerce Table Rate Shipping
DHL for WooCommerce
WPBakery Page Builder
Yoast SEO
Code:
---------------------------
JTL-Wawi
---------------------------
Fehler beim Verbindungsaufbau: Exception bei global_data.pull:
DeserializeObject-Error: Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.
bei Newtonsoft.Json.JsonTextReader.ParseValue()
bei Newtonsoft.Json.JsonTextReader.ReadInternal()
bei Newtonsoft.Json.JsonTextReader.Read()
bei Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter)
bei Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
bei Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
bei Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
bei Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
bei jtlCore.ControllerClasses.Connector.Core.Json.DeserializeObject[T](String json)
Json:<div id="error"><p class="wpdberror"><strong>WordPress database error:</strong> [Unknown column 'customer' in 'where clause']<br /><code>SELECT host_id
FROM wp_jtl_connector_link_customer_group
WHERE endpoint_id =
customer</code></p></div>{"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["eur",0],"delimiterCent":".","delimiterThousand":",","factor":0,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"EUR","name":"EUR","nameHtml":"€"}],"cus
tomerGroups":[{"id":["customer",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["customer",0],"languageISO":"eng","name":"Customer"}]}],"languages":[{"id":["eng",0],"isDefault":true,"languageISO":"eng","nameEnglish":"English","nameG
erman":"Englisch"}],"measurementUnits":[{"id":["23",0],"code":"kg","displayCode":"kg","i18ns":[{"measurementUnitId":["23",0],"languageISO":"eng","name":"kg"}]},{"id":["24",0],"code":"g","displayCode":"g","i18ns":[{"measurementUnitId":["24",0],"languageISO":"eng","name":"g"}]},{"id":[
"25",0],"code":"lbs","displayCode":"lbs","i18ns":[{"measurementUnitId":["25",0],"languageISO":"eng","name":"lbs"}]},{"id":["26",0],"code":"oz","displayCode":"oz","i18ns":[{"measurementUnitId":["26",0],"languageISO":"eng","name":"oz"}]},{"id":["27",0],"code":"m","displayCode":"m","i18
ns":[{"measurementUnitId":["27",0],"languageISO":"eng","name":"m"}]},{"id":["28",0],"code":"cm","displayCode":"cm","i18ns":[{"measurementUnitId":["28",0],"languageISO":"eng","name":"cm"}]},{"id":["29",0],"code":"mm","displayCode":"mm","i18ns":[{"measurementUnitId":["29",0],"languageI
SO":"eng","name":"mm"}]},{"id":["30",0],"code":"in","displayCode":"in","i18ns":[{"measurementUnitId":["30",0],"languageISO":"eng","name":"in"}]},{"id":["31",0],"code":"yd","displayCode":"yd","i18ns":[{"measurementUnitId":["31",0],"languageISO":"eng","name":"yd"}]},{"id":["32",0],"cod
e":"mL","displayCode":"ml","i18ns":[{"measurementUnitId":["32",0],"languageISO":"eng","name":"ml"}]},{"id":["33",0],"code":"L","displayCode":"l","i18ns":[{"measurementUnitId":["33",0],"languageISO":"eng","name":"l"}]}],"productTypes":[{"id":["simple",0],"name":"Simple
product"},{"id":["grouped",0],"name":"Grouped product"},{"id":["external",0],"name":"External\/Affiliate product"},{"id":["variable",0],"name":"Variable product"}],"shippingClasses":[],"shippingMethods":[{"id":["flat_rate",0],"name":"Flat rate"},{"id":["free_shipping",0],"name":"Free
shipping"},{"id":["local_pickup",0],"name":"Local pickup"},{"id":["betrs_shipping",0],"name":"Table
Rate"}],"taxRates":[{"id":["1",0],"rate":19},{"id":["3",0],"rate":7},{"id":["4",0],"rate":21},{"id":["5",0],"rate":20},{"id":["6",0],"rate":21},{"id":["7",0],"rate":25},{"id":["8",0],"rate":19},{"id":["9",0],"rate":20},{"id":["10",0],"rate":23},{"id":["11",0],"rate":21},{"id":["12",0
],"rate":20},{"id":["13",0],"rate":25},{"id":["14",0],"rate":23},{"id":["15",0],"rate":22},{"id":["16",0],"rate":19},{"id":["17",0],"rate":21},{"id":["18",0],"rate":21},{"id":["19",0],"rate":15},{"id":["20",0],"rate":27},{"id":["21",0],"rate":18},{"id":["22",0],"rate":21},{"id":["23"
,0],"rate":20},{"id":["24",0],"rate":23},{"id":["25",0],"rate":23},{"id":["26",0],"rate":24},{"id":["27",0],"rate":22},{"id":["28",0],"rate":20},{"id":["29",0],"rate":24},{"id":["30",0],"rate":25},{"id":["31",0],"rate":20},{"id":["32",0],"rate":0}],"units":[],"warehouses":[]}],"error
":null,"jtlrpc":"2.0","id":"f08b1dbb486645a18ab5645bdd7e3f23"}
Response: <div id="error"><p class="wpdberror"><strong>WordPress database error:</strong> [Unknown column 'customer' in 'where clause']<br /><code>SELECT host_id
FROM wp_jtl_connector_link_customer_group
WHERE endpoint_id =
customer</code></p></div>{"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["eur",0],"delimiterCent":".","delimiterThousand":",","factor":0,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"EUR","name":"EUR","nameHtml":"€"}],"cus
tomerGroups":[{"id":["customer",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["customer",0],"languageISO":"eng","name":"Customer"}]}],"languages":[{"id":["eng",0],"isDefault":true,"languageISO":"eng","nameEnglish":"English","nameG
erman":"Englisch"}],"measurementUnits":[{"id":["23",0],"code":"kg","displayCode":"kg","i18ns":[{"measurementUnitId":["23",0],"languageISO":"eng","name":"kg"}]},{"id":["24",0],"code":"g","displayCode":"g","i18ns":[{"measurementUnitId":["24",0],"languageISO":"eng","name":"g"}]},{"id":[
"25",0],"code":"lbs","displayCode":"lbs","i18ns":[{"measurementUnitId":["25",0],"languageISO":"eng","name":"lbs"}]},{"id":["26",0],"code":"oz","displayCode":"oz","i18ns":[{"measurementUnitId":["26",0],"languageISO":"eng","name":"oz"}]},{"id":["27",0],"code":"m","displayCode":"m","i18
ns":[{"measurementUnitId":["27",0],"languageISO":"eng","name":"m"}]},{"id":["28",0],"code":"cm","displayCode":"cm","i18ns":[{"measurementUnitId":["28",0],"languageISO":"eng","name":"cm"}]},{"id":["29",0],"code":"mm","displayCode":"mm","i18ns":[{"measurementUnitId":["29",0],"languageI
SO":"eng","name":"mm"}]},{"id":["30",0],"code":"in","displayCode":"in","i18ns":[{"measurementUnitId":["30",0],"languageISO":"eng","name":"in"}]},{"id":["31",0],"code":"yd","displayCode":"yd","i18ns":[{"measurementUnitId":["31",0],"languageISO":"eng","name":"yd"}]},{"id":["32",0],"cod
e":"mL","displayCode":"ml","i18ns":[{"measurementUnitId":["32",0],"languageISO":"eng","name":"ml"}]},{"id":["33",0],"code":"L","displayCode":"l","i18ns":[{"measurementUnitId":["33",0],"languageISO":"eng","name":"l"}]}],"productTypes":[{"id":["simple",0],"name":"Simple
product"},{"id":["grouped",0],"name":"Grouped product"},{"id":["external",0],"name":"External\/Affiliate product"},{"id":["variable",0],"name":"Variable product"}],"shippingClasses":[],"shippingMethods":[{"id":["flat_rate",0],"name":"Flat rate"},{"id":["free_shipping",0],"name":"Free
shipping"},{"id":["local_pickup",0],"name":"Local pickup"},{"id":["betrs_shipping",0],"name":"Table
Rate"}],"taxRates":[{"id":["1",0],"rate":19},{"id":["3",0],"rate":7},{"id":["4",0],"rate":21},{"id":["5",0],"rate":20},{"id":["6",0],"rate":21},{"id":["7",0],"rate":25},{"id":["8",0],"rate":19},{"id":["9",0],"rate":20},{"id":["10",0],"rate":23},{"id":["11",0],"rate":21},{"id":["12",0
],"rate":20},{"id":["13",0],"rate":25},{"id":["14",0],"rate":23},{"id":["15",0],"rate":22},{"id":["16",0],"rate":19},{"id":["17",0],"rate":21},{"id":["18",0],"rate":21},{"id":["19",0],"rate":15},{"id":["20",0],"rate":27},{"id":["21",0],"rate":18},{"id":["22",0],"rate":21},{"id":["23"
,0],"rate":20},{"id":["24",0],"rate":23},{"id":["25",0],"rate":23},{"id":["26",0],"rate":24},{"id":["27",0],"rate":22},{"id":["28",0],"rate":20},{"id":["29",0],"rate":24},{"id":["30",0],"rate":25},{"id":["31",0],"rate":20},{"id":["32",0],"rate":0}],"units":[],"warehouses":[]}],"error
":null,"jtlrpc":"2.0","id":"f08b1dbb486645a18ab5645bdd7e3f23"}
---------------------------
OK
---------------------------