In Bearbeitung Fehler bei Bildübertragung zu Gambio Shop

[novvia]

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

 

[Immanuel]

Hallo @novvia,

möglicherweise überschreitet die Bildgröße des Bildes mit der Host Id 1053 die upload max filesize oder post max size.

 

[novvia]

Hallo Immanuel, danke für Deine Mühe!!! Ich prüfe das und melde mich wieder

Herzliche Grüße
Peter