Neu Erster Shopabgleich nicht möglich - Exception bei global_data.pull - FROM wp_jtl_connector_link_customer_group WHERE endpoint_id = customer

Sebastian Lochbronner

Neues Mitglied
7. August 2019
1
0
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


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 &#039;customer&#039; in &#039;where clause&#039;]<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":"&euro;"}],"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 &#039;customer&#039; in &#039;where clause&#039;]<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":"&euro;"}],"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   
---------------------------
 

Jan Weskamp

Moderator
Mitarbeiter
19. August 2015
346
33
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


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 &#039;customer&#039; in &#039;where clause&#039;]<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":"&euro;"}],"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 &#039;customer&#039; in &#039;where clause&#039;]<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":"&euro;"}],"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  
---------------------------
Probier bitte die 1.8.2.4 aus :)

Liebe Grüße

Jan W.