Neu [Fehler] Gambio Abgleich Fehler beim Produktabgleich

[horphi]

Hallo,

ich habe gerade Preise angepasst und bei den letztem 11 Artikeln bricht der Connector ab.
Hatte jemand diesen Fehler schon mal?
Connector: 2.13.0
Gambio: 4.2.0.0



Abgleich-Protokoll:
Bitte beachten Sie, dass JTL-Wawi federführend ist!
Im Shop-Backend vorgenommene Änderungen können nicht mehr automatisiert abgeglichen werden und führen somit zu Datenverlust.
Prüfe Endpointkonfiguration.
Abgleich gestartet für ''.
Onlineshop-Abgleich beendet für ''.


Fehler:
Exception: Type: ProductPrice Product Host-Id: 2174 phar:///www/htdocs/jtlconnector/connector.phar/vendor/jtl/connector/src/Core/Database/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Type: ProductPrice Product Host-Id: 2174 phar:///www/htdocs/jtlconnector/connector.phar/vendor/jtl/connector/src/Core/Database/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Artikelbestände/-preise-QuickSync-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei product_price.push: Type: ProductPrice Product Host-Id: 2174 phar:///www/htdocs/jtlconnector/connector.phar/vendor/jtl/connector/src/Core/Database/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Type: ProductPrice Product Host-Id: 2174 phar:///www/htdocs/jtlconnector/connector.phar/vendor/jtl/connector/src/Core/Database/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Response: {"result":null,"error":{"code":0,"message":"Type: ProductPrice Product Host-Id: 2174 phar:\/\/\/www\/htdocs\/jtlconnector\/connector.phar\/vendor\/jtl\/connector\/src\/Core\/Database\/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1","data":null},"jtlrpc":"2.0","id":"37669ad5e70348cd8181ed62ecc275f2"}
Exception bei product_price.push: Type: ProductPrice Product Host-Id: 2174 phar:///www/htdocs/jtlconnector/connector.phar/vendor/jtl/connector/src/Core/Database/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Type: ProductPrice Product Host-Id: 2174 phar:///www/htdocs/jtlconnector/connector.phar/vendor/jtl/connector/src/Core/Database/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Response: {"result":null,"error":{"code":0,"message":"Type: ProductPrice Product Host-Id: 2174 phar:\/\/\/www\/htdocs\/jtlconnector\/connector.phar\/vendor\/jtl\/connector\/src\/Core\/Database\/Mysql.php (333):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1","data":null},"jtlrpc":"2.0","id":"7589eefee04845738affde72c6b6fa6a"}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.JNV1Dg4JWNO(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.W1v1DRtn9Hy(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.JNV1Dg4JWNO(String , Object , Boolean , NetworkCredential )




Viele Grüße,

Philipp

 

[bork]

Der Artikelpreis für 2174 ist irgendwie kaputt. Schau mal ins Connector Log welcher Artikel das ist und schau ob es da was besonderes beim Preis gibt.