Gelöst Exception: Illegal mix of collations

Goofy

Neues Mitglied
26. Oktober 2019
3
0
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?

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"}
 

Benjamin Schaffrath

Moderator
Mitarbeiter
31. Juli 2018
157
29
Hallo Goofy,

Das Problem ist uns bekannt und wir haben es bereits in der nächsten Version behoben. Vorraussichtlich wird diese am Dienstag erscheinen.

Viele Grüße

Gesendet von meinem LM-G710 mit Tapatalk