Hallo an alle,
wir bekommen bei der Übertragung eines Artikels von JTL an den Gambio Shop nachfolgenden Fehler.
Ich habe schon hier im Forum und im Gambio Forum versucht, etwas über diesen Fehler zu lesen bin aber nicht recht weitergekommen...
Es handelt sich um die Anbindung eines bestehenden Gambio Shops an eine neue JTL Wawi, die Artikel vom Shop sind sauber übertragen worden,
der Weg von der Wawi zum Shop geht auch bis auf die Bildübertragung
Vielleicht hat ja hier jemand einen Tipp was wir falsch machen bzw. wo der Fehler liegen könnte.
Herzlichen Dank für Eure Hilfe !!!
Wawi Version 1.15.1.13
Gambio platformVersion":"3.12.3.0
Connector endpointVersion":"2.10.3"
[2019-12-28 12:07:49] rpc.DEBUG: RequestPacket: {"method":"core.connector.auth","params":"{\"token\":\"****************\"}","jtlrpc":"2.0","id":"83436c58361346078aee376f762389f9"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: Params: {"token":"****************"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: {"result":{"sessionId":"bcf23c382084025ff5d3c08f1d9e04d0","lifetime":1440},"error":null,"jtlrpc":"2.0","id":"83436c58361346078aee376f762389f9"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: RequestPacket: {"method":"connector.identify","params":null,"jtlrpc":"2.0","id":"abd37c44d4654e3295eefb8ec1fee4c5"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: {"result":{"endpointVersion":"2.10.3","platformName":"Gambio","platformVersion":"3.12.3.0","protocolVersion":7,"serverInfo":{"memoryLimit":256,"executionTime":30,"postMaxSize":200,"uploadMaxFilesize":200}},"error":null,"jtlrpc":"2.0","id":"abd37c44d4654e3295eefb8ec1fee4c5"} [] []
[2019-12-28 12:07:50] rpc.DEBUG: RequestPacket: {"method":"global_data.pull","params":"{\"limit\":50,\"filters\":[]}","jtlrpc":"2.0","id":"fd3cac1be4ac493e9e197053864fdc5b"} [] []
[2019-12-28 12:07:50] rpc.DEBUG: Params: {"limit":50,"filters":[]} [] []
[2019-12-28 12:07:50] rpc.DEBUG:
[2019-12-28 14:06:15] rpc.DEBUG: RequestPacket: {"method":"core.connector.auth","params":"{\"token\":\"****************\"}","jtlrpc":"2.0","id":"5d380c8700df44b48d0372710bb974ef"} [] []
[2019-12-28 14:06:15] rpc.DEBUG: Params: {"token":"****************"} [] []
[2019-12-28 14:06:15] rpc.DEBUG: {"result":{"sessionId":"1ef2a0edf56d35963683834702c5b661","lifetime":1440},"error":null,"jtlrpc":"2.0","id":"5d380c8700df44b48d0372710bb974ef"} [] []
[2019-12-28 14:06:17] rpc.DEBUG: RequestPacket: {"method":"image.push","params":"[{\"filename\":\"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"483_1.jpg\",\"foreignKey\":[\"\",143],\"id\":[\"\",159],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"484_1.jpg\",\"foreignKey\":[\"\",144],\"id\":[\"\",161],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"1014_1000_59af10cd8afc2601c9346b6005a71872_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"485_1.jpg\",\"foreignKey\":[\"\",145],\"id\":[\"\",163],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"1024_354_f892ea2d522c10a426b8fedb365e5883_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"jbr_kesselanzeige.jpg\",\"foreignKey\":[\"\",148],\"id\":[\"\",167],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"800_600_6cee6ed451ee22e33b908ab674568497_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"Froeling_S4_1_1390_1.jpg\",\"foreignKey\":[\"\",152],\"id\":[\"\",1053],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[{\"id\":[\"\",817],\"imageId\":[\"\",1053],\"languageISO\":\"\",\"altText\":\"Froeling S4\"},{\"id\":[\"\",818],\"imageId\":[\"\",1053],\"languageISO\":\"ger\",\"altText\":\"Froeling S4\"}]}]","jtlrpc":"2.0","id":"93283b569b1b4d698a5b0b2e4a684495"} [] []
[2019-12-28 14:06:17] rpc.DEBUG: Params: [{"filename":"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"483_1.jpg","foreignKey":["",143],"id":["",159],"relationType":"product","sort":2,"i18ns":[]},{"filename":"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"484_1.jpg","foreignKey":["",144],"id":["",161],"relationType":"product","sort":2,"i18ns":[]},{"filename":"1014_1000_59af10cd8afc2601c9346b6005a71872_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"485_1.jpg","foreignKey":["",145],"id":["",163],"relationType":"product","sort":2,"i18ns":[]},{"filename":"1024_354_f892ea2d522c10a426b8fedb365e5883_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"jbr_kesselanzeige.jpg","foreignKey":["",148],"id":["",167],"relationType":"product","sort":2,"i18ns":[]},{"filename":"800_600_6cee6ed451ee22e33b908ab674568497_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"Froeling_S4_1_1390_1.jpg","foreignKey":["",152],"id":["",1053],"relationType":"product","sort":2,"i18ns":[{"id":["",817],"imageId":["",1053],"languageISO":"","altText":"Froeling S4"},{"id":["",818],"imageId":["",1053],"languageISO":"ger","altText":"Froeling S4"}]}] [] []
[2019-12-28 14:06:18] rpc.DEBUG: {"result":null,"error":{"code":0,"message":"Type: jtl\\Connector\\Model\\Image Host-Id: 1053 phar:\/\/\/www\/htdocs\XXXXXXXXXXXXXXXXXXX/jtlconnector\/index.php\/vendor\/jtl\/connector\/src\/Core\/Database\/Mysql.php (347):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":"93283b569b1b4d698a5b0b2e4a684495"} [] []
wir bekommen bei der Übertragung eines Artikels von JTL an den Gambio Shop nachfolgenden Fehler.
Ich habe schon hier im Forum und im Gambio Forum versucht, etwas über diesen Fehler zu lesen bin aber nicht recht weitergekommen...
Es handelt sich um die Anbindung eines bestehenden Gambio Shops an eine neue JTL Wawi, die Artikel vom Shop sind sauber übertragen worden,
der Weg von der Wawi zum Shop geht auch bis auf die Bildübertragung
Vielleicht hat ja hier jemand einen Tipp was wir falsch machen bzw. wo der Fehler liegen könnte.
Herzlichen Dank für Eure Hilfe !!!
Wawi Version 1.15.1.13
Gambio platformVersion":"3.12.3.0
Connector endpointVersion":"2.10.3"
[2019-12-28 12:07:49] rpc.DEBUG: RequestPacket: {"method":"core.connector.auth","params":"{\"token\":\"****************\"}","jtlrpc":"2.0","id":"83436c58361346078aee376f762389f9"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: Params: {"token":"****************"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: {"result":{"sessionId":"bcf23c382084025ff5d3c08f1d9e04d0","lifetime":1440},"error":null,"jtlrpc":"2.0","id":"83436c58361346078aee376f762389f9"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: RequestPacket: {"method":"connector.identify","params":null,"jtlrpc":"2.0","id":"abd37c44d4654e3295eefb8ec1fee4c5"} [] []
[2019-12-28 12:07:49] rpc.DEBUG: {"result":{"endpointVersion":"2.10.3","platformName":"Gambio","platformVersion":"3.12.3.0","protocolVersion":7,"serverInfo":{"memoryLimit":256,"executionTime":30,"postMaxSize":200,"uploadMaxFilesize":200}},"error":null,"jtlrpc":"2.0","id":"abd37c44d4654e3295eefb8ec1fee4c5"} [] []
[2019-12-28 12:07:50] rpc.DEBUG: RequestPacket: {"method":"global_data.pull","params":"{\"limit\":50,\"filters\":[]}","jtlrpc":"2.0","id":"fd3cac1be4ac493e9e197053864fdc5b"} [] []
[2019-12-28 12:07:50] rpc.DEBUG: Params: {"limit":50,"filters":[]} [] []
[2019-12-28 12:07:50] rpc.DEBUG:
[2019-12-28 14:06:15] rpc.DEBUG: RequestPacket: {"method":"core.connector.auth","params":"{\"token\":\"****************\"}","jtlrpc":"2.0","id":"5d380c8700df44b48d0372710bb974ef"} [] []
[2019-12-28 14:06:15] rpc.DEBUG: Params: {"token":"****************"} [] []
[2019-12-28 14:06:15] rpc.DEBUG: {"result":{"sessionId":"1ef2a0edf56d35963683834702c5b661","lifetime":1440},"error":null,"jtlrpc":"2.0","id":"5d380c8700df44b48d0372710bb974ef"} [] []
[2019-12-28 14:06:17] rpc.DEBUG: RequestPacket: {"method":"image.push","params":"[{\"filename\":\"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"483_1.jpg\",\"foreignKey\":[\"\",143],\"id\":[\"\",159],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"484_1.jpg\",\"foreignKey\":[\"\",144],\"id\":[\"\",161],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"1014_1000_59af10cd8afc2601c9346b6005a71872_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"485_1.jpg\",\"foreignKey\":[\"\",145],\"id\":[\"\",163],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"1024_354_f892ea2d522c10a426b8fedb365e5883_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"jbr_kesselanzeige.jpg\",\"foreignKey\":[\"\",148],\"id\":[\"\",167],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[]},{\"filename\":\"800_600_6cee6ed451ee22e33b908ab674568497_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg\",\"remoteUrl\":null,\"name\":\"Froeling_S4_1_1390_1.jpg\",\"foreignKey\":[\"\",152],\"id\":[\"\",1053],\"relationType\":\"product\",\"sort\":2,\"i18ns\":[{\"id\":[\"\",817],\"imageId\":[\"\",1053],\"languageISO\":\"\",\"altText\":\"Froeling S4\"},{\"id\":[\"\",818],\"imageId\":[\"\",1053],\"languageISO\":\"ger\",\"altText\":\"Froeling S4\"}]}]","jtlrpc":"2.0","id":"93283b569b1b4d698a5b0b2e4a684495"} [] []
[2019-12-28 14:06:17] rpc.DEBUG: Params: [{"filename":"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"483_1.jpg","foreignKey":["",143],"id":["",159],"relationType":"product","sort":2,"i18ns":[]},{"filename":"1648_2917_f217cf517a88a91fd399b2f6a8ab98d0_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"484_1.jpg","foreignKey":["",144],"id":["",161],"relationType":"product","sort":2,"i18ns":[]},{"filename":"1014_1000_59af10cd8afc2601c9346b6005a71872_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"485_1.jpg","foreignKey":["",145],"id":["",163],"relationType":"product","sort":2,"i18ns":[]},{"filename":"1024_354_f892ea2d522c10a426b8fedb365e5883_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"jbr_kesselanzeige.jpg","foreignKey":["",148],"id":["",167],"relationType":"product","sort":2,"i18ns":[]},{"filename":"800_600_6cee6ed451ee22e33b908ab674568497_cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e.jpg","remoteUrl":null,"name":"Froeling_S4_1_1390_1.jpg","foreignKey":["",152],"id":["",1053],"relationType":"product","sort":2,"i18ns":[{"id":["",817],"imageId":["",1053],"languageISO":"","altText":"Froeling S4"},{"id":["",818],"imageId":["",1053],"languageISO":"ger","altText":"Froeling S4"}]}] [] []
[2019-12-28 14:06:18] rpc.DEBUG: {"result":null,"error":{"code":0,"message":"Type: jtl\\Connector\\Model\\Image Host-Id: 1053 phar:\/\/\/www\/htdocs\XXXXXXXXXXXXXXXXXXX/jtlconnector\/index.php\/vendor\/jtl\/connector\/src\/Core\/Database\/Mysql.php (347):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":"93283b569b1b4d698a5b0b2e4a684495"} [] []