Guten Tag.
Ich habe die .76er WAWI und den 1.0.11er Connector für Shopware 5 installiert. Glücklicherweise habe ich seit dieser Connector-Version keine Fehlermeldungen "im Status-Fenster" mehr nach Ende des Abgleichs.
Allerdings werden die Artikel auch nicht im Shop aktualisiert. Im Abgleich wird mir immer angezeigt, dass er 2 Artikel zum Shop sendet; auch wenn ich KEINEN Artikel in der Wawi geändert habe oder auch wenn ich 20 Artikel geändert habe.
Geändert wird im Shop allerdings NICHTS.
Hier mal ein paar Log-Dateien
Controller.log:
[2015-09-10 12:06:58] controller.WARNING: Exception 'jtl\Connector\Core\Exception\DatabaseException' (Code: 0) with message 'Product Endpoint Id cannot be empty' in phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/ProductStockLevel.php:41 [] []
[2015-09-10 12:16:38] controller.WARNING: Exception 'jtl\Connector\Core\Exception\DatabaseException' (Code: 0) with message 'Product Endpoint Id cannot be empty' in phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/ProductStockLevel.php:41 [] []
Global.log:
[2015-09-10 14:08:12] global.WARNING: (E_WARNING) File (/var/customers/webs/kroen/engine/Shopware/Models/Media/Media.php, 783): unlink(/tmp/stamskin-top-20161-brume-1-10267-024.jpg): No such file or directory [] []
[2015-09-10 14:08:13] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:14] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:14] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:15] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:15] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
Datebase.log:
[2015-09-10 14:21:09] database.ERROR: Exception from Product (, 319) [] []
[2015-09-10 14:21:09] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [360, null, "10003-0001", "11505", 1, "22,5 m 13,5 mm", true, 0, 0, 0, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10003-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:23:57] database.ERROR: Exception from Product (, 368) [] []
[2015-09-10 14:23:57] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [298, null, "10009-0001", "11362", 1, "8 mm", true, 0, 0, 0.001000000047497, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, "2015-09-01", null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10009-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:33:59] database.ERROR: Exception from Product (, 379) [] []
[2015-09-10 14:33:59] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [368, null, "10010-0001", "10323", 1, "10 mm", true, 0, 0, 0.001900000032037, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10010-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:39:38] database.ERROR: Exception from Product (, 379) [] []
[2015-09-10 14:39:38] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [368, null, "10010-0001", "10323", 1, "10 mm", true, 0, 0, 0.001900000032037, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10010-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:45:50] database.ERROR: Exception from Product (, 368) [] []
[2015-09-10 14:45:50] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [298, null, "10009-0001", "11362", 1, "8 mm", true, 0, 0, 0.001000000047497, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, "2015-09-01", null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10009-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:49:38] database.ERROR: Exception from Product (, 368) [] []
[2015-09-10 14:49:38] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [298, null, "10009-0001", "11362", 1, "8 mm", true, 0, 0, 0.001000000047497, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, "2015-09-01", null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10009-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:52:40] database.ERROR: Exception from Product (, 737) [] []
[2015-09-10 14:52:40] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [321, null, "10145-0001", "10197", 1, "wei\u00df \/ 1300 Kg", true, 0, 0, 0, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10145-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:56:18] database.ERROR: Exception from Product (, 737) [] []
[2015-09-10 14:56:18] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [321, null, "10145-0001", "10197", 1, "wei\u00df \/ 1300 Kg", true, 0, 0, 0, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10145-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
Connector-Abgleich-Debug:
JTL-Wawi: StartForm()
JTL-Wawi: MainWindow != null
JTL-Wawi: Sync start
JTL-Wawi: Licence is valid
JTL-Wawi: InitCall OK
JTL-Wawi: Initialize model getters...
>>> Customer.statistic: {
"method": "Customer.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "73a49e7fc6444def9b98232e68a50720"
}
<<< Customer.statistic: {"result":{"available":0,"controllerName":"customer"},"error":null,"jtlrpc":"2.0","id":"73a49e7fc6444def9b98232e68a50720"}
(297,233 milliseconds)
>>> CustomerOrder.statistic: {
"method": "CustomerOrder.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "b5351f17d3644ee180d4f8950afccafd"
}
<<< CustomerOrder.statistic: {"result":{"available":0,"controllerName":"customerOrder"},"error":null,"jtlrpc":"2.0","id":"b5351f17d3644ee180d4f8950afccafd"}
(272,6263 milliseconds)
>>> Payment.statistic: {
"method": "Payment.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "fb15d46f301e45cb99afce5fa3ad7793"
}
<<< Payment.statistic: {"result":{"available":0,"controllerName":"payment"},"error":null,"jtlrpc":"2.0","id":"fb15d46f301e45cb99afce5fa3ad7793"}
(266,9607 milliseconds)
>>> Image.statistic: {
"method": "Image.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "f8864f2c78dd4f8f89d546744772745b"
}
<<< Image.statistic: {"result":{"available":256,"controllerName":"image"},"error":null,"jtlrpc":"2.0","id":"f8864f2c78dd4f8f89d546744772745b"}
(285,7221 milliseconds)
>>> Specific.statistic: {
"method": "Specific.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "fcee9f1a18cd4e2d87e4dce0a06f1c3a"
}
<<< Specific.statistic: {"result":{"available":0,"controllerName":"specific"},"error":null,"jtlrpc":"2.0","id":"fcee9f1a18cd4e2d87e4dce0a06f1c3a"}
(292,9719 milliseconds)
>>> Manufacturer.statistic: {
"method": "Manufacturer.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "c91c732a84e54695a23f88575dc5154b"
}
<<< Manufacturer.statistic: {"result":{"available":0,"controllerName":"manufacturer"},"error":null,"jtlrpc":"2.0","id":"c91c732a84e54695a23f88575dc5154b"}
(297,4742 milliseconds)
JTL-Wawi: ModelGetters OK
>>> global_data.pull: {
"method": "global_data.pull",
"params": {
"limit": 50,
"filters": {}
},
"jtlrpc": "2.0",
"id": "cb8cdb53e1d44c96bcdd944cc1c06194"
}
<<< global_data.pull: {"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["1",0],"delimiterCent":"","delimiterThousand":"","factor":1,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"EUR","name":"Euro","nameHtml":"€"}],"customerGroups":[{"id":["1",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["1",0],"languageISO":"ger","name":"Shopkunden"}]},{"id":["2",0],"applyNetPrice":false,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["2",0],"languageISO":"ger","name":"H\u00e4ndler"}]}],"languages":[{"id":["1",0],"isDefault":true,"languageISO":"ger","nameEnglish":"Deutsch","nameGerman":"Deutsch"}],"measurementUnits":[{"id":["1",0],"code":"L","displayCode":"Liter","i18ns":[{"measurementUnitId":["1",0],"languageISO":"ger","name":"Liter"}]},{"id":["2",0],"code":"g","displayCode":"Gramm","i18ns":[{"measurementUnitId":["2",0],"languageISO":"ger","name":"Gramm"}]},{"id":["5",0],"code":"lfm","displayCode":"lfm","i18ns":[{"measurementUnitId":["5",0],"languageISO":"ger","name":"lfm"}]},{"id":["6",0],"code":"kg","displayCode":"Kilogramm","i18ns":[{"measurementUnitId":["6",0],"languageISO":"ger","name":"Kilogramm"}]},{"id":["8",0],"code":"Paket(e)","displayCode":"Paket(e)","i18ns":[{"measurementUnitId":["8",0],"languageISO":"ger","name":"Paket(e)"}]},{"id":["9",0],"code":"Stck.","displayCode":"St\u00fcck","i18ns":[{"measurementUnitId":["9",0],"languageISO":"ger","name":"St\u00fcck"}]},{"id":["10",0],"code":"m","displayCode":"Meter","i18ns":[{"measurementUnitId":["10",0],"languageISO":"ger","name":"Meter"}]},{"id":["11",0],"code":"mm","displayCode":"Millimeter","i18ns":[{"measurementUnitId":["11",0],"languageISO":"ger","name":"Millimeter"}]},{"id":["12",0],"code":"cm","displayCode":"Centimeter","i18ns":[{"measurementUnitId":["12",0],"languageISO":"ger","name":"Centimeter"}]},{"id":["13",0],"code":"dm","displayCode":"Dezimeter","i18ns":[{"measurementUnitId":["13",0],"languageISO":"ger","name":"Dezimeter"}]},{"id":["14",0],"code":"[in_i]","displayCode":"Zoll","i18ns":[{"measurementUnitId":["14",0],"languageISO":"ger","name":"Zoll"}]},{"id":["15",0],"code":"km","displayCode":"Kilometer","i18ns":[{"measurementUnitId":["15",0],"languageISO":"ger","name":"Kilometer"}]},{"id":["16",0],"code":"mg","displayCode":"Milligramm","i18ns":[{"measurementUnitId":["16",0],"languageISO":"ger","name":"Milligramm"}]},{"id":["17",0],"code":"[lb_av]","displayCode":"Pfund","i18ns":[{"measurementUnitId":["17",0],"languageISO":"ger","name":"Pfund"}]},{"id":["18",0],"code":"t","displayCode":"Tonne","i18ns":[{"measurementUnitId":["18",0],"languageISO":"ger","name":"Tonne"}]},{"id":["19",0],"code":"m2","displayCode":"Quadratmeter","i18ns":[{"measurementUnitId":["19",0],"languageISO":"ger","name":"Quadratmeter"}]},{"id":["20",0],"code":"mm2","displayCode":"Quadratmillimeter","i18ns":[{"measurementUnitId":["20",0],"languageISO":"ger","name":"Quadratmillimeter"}]},{"id":["21",0],"code":"cm2","displayCode":"Quadratcentimeter","i18ns":[{"measurementUnitId":["21",0],"languageISO":"ger","name":"Quadratcentimeter"}]},{"id":["22",0],"code":"mL","displayCode":"Milliliter","i18ns":[{"measurementUnitId":["22",0],"languageISO":"ger","name":"Milliliter"}]},{"id":["23",0],"code":"dL","displayCode":"Deziliter","i18ns":[{"measurementUnitId":["23",0],"languageISO":"ger","name":"Deziliter"}]},{"id":["24",0],"code":"cL","displayCode":"Centiliter","i18ns":[{"measurementUnitId":["24",0],"languageISO":"ger","name":"Centiliter"}]},{"id":["25",0],"code":"m3","displayCode":"Kubikmeter","i18ns":[{"measurementUnitId":["25",0],"languageISO":"ger","name":"Kubikmeter"}]},{"id":["26",0],"code":"cm3","displayCode":"Kubikcentimeter","i18ns":[{"measurementUnitId":["26",0],"languageISO":"ger","name":"Kubikcentimeter"}]}],"productTypes":[],"shippingClasses":[],"shippingMethods":[{"id":["9",0],"name":"Standard Versand"}],"taxRates":[{"id":["1",0],"rate":19},{"id":["4",0],"rate":7}],"units":[{"id":["1",0],"i18ns":[{"unitId":["1",0],"languageISO":"ger","name":""}]},{"id":["2",0],"i18ns":[{"unitId":["2",0],"languageISO":"ger","name":""}]},{"id":["3",0],"i18ns":[{"unitId":["3",0],"languageISO":"ger","name":""}]},{"id":["4",0],"i18ns":[{"unitId":["4",0],"languageISO":"ger","name":""}]},{"id":["5",0],"i18ns":[{"unitId":["5",0],"languageISO":"ger","name":""}]},{"id":["6",0],"i18ns":[{"unitId":["6",0],"languageISO":"ger","name":""}]}],"warehouses":[]}],"error":null,"jtlrpc":"2.0","id":"cb8cdb53e1d44c96bcdd944cc1c06194"}
(350,6575 milliseconds)
JTL-Wawi: End sync
Wäre prima wenn mir jemand einen Hinweis geben könnte.
Danke!
Gruß
Ich habe die .76er WAWI und den 1.0.11er Connector für Shopware 5 installiert. Glücklicherweise habe ich seit dieser Connector-Version keine Fehlermeldungen "im Status-Fenster" mehr nach Ende des Abgleichs.
Allerdings werden die Artikel auch nicht im Shop aktualisiert. Im Abgleich wird mir immer angezeigt, dass er 2 Artikel zum Shop sendet; auch wenn ich KEINEN Artikel in der Wawi geändert habe oder auch wenn ich 20 Artikel geändert habe.
Geändert wird im Shop allerdings NICHTS.
Hier mal ein paar Log-Dateien
Controller.log:
[2015-09-10 12:06:58] controller.WARNING: Exception 'jtl\Connector\Core\Exception\DatabaseException' (Code: 0) with message 'Product Endpoint Id cannot be empty' in phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/ProductStockLevel.php:41 [] []
[2015-09-10 12:16:38] controller.WARNING: Exception 'jtl\Connector\Core\Exception\DatabaseException' (Code: 0) with message 'Product Endpoint Id cannot be empty' in phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/ProductStockLevel.php:41 [] []
Global.log:
[2015-09-10 14:08:12] global.WARNING: (E_WARNING) File (/var/customers/webs/kroen/engine/Shopware/Models/Media/Media.php, 783): unlink(/tmp/stamskin-top-20161-brume-1-10267-024.jpg): No such file or directory [] []
[2015-09-10 14:08:13] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:14] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:14] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:15] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
[2015-09-10 14:08:15] global.NOTICE: (E_NOTICE) File (phar:///var/customers/webs/kroen/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Mapper/Image.php, 178): Undefined offset: 2 [] []
Datebase.log:
[2015-09-10 14:21:09] database.ERROR: Exception from Product (, 319) [] []
[2015-09-10 14:21:09] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [360, null, "10003-0001", "11505", 1, "22,5 m 13,5 mm", true, 0, 0, 0, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10003-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:23:57] database.ERROR: Exception from Product (, 368) [] []
[2015-09-10 14:23:57] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [298, null, "10009-0001", "11362", 1, "8 mm", true, 0, 0, 0.001000000047497, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, "2015-09-01", null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10009-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:33:59] database.ERROR: Exception from Product (, 379) [] []
[2015-09-10 14:33:59] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [368, null, "10010-0001", "10323", 1, "10 mm", true, 0, 0, 0.001900000032037, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10010-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:39:38] database.ERROR: Exception from Product (, 379) [] []
[2015-09-10 14:39:38] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [368, null, "10010-0001", "10323", 1, "10 mm", true, 0, 0, 0.001900000032037, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10010-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:45:50] database.ERROR: Exception from Product (, 368) [] []
[2015-09-10 14:45:50] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [298, null, "10009-0001", "11362", 1, "8 mm", true, 0, 0, 0.001000000047497, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, "2015-09-01", null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10009-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:49:38] database.ERROR: Exception from Product (, 368) [] []
[2015-09-10 14:49:38] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [298, null, "10009-0001", "11362", 1, "8 mm", true, 0, 0, 0.001000000047497, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, "2015-09-01", null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10009-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:52:40] database.ERROR: Exception from Product (, 737) [] []
[2015-09-10 14:52:40] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [321, null, "10145-0001", "10197", 1, "wei\u00df \/ 1300 Kg", true, 0, 0, 0, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10145-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
[2015-09-10 14:56:18] database.ERROR: Exception from Product (, 737) [] []
[2015-09-10 14:56:18] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_details (articleID, unitID, ordernumber, suppliernumber, kind, additionaltext, active, instock, stockmin, weight, width, length, height, ean, position, minpurchase, purchasesteps, maxpurchase, purchaseunit, referenceunit, packunit, shippingfree, releasedate, shippingtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [321, null, "10145-0001", "10197", 1, "wei\u00df \/ 1300 Kg", true, 0, 0, 0, 0, 0, 0, "", 0, 1, 0, null, 0, 0, "St\u00fcck", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10145-0001' for key 'ordernumber'' in /var/customers/webs/kroen/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 [] []
Connector-Abgleich-Debug:
JTL-Wawi: StartForm()
JTL-Wawi: MainWindow != null
JTL-Wawi: Sync start
JTL-Wawi: Licence is valid
JTL-Wawi: InitCall OK
JTL-Wawi: Initialize model getters...
>>> Customer.statistic: {
"method": "Customer.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "73a49e7fc6444def9b98232e68a50720"
}
<<< Customer.statistic: {"result":{"available":0,"controllerName":"customer"},"error":null,"jtlrpc":"2.0","id":"73a49e7fc6444def9b98232e68a50720"}
(297,233 milliseconds)
>>> CustomerOrder.statistic: {
"method": "CustomerOrder.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "b5351f17d3644ee180d4f8950afccafd"
}
<<< CustomerOrder.statistic: {"result":{"available":0,"controllerName":"customerOrder"},"error":null,"jtlrpc":"2.0","id":"b5351f17d3644ee180d4f8950afccafd"}
(272,6263 milliseconds)
>>> Payment.statistic: {
"method": "Payment.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "fb15d46f301e45cb99afce5fa3ad7793"
}
<<< Payment.statistic: {"result":{"available":0,"controllerName":"payment"},"error":null,"jtlrpc":"2.0","id":"fb15d46f301e45cb99afce5fa3ad7793"}
(266,9607 milliseconds)
>>> Image.statistic: {
"method": "Image.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "f8864f2c78dd4f8f89d546744772745b"
}
<<< Image.statistic: {"result":{"available":256,"controllerName":"image"},"error":null,"jtlrpc":"2.0","id":"f8864f2c78dd4f8f89d546744772745b"}
(285,7221 milliseconds)
>>> Specific.statistic: {
"method": "Specific.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "fcee9f1a18cd4e2d87e4dce0a06f1c3a"
}
<<< Specific.statistic: {"result":{"available":0,"controllerName":"specific"},"error":null,"jtlrpc":"2.0","id":"fcee9f1a18cd4e2d87e4dce0a06f1c3a"}
(292,9719 milliseconds)
>>> Manufacturer.statistic: {
"method": "Manufacturer.statistic",
"params": {
"limit": 0,
"filters": {}
},
"jtlrpc": "2.0",
"id": "c91c732a84e54695a23f88575dc5154b"
}
<<< Manufacturer.statistic: {"result":{"available":0,"controllerName":"manufacturer"},"error":null,"jtlrpc":"2.0","id":"c91c732a84e54695a23f88575dc5154b"}
(297,4742 milliseconds)
JTL-Wawi: ModelGetters OK
>>> global_data.pull: {
"method": "global_data.pull",
"params": {
"limit": 50,
"filters": {}
},
"jtlrpc": "2.0",
"id": "cb8cdb53e1d44c96bcdd944cc1c06194"
}
<<< global_data.pull: {"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["1",0],"delimiterCent":"","delimiterThousand":"","factor":1,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"EUR","name":"Euro","nameHtml":"€"}],"customerGroups":[{"id":["1",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["1",0],"languageISO":"ger","name":"Shopkunden"}]},{"id":["2",0],"applyNetPrice":false,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["2",0],"languageISO":"ger","name":"H\u00e4ndler"}]}],"languages":[{"id":["1",0],"isDefault":true,"languageISO":"ger","nameEnglish":"Deutsch","nameGerman":"Deutsch"}],"measurementUnits":[{"id":["1",0],"code":"L","displayCode":"Liter","i18ns":[{"measurementUnitId":["1",0],"languageISO":"ger","name":"Liter"}]},{"id":["2",0],"code":"g","displayCode":"Gramm","i18ns":[{"measurementUnitId":["2",0],"languageISO":"ger","name":"Gramm"}]},{"id":["5",0],"code":"lfm","displayCode":"lfm","i18ns":[{"measurementUnitId":["5",0],"languageISO":"ger","name":"lfm"}]},{"id":["6",0],"code":"kg","displayCode":"Kilogramm","i18ns":[{"measurementUnitId":["6",0],"languageISO":"ger","name":"Kilogramm"}]},{"id":["8",0],"code":"Paket(e)","displayCode":"Paket(e)","i18ns":[{"measurementUnitId":["8",0],"languageISO":"ger","name":"Paket(e)"}]},{"id":["9",0],"code":"Stck.","displayCode":"St\u00fcck","i18ns":[{"measurementUnitId":["9",0],"languageISO":"ger","name":"St\u00fcck"}]},{"id":["10",0],"code":"m","displayCode":"Meter","i18ns":[{"measurementUnitId":["10",0],"languageISO":"ger","name":"Meter"}]},{"id":["11",0],"code":"mm","displayCode":"Millimeter","i18ns":[{"measurementUnitId":["11",0],"languageISO":"ger","name":"Millimeter"}]},{"id":["12",0],"code":"cm","displayCode":"Centimeter","i18ns":[{"measurementUnitId":["12",0],"languageISO":"ger","name":"Centimeter"}]},{"id":["13",0],"code":"dm","displayCode":"Dezimeter","i18ns":[{"measurementUnitId":["13",0],"languageISO":"ger","name":"Dezimeter"}]},{"id":["14",0],"code":"[in_i]","displayCode":"Zoll","i18ns":[{"measurementUnitId":["14",0],"languageISO":"ger","name":"Zoll"}]},{"id":["15",0],"code":"km","displayCode":"Kilometer","i18ns":[{"measurementUnitId":["15",0],"languageISO":"ger","name":"Kilometer"}]},{"id":["16",0],"code":"mg","displayCode":"Milligramm","i18ns":[{"measurementUnitId":["16",0],"languageISO":"ger","name":"Milligramm"}]},{"id":["17",0],"code":"[lb_av]","displayCode":"Pfund","i18ns":[{"measurementUnitId":["17",0],"languageISO":"ger","name":"Pfund"}]},{"id":["18",0],"code":"t","displayCode":"Tonne","i18ns":[{"measurementUnitId":["18",0],"languageISO":"ger","name":"Tonne"}]},{"id":["19",0],"code":"m2","displayCode":"Quadratmeter","i18ns":[{"measurementUnitId":["19",0],"languageISO":"ger","name":"Quadratmeter"}]},{"id":["20",0],"code":"mm2","displayCode":"Quadratmillimeter","i18ns":[{"measurementUnitId":["20",0],"languageISO":"ger","name":"Quadratmillimeter"}]},{"id":["21",0],"code":"cm2","displayCode":"Quadratcentimeter","i18ns":[{"measurementUnitId":["21",0],"languageISO":"ger","name":"Quadratcentimeter"}]},{"id":["22",0],"code":"mL","displayCode":"Milliliter","i18ns":[{"measurementUnitId":["22",0],"languageISO":"ger","name":"Milliliter"}]},{"id":["23",0],"code":"dL","displayCode":"Deziliter","i18ns":[{"measurementUnitId":["23",0],"languageISO":"ger","name":"Deziliter"}]},{"id":["24",0],"code":"cL","displayCode":"Centiliter","i18ns":[{"measurementUnitId":["24",0],"languageISO":"ger","name":"Centiliter"}]},{"id":["25",0],"code":"m3","displayCode":"Kubikmeter","i18ns":[{"measurementUnitId":["25",0],"languageISO":"ger","name":"Kubikmeter"}]},{"id":["26",0],"code":"cm3","displayCode":"Kubikcentimeter","i18ns":[{"measurementUnitId":["26",0],"languageISO":"ger","name":"Kubikcentimeter"}]}],"productTypes":[],"shippingClasses":[],"shippingMethods":[{"id":["9",0],"name":"Standard Versand"}],"taxRates":[{"id":["1",0],"rate":19},{"id":["4",0],"rate":7}],"units":[{"id":["1",0],"i18ns":[{"unitId":["1",0],"languageISO":"ger","name":""}]},{"id":["2",0],"i18ns":[{"unitId":["2",0],"languageISO":"ger","name":""}]},{"id":["3",0],"i18ns":[{"unitId":["3",0],"languageISO":"ger","name":""}]},{"id":["4",0],"i18ns":[{"unitId":["4",0],"languageISO":"ger","name":""}]},{"id":["5",0],"i18ns":[{"unitId":["5",0],"languageISO":"ger","name":""}]},{"id":["6",0],"i18ns":[{"unitId":["6",0],"languageISO":"ger","name":""}]}],"warehouses":[]}],"error":null,"jtlrpc":"2.0","id":"cb8cdb53e1d44c96bcdd944cc1c06194"}
(350,6575 milliseconds)
JTL-Wawi: End sync
Wäre prima wenn mir jemand einen Hinweis geben könnte.
Danke!
Gruß