brachte folgende Fehlermeldung... Die anderen Shop mit teilweise mit JTL teilweise andere Modified shop liefen durch.
ich weiß auch nicht wann der Fehler auftrat weil Bestellungen normal durchgingen wenn der Worker lief / läuft. Jetzt hatte ich auf den connector 3.5 upgedatet, weil es Probleme mit den Variationen gab und nach dem manuellen Abgleich kam das hier:
ich weiß auch nicht wann der Fehler auftrat weil Bestellungen normal durchgingen wenn der Worker lief / läuft. Jetzt hatte ich auf den connector 3.5 upgedatet, weil es Probleme mit den Variationen gab und nach dem manuellen Abgleich kam das hier:
Code:
Fehler:
Exception: phar:///www/htdocs/w01a5da0/lithoshop.eu/jtlconnector/index.php/vendor/jtl/connector/src/Core/Database/Mysql.php (327):Unknown column '3528_20' in 'where clause'
phar:///www/htdocs/w01a5da0/lithoshop.eu/jtlconnector/index.php/vendor/jtl/connector/src/Core/Database/Mysql.php (327):Unknown column '3528_20' in 'where clause'
Artikel-Senden-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.push: phar:///www/htdocs/w01a5da0/lithoshop.eu/jtlconnector/index.php/vendor/jtl/connector/src/Core/Database/Mysql.php (327):Unknown column '3528_20' in 'where clause'
phar:///www/htdocs/w01a5da0/lithoshop.eu/jtlconnector/index.php/vendor/jtl/connector/src/Core/Database/Mysql.php (327):Unknown column '3528_20' in 'where clause'
Response: {"result":[{"basePriceUnitId":["",0],"id":["1908",2040],"manufacturerId":["2",27],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",0],"unitId":["",0],"additionalHandlingTime":0,"asin":"","availableFrom":null,"basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":false,"considerVariationStock":false,"creationDate":null,"discountable":true,"ean":"","epid":"","hazardIdNumber":"","height":0,"isActive":false,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","manufacturer":null,"measurementQuantity":0,"measurementUnitCode":"","minBestBeforeDate":null,"minimumOrderQuantity":0,"minimumQuantity":0,"modified":null,"newReleaseDate":null,"nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":false,"productWeight":0,"purchasePrice":0,"recommendedRetailPrice":0,"serialNumber":"","shippingWeight":0,"sku":"","sort":0,"stockLevel":null,"supplierDeliveryTime":0,"supplierStockLevel":0,"taric":"","unNumber":"","upc":"","vat":0,"width":0,"attributes":[],"categories":[{"categoryId":["188",287],"id":["",0],"productId":["1908",2040]}],"checksums":[],"configGroups":[],"customerGroupPackagingQuantities":[],"fileDownloads":[],"i18ns":[{"productId":["1908",2040],"deliveryStatus":"","description":"","languageISO":"","measurementUnitName":"","metaDescription":"","metaKeywords":"","name":"","shortDescription":"","titleTag":"","unitName":"","urlPath":""}],"invisibilities":[],"mediaFiles":[],"partsLists":[],"prices":[{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]}],"specialPrices":[],"specifics":[],"varCombinations":[],"variations":[],"warehouseInfo":[]},null,null],"error":{"code":1054,"message":"phar:\/\/\/www\/htdocs\/w01a5da0\/lithoshop.eu\/jtlconnector\/index.php\/vendor\/jtl\/connector\/src\/Core\/Database\/Mysql.php (327):Unknown column '3528_20' in 'where clause'","data":null},"jtlrpc":"2.0","id":"ba952ab9f5f64bdb957c83580f8a7bb1"}
Exception bei product.push: phar:///www/htdocs/w01a5da0/lithoshop.eu/jtlconnector/index.php/vendor/jtl/connector/src/Core/Database/Mysql.php (327):Unknown column '3528_20' in 'where clause'
phar:///www/htdocs/w01a5da0/lithoshop.eu/jtlconnector/index.php/vendor/jtl/connector/src/Core/Database/Mysql.php (327):Unknown column '3528_20' in 'where clause'
Response: {"result":[{"basePriceUnitId":["",0],"id":["1908",2040],"manufacturerId":["2",27],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",0],"unitId":["",0],"additionalHandlingTime":0,"asin":"","availableFrom":null,"basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":false,"considerVariationStock":false,"creationDate":null,"discountable":true,"ean":"","epid":"","hazardIdNumber":"","height":0,"isActive":false,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","manufacturer":null,"measurementQuantity":0,"measurementUnitCode":"","minBestBeforeDate":null,"minimumOrderQuantity":0,"minimumQuantity":0,"modified":null,"newReleaseDate":null,"nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":false,"productWeight":0,"purchasePrice":0,"recommendedRetailPrice":0,"serialNumber":"","shippingWeight":0,"sku":"","sort":0,"stockLevel":null,"supplierDeliveryTime":0,"supplierStockLevel":0,"taric":"","unNumber":"","upc":"","vat":0,"width":0,"attributes":[],"categories":[{"categoryId":["188",287],"id":["",0],"productId":["1908",2040]}],"checksums":[],"configGroups":[],"customerGroupPackagingQuantities":[],"fileDownloads":[],"i18ns":[{"productId":["1908",2040],"deliveryStatus":"","description":"","languageISO":"","measurementUnitName":"","metaDescription":"","metaKeywords":"","name":"","shortDescription":"","titleTag":"","unitName":"","urlPath":""}],"invisibilities":[],"mediaFiles":[],"partsLists":[],"prices":[{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]},{"customerGroupId":["",0],"customerId":["",0],"id":["",0],"productId":["",0],"items":[]}],"specialPrices":[],"specifics":[],"varCombinations":[],"variations":[],"warehouseInfo":[]},null,null],"error":{"code":1054,"message":"phar:\/\/\/www\/htdocs\/w01a5da0\/lithoshop.eu\/jtlconnector\/index.php\/vendor\/jtl\/connector\/src\/Core\/Database\/Mysql.php (327):Unknown column '3528_20' in 'where clause'","data":null},"jtlrpc":"2.0","id":"1099c03569d94974a2a64c8a174610ee"}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.tghrCRWHefA(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.MK3rCQCuyAD(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.tghrCRWHefA(String , Object , Boolean , NetworkCredential )