Wawi-Version : 1.5.10.0
Prestashop-Version : 1.7.6.1
Connector-Version : 1.6.1
Hallo,
ich habe alles neu eingerichtet (Win Server 2016, SQL usw..) , JTL neu installiert und beim Online- Shop Abgleich erscheint folgender Fehler.
Woran kann das liegen?
Prestashop-Version : 1.7.6.1
Connector-Version : 1.6.1
Hallo,
ich habe alles neu eingerichtet (Win Server 2016, SQL usw..) , JTL neu installiert und beim Online- Shop Abgleich erscheint folgender Fehler.
Woran kann das liegen?
Code:
Abgleich-Protokoll:
Onlineshop-Abgleich beendet für 'xxxxx'.
Fehler:
Exception: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='<br /><br /><pre>
SELECT COUNT(*)
FROM ps_product p
LEFT JOIN jtl_connector_link_product l ON CAST(p.id_product AS CHAR) = l.endpoint_id
WHERE l.host_id IS NULL LIMIT 1</pre>
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='<br /><br /><pre>
SELECT COUNT(*)
FROM ps_product p
LEFT JOIN jtl_connector_link_product l ON CAST(p.id_product AS CHAR) = l.endpoint_id
WHERE l.host_id IS NULL LIMIT 1</pre>
Exception bei Product.statistic: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='<br /><br /><pre>
SELECT COUNT(*)
FROM ps_product p
LEFT JOIN jtl_connector_link_product l ON CAST(p.id_product AS CHAR) = l.endpoint_id
WHERE l.host_id IS NULL LIMIT 1</pre>
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='<br /><br /><pre>
SELECT COUNT(*)
FROM ps_product p
LEFT JOIN jtl_connector_link_product l ON CAST(p.id_product AS CHAR) = l.endpoint_id
WHERE l.host_id IS NULL LIMIT 1</pre>
Response: {"result":null,"error":{"code":0,"message":"Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='<br \/><br \/><pre>\n\t\t\tSELECT COUNT(*) \n\t\t\tFROM ps_product p\n\t\t\tLEFT JOIN jtl_connector_link_product l ON CAST(p.id_product AS CHAR) = l.endpoint_id\n WHERE l.host_id IS NULL LIMIT 1<\/pre>","data":null},"jtlrpc":"2.0","id":"xxxxxxx"}