Neu UPDATE Fehler von 1.5.36.2 auf 1.5.51.1

  • JTL-Connect 2022: Ihr habt noch kein Ticket? Jetzt schnell sichern! Die PreConnect ist bereits ausgebucht, auch für die After-Show-Party auf der Ocean Diva sind nur noch wenige Plätze verfügbar! HIER geht es zum Ticketverkauf

  • Das Stable Release von JTL-Wawi 1.6 ist startklar: HIER gehts zum Forenbeitrag

andreasscharf

Neues Mitglied
22. November 2021
1
0
Hallo JTL Team und Forenmitglieder.
ich versuche gerade bei mir ein UPDATE von JTL Wawi 1.5.36.2 auf Version 1.5.51.1 zu installieren sobald ich die Datenbank aktualisieren möchte bekomme folgenden Fehler

1637587717354.png

Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: 02:20:37 Fehler in der Version 1.5.47.0 beim Befehl:
==============================================
DECLARE @Reservierung TYPE_spReservierungAktualisieren;
INSERT INTO @Reservierung ( kBestellPos )
SELECT tbestellpos.kBestellPos
FROM dbo.tbestellpos
JOIN dbo.tBestellung ON tBestellung.kBestellung = tbestellpos.tBestellung_kBestellung
WHERE tBestellung.nKomplettAusgeliefert = 0;

EXEC dbo.spReservierungAktualisieren @Positionen = @Reservierung;
==============================================
Message: Die datediff-Funktion hat zu einem Überlauf geführt. Die Anzahl von datepart-Werten, die zwei Datums-/Uhrzeitinstanzen trennen, ist zu groß. Verwenden Sie eine datediff-Funktion mit einem weniger präzisen datepart-Wert.
LineNumber: 91
Procedure: dbo.spReservierungAktualisieren


2021-11-22T14:20:34 DEBUG - CREATE TRIGGER [dbo].[tgr_tKategorieShop_INSUP]
ON [dbo].[tKategorieShop]
AFTER INSERT, UPDATE
AS
SET NOCOUNT ON;
SET ANSI_NULLS, ANSI_NULL_DFLT_ON, ANSI_PADDING, CONCAT_NULL_YIELDS_NULL, XACT_ABORT ON;
BEGIN TRY
IF NOT EXISTS (SELECT 1 FROM Inserted) RETURN;
IF TRIGGER_NESTLEVEL(@@PROCID) > 1 RETURN;

IF (OBJECT_ID('tempdb..#tgrtKategorieShopInsup') IS NOT NULL)
BEGIN
DROP TABLE #tgrtKategorieShopInsup;
END

CREATE TABLE #tgrtKategorieShopInsup
(
kKategorie INT NOT NULL,
kShop INT NOT NULL,
nInetUpdateBlock BIT NOT NULL,
nInet BIT NOT NULL,
nInetY BIT NOT NULL,
nInserted BIT NOT NULL
);

INSERT INTO #tgrtKategorieShopInsup (kKategorie, kShop, nInetUpdateBlock, nInet, nInetY, nInserted)
SELECT
Inserted.kKategorie,
Inserted.kShop,
CASE WHEN EXISTS (SELECT Inserted.cInet EXCEPT SELECT Deleted.cInet)
AND Inserted.cInet = 'Y' THEN 1 ELSE 0 END AS nInetUpdateBlock,
CASE WHEN EXISTS (SELECT Inserted.cInet EXCEPT SELECT Deleted.cInet) THEN 1 ELSE 0 END AS nInet,
CASE WHEN Inserted.cInet = 'Y' THEN 1 ELSE 0 END AS nInetY,
CASE WHEN Deleted.kKategorie IS NULL THEN 1 ELSE 0 END AS nInserted
FROM Inserted
FULL OUTER JOIN Deleted ON Deleted.kKategorie = Inserted.kKategorie
AND Deleted.kShop = Inserted.kShop;

IF (UPDATE(cInet))
BEGIN
IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInetUpdateBlock = 1)
BEGIN
UPDATE dbo.tKategoriebildPlattform
SET tKategoriebildPlattform.nInet = 1
FROM dbo.tKategoriebildPlattform
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kKategorie = tKategoriebildPlattform.kKategorie
AND #tgrtKategorieShopInsup.kShop = tKategoriebildPlattform.kShop
WHERE tKategoriebildPlattform.nInet = 0
AND #tgrtKategorieShopInsup.nInetUpdateBlock = 1;
END

IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInet = 1)
BEGIN
UPDATE dbo.tKategorieShop
SET dbo.tKategorieShop.nInBearbeitung = 0
FROM dbo.tKategorieShop
JOIN #tgrtKategorieShopInsup ON dbo.tKategorieShop.kKategorie = #tgrtKategorieShopInsup.kKategorie
AND dbo.tKategorieShop.kShop = #tgrtKategorieShopInsup.kShop
AND #tgrtKategorieShopInsup.nInet = 1;
END

IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInetY = 1)
BEGIN
UPDATE dbo.tArtikelShop
SET tArtikelShop.nAktion = tArtikelShop.nAktion | 1,
tArtikelShop.cInet = 'Y',
tArtikelShop.nInBearbeitung = 0
FROM dbo.tArtikelShop
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kShop = tArtikelShop.kShop
JOIN dbo.tkategorieartikel ON tkategorieartikel.kArtikel = tArtikelShop.kArtikel
AND tkategorieartikel.kKategorie = #tgrtKategorieShopInsup.kKategorie
WHERE #tgrtKategorieShopInsup.nInetY = 1
AND #tgrtKategorieShopInsup.nInserted = 1
AND (tArtikelShop.cInet = 'N'
OR tArtikelShop.nAktion IN (0,2,4,6,8)
OR tArtikelShop.nInBearbeitung = 1);

UPDATE Sync.tEntityTracking
SET tEntityTracking.dLastModified = GETDATE()
FROM Sync.tEntityTracking
JOIN dbo.tkategorieartikel ON tkategorieartikel.kArtikel = tEntityTracking.kEntityId
AND tEntityTracking.nEntityType = 1
AND tEntityTracking.nSyncType = 4
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kKategorie = tkategorieartikel.kKategorie
WHERE #tgrtKategorieShopInsup.nInetY = 1;
END
END

IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInserted = 1)
BEGIN
-- Connector
--
-- Bilder vollständig zu Webshop wenden, wenn Änderungen vorgenommen wurden
--
UPDATE dbo.tKategoriebildPlattform
SET tKategoriebildPlattform.nInet = 1
FROM dbo.tKategoriebildPlattform
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kKategorie = tKategoriebildPlattform.kKategorie
AND #tgrtKategorieShopInsup.kShop = tKategoriebildPlattform.kShop
WHERE tKategoriebildPlattform.nInet = 0
AND #tgrtKategorieShopInsup.nInserted = 1;

--
-- Evtl. bestehenden Löscheinträge in tQueue entfernen
--
DELETE dbo.tQueue
FROM dbo.tQueue
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kShop = tQueue.kShop
AND #tgrtKategorieShopInsup.kKategorie = tQueue.kWert
WHERE tQueue.cName = 'tkategorie'
AND tQueue.nAction = 2
AND #tgrtKategorieShopInsup.nInserted = 1;

--
-- POS
--
IF(OBJECT_ID('tempdb..#tgr_tKategorieShop_Sync') IS NOT NULL)
BEGIN
DROP TABLE #tgr_tKategorieShop_Sync;
END

CREATE TABLE #tgr_tKategorieShop_Sync
(
kKategorie INT,
kShop INT,
nSyncType TINYINT,
kEntityId INT,
);

INSERT INTO #tgr_tKategorieShop_Sync (kKategorie, kShop, nSyncType, kEntityId)
SELECT
#tgrtKategorieShopInsup.kKategorie,
#tgrtKategorieShopInsup.kShop,
tShop.nTyp,
tEntityPlatform.kEntityId
FROM #tgrtKategorieShopInsup
JOIN dbo.tShop ON tShop.kShop = #tgrtKategorieShopInsup.kShop
LEFT JOIN Sync.tEntityPlatform ON tEntityPlatform.kShop = #tgrtKategorieShopInsup.kShop
AND tEntityPlatform.kEntityId = #tgrtKategorieShopInsup.kKategorie
AND tEntityPlatform.nEntityType = 2
WHERE tShop.nTyp NOT IN (2, 3)
AND #tgrtKategorieShopInsup.nInserted = 1
GROUP BY #tgrtKategorieShopInsup.kKategorie,
#tgrtKategorieShopInsup.kShop,
tShop.nTyp,
tEntityPlatform.kEntityId;

IF EXISTS (SELECT 1 FROM #tgr_tKategorieShop_Sync WHERE #tgr_tKategorieShop_Sync.kEntityId IS NOT NULL)
BEGIN
UPDATE Sync.tEntityPlatform
SET tEntityPlatform.dActive = GETDATE(),
tEntityPlatform.dInactive = NULL
FROM Sync.tEntityPlatform
JOIN #tgr_tKategorieShop_Sync ON #tgr_tKategorieShop_Sync.kEntityId = tEntityPlatform.kEntityId
AND #tgr_tKategorieShop_Sync.kShop = tEntityPlatform.kShop
AND tEntityPlatform.nEntityType = 2;
END

IF EXISTS (SELECT 1 FROM #tgr_tKategorieShop_Sync WHERE #tgr_tKategorieShop_Sync.kEntityId IS NULL)
BEGIN
INSERT INTO Sync.tEntityPlatform (kEntityId, nEntityType, kShop, dActive, dInactive)
SELECT
#tgr_tKategorieShop_Sync.kKategorie AS kEntityId,
2 AS nEntityType,
#tgr_tKategorieShop_Sync.kShop AS kShop,
GETDATE() AS dActive,
NULL AS dInactive
FROM #tgr_tKategorieShop_Sync
WHERE #tgr_tKategorieShop_Sync.kEntityId IS NULL;
END

IF EXISTS (SELECT 1 FROM #tgr_tKategorieShop_Sync WHERE #tgr_tKategorieShop_Sync.kEntityId IS NULL)
BEGIN
INSERT INTO Sync.tEntityTracking (kEntityId, nEntityType, nSyncType, dCreated, dLastModified)
SELECT
#tgr_tKategorieShop_Sync.kKategorie AS kEntityId,
2 AS nEntityType,
#tgr_tKategorieShop_Sync.nSyncType,
GETDATE() AS dCreated,
GETDATE() AS dLastModified
FROM #tgr_tKategorieShop_Sync
LEFT JOIN Sync.tEntityTracking ON tEntityTracking.kEntityId = #tgr_tKategorieShop_Sync.kKategorie
AND tEntityTracking.nEntityType = 2
AND tEntityTracking.nSyncType = #tgr_tKategorieShop_Sync.nSyncType
WHERE tEntityTracking.kEntityId IS NULL
GROUP BY #tgr_tKategorieShop_Sync.kKategorie,
#tgr_tKategorieShop_Sync.nSyncType;
END
END
END TRY
BEGIN CATCH
BEGIN TRY
DECLARE @DeadlockRetries TINYINT = 0;
EXEC dbo.spErrorHandler @DeadlockRetries = @DeadlockRetries OUTPUT;
END TRY
BEGIN CATCH
IF ERROR_NUMBER() <> 266 THROW;
END CATCH;
THROW;
END CATCH
2021-11-22T14:20:34 DEBUG - Dauer: 7ms
2021-11-22T14:20:34 DEBUG - UPDATE [dbo].[tVersion] SET [cVersion] = '1.5.47.0';
2021-11-22T14:20:34 DEBUG - Dauer: 7ms, AffectedRows: 1
2021-11-22T14:20:34 DEBUG - DELETE FROM dbo.tUserlayout WHERE tUserlayout.cName = 'ServicedeskTicketListFilterSettingsLayoutKey';
-- Alle Bestände einmal neu berechnen
TRUNCATE TABLE dbo.tlagerbestandProLagerLagerartikel;
TRUNCATE TABLE dbo.tlagerbestand;

DECLARE @Lagerartikel AS TYPE_spUpdateLagerbestandProLager;
INSERT INTO @Lagerartikel ( kArtikel ,
kWarenlager )
SELECT tArtikel.kArtikel, tWarenLager.kWarenLager
FROM dbo.tArtikel
CROSS JOIN dbo.tWarenlager
WHERE tArtikel.kStueckliste = 0;

EXEC dbo.spUpdateLagerbestandProLager @Artikel = @Lagerartikel;

DECLARE @Artikel AS TYPE_spUpdateLagerbestand;
INSERT INTO @Artikel ( kArtikel )
SELECT tArtikel.kArtikel
FROM dbo.tArtikel;

EXEC dbo.spUpdateLagerbestand @Artikel = @Artikel;

-- tDbErrorlog bereinigen
TRUNCATE TABLE dbo.tDbErrorlog;

INSERT INTO dbo.tAttribut (cBeschreibung, nIstMehrsprachig, nIstFreifeld, nSortierung, nBezugstyp, nAusgabeweg, nIstStandard, kFeldTyp, cGruppeName, nReadOnly, nAktivFuerArtikelOhneWarengruppe)
VALUES ('Preisabfrage', 0, 0, 9, 0, 0, 0, 4, ' JTL-POS', 0, 1);

INSERT INTO dbo.tAttributSprache (kAttribut, kSprache, cName)
VALUES (SCOPE_IDENTITY(), 0, 'Preisabfrage');
2021-11-22T14:20:36 DEBUG - Dauer: 1705ms, AffectedRows: 57213
2021-11-22T14:20:36 DEBUG - INSERT INTO dbo.tAttribut (cBeschreibung, nIstMehrsprachig, nIstFreifeld, nSortierung, nBezugstyp, nAusgabeweg, nIstStandard, kFeldTyp, cGruppeName, nReadOnly, nAktivFuerArtikelOhneWarengruppe)
VALUES ('Mengenabfrage', 0, 0, 28, 0, 0, 0, 4, 'JTL-POS', 0, 1);

INSERT INTO dbo.tAttributSprache (kAttribut, kSprache, cName)
VALUES (SCOPE_IDENTITY(), 0 , 'Mengenabfrage');
2021-11-22T14:20:36 DEBUG - Dauer: 15ms, AffectedRows: 2
2021-11-22T14:20:36 DEBUG - --START AMA Lister

SET IDENTITY_INSERT dbo.pf_amazon_group OFF

INSERT INTO dbo.pf_amazon_group
(cName, kPlattform, nAktiv)
SELECT DISTINCT
cName, kPlattform, nAktiv
FROM (
VALUES
('AutoAccessory_brakerotor', 51, 1),
('AutoAccessory_cargonet', 51, 1),
('AutoAccessory_cargostrap', 51, 1),
('AutoAccessory_engineairfilter', 51, 1),
('AutoAccessory_enginewaterpump', 51, 1),
('AutoAccessory_fuelfilter', 51, 1),
('AutoAccessory_fuelpump', 51, 1),
('AutoAccessory_jumpstarter', 51, 1),
('AutoAccessory_licenseplateattachment', 51, 1),
('AutoAccessory_lightmotorvehicle', 51, 1),
('AutoAccessory_oilfilter', 51, 1),
('AutoAccessory_sparkplug', 51, 1),
('AutoAccessory_steeringwheel', 51, 1),
('AutoAccessory_steeringwheelcover', 51, 1),
('AutoAccessory_tirevalvestemcap', 51, 1),
('AutoAccessory_towhitch', 51, 1),
('AutoAccessory_trailerhitchcover', 51, 1),
('AutoAccessory_transportrack', 51, 1),
('AutoAccessory_unmannedaerialvehicle', 51, 1),
('AutoAccessory_vehicleaccentlight', 51, 1),
('AutoAccessory_vehiclebrakepad', 51, 1),
('AutoAccessory_vehiclebumper', 51, 1),
('AutoAccessory_vehiclecover', 51, 1),
('AutoAccessory_vehiclehorn', 51, 1),
('AutoAccessory_vehicleinteriorshade', 51, 1),
('AutoAccessory_vehiclelightassembly', 51, 1),
('AutoAccessory_vehiclelightbulb', 51, 1),
('AutoAccessory_vehiclemat', 51, 1),
('AutoAccessory_vehiclemirror', 51, 1),
('AutoAccessory_vehiclerail', 51, 1),
('AutoAccessory_vehiclescantool', 51, 1),
('AutoAccessory_vehicleseatcover', 51, 1),
('AutoAccessory_vehiclewrap', 51, 1),
('AutoAccessory_wiperblade', 51, 1),
('Beauty_bodydeodorant', 51, 1),
('Beauty_conditioner', 51, 1),
('Beauty_cosmeticpowder', 51, 1),
('Beauty_eyebrowcolor', 51, 1),
('Beauty_eyelidcolor', 51, 1),
('Beauty_faceshapingmakeup', 51, 1),
('Beauty_falseeyelash', 51, 1),
('Beauty_falsenail', 51, 1),
('Beauty_hairband', 51, 1),
('Beauty_hairbrush', 51, 1),
('Beauty_haircleanerconditioner', 51, 1),
('Beauty_hairclip', 51, 1),
('Beauty_haircoloringagent', 51, 1),
('Beauty_haircomb', 51, 1),
('Beauty_hairextension', 51, 1),
('Beauty_hairremovalagent', 51, 1),
('Beauty_hairstylingagent', 51, 1),
('Beauty_hairtie', 51, 1),
('Beauty_lipbalm', 51, 1),
('Beauty_lipcolor', 51, 1),
('Beauty_manualshavingrazor', 51, 1),
('Beauty_mascara', 51, 1),
('Beauty_nailpolish', 51, 1),
('Beauty_personalfragrance', 51, 1),
('Beauty_razorbladecartridge', 51, 1),
('Beauty_selftanner', 51, 1),
('Beauty_shampoo', 51, 1),
('Beauty_skincleaningagent', 51, 1),
('Beauty_skincleaningwipe', 51, 1),
('Beauty_skinexfoliant', 51, 1),
('Beauty_skinfoundationconcealer', 51, 1),
('Beauty_skinmoisturizer', 51, 1),
('Beauty_skintreatmentmask', 51, 1),
('Beauty_sunscreen', 51, 1),
('Beauty_temporarytattoo', 51, 1),
('Beauty_topicalhairregrowthtreatment', 51, 1),
('Beauty_wig', 51, 1),
('Clothing_apparelbelt', 51, 1),
('Clothing_apparelgloves', 51, 1),
('Clothing_apron', 51, 1),
('Clothing_armsleeve', 51, 1),
('Clothing_backpack', 51, 1),
('Clothing_choli', 51, 1),
('Clothing_coat', 51, 1),
('Clothing_corset', 51, 1),
('Clothing_earmuff', 51, 1),
('Clothing_foodbib', 51, 1),
('Clothing_keychain', 51, 1),
('Clothing_kurta', 51, 1),
('Clothing_lehengacholiset', 51, 1),
('Clothing_leotard', 51, 1),
('Clothing_necktie', 51, 1),
('Clothing_nightgownnightshirt', 51, 1),
('Clothing_overalls', 51, 1),
('Clothing_pajamas', 51, 1),
('Clothing_protectiveglove', 51, 1),
('Clothing_robe', 51, 1),
('Clothing_safetyglasses', 51, 1),
('Clothing_salwarsuitset', 51, 1),
('Clothing_saree', 51, 1),
('Clothing_scarf', 51, 1),
('Clothing_shoelace', 51, 1),
('Clothing_socks', 51, 1),
('Clothing_suspender', 51, 1),
('Clothing_sweatshirt', 51, 1),
('Clothing_tights', 51, 1),
('Clothing_totebag', 51, 1),
('Clothing_tracksuit', 51, 1),
('Clothing_tunic', 51, 1),
('Clothing_undergarmentslip', 51, 1),
('Clothing_underpants', 51, 1),
('Clothing_vest', 51, 1),
('Clothing_waistcincher', 51, 1),
('Computers_computerchassis', 51, 1),
('Computers_flashdrive', 51, 1),
('Computers_graphictablet', 51, 1),
('Computers_inputmouse', 51, 1),
('Computers_inputpen', 51, 1),
('Computers_multiporthub', 51, 1),
('Computers_opticaldiscdrive', 51, 1),
('ConsumerElectronics_3dprinter', 51, 1),
('ConsumerElectronics_avreceiver', 51, 1),
('ConsumerElectronics_banner', 51, 1),
('ConsumerElectronics_blankbook', 51, 1),
('ConsumerElectronics_calendar', 51, 1),
('ConsumerElectronics_cellphoneholster', 51, 1),
('ConsumerElectronics_cellularphonecase', 51, 1),
('ConsumerElectronics_chargingadapter', 51, 1),
('ConsumerElectronics_DipSwitch', 51, 1),
('ConsumerElectronics_electronicadapter', 51, 1),
('ConsumerElectronics_electronicbookreader', 51, 1),
('ConsumerElectronics_electronicdevicedockingstation', 51, 1),
('ConsumerElectronics_electronicdeviceskin', 51, 1),
('ConsumerElectronics_flatscreendisplaymount', 51, 1),
('ConsumerElectronics_greetingcard', 51, 1),
('ConsumerElectronics_landlinephone', 51, 1),
('ConsumerElectronics_microphone', 51, 1),
('ConsumerElectronics_MotionActuatedSwitch', 51, 1),
('ConsumerElectronics_mousepad', 51, 1),
('ConsumerElectronics_networkinterfacecontrolleradapter', 51, 1),
('ConsumerElectronics_onboardcamera', 51, 1),
('ConsumerElectronics_planner', 51, 1),
('ConsumerElectronics_portableelectronicdevicestand', 51, 1),
('ConsumerElectronics_powerconverter', 51, 1),
('ConsumerElectronics_powercord', 51, 1),
('ConsumerElectronics_powerstrip', 51, 1),
('ConsumerElectronics_powersupply', 51, 1),
('ConsumerElectronics_screenprotector', 51, 1),
('ConsumerElectronics_signage', 51, 1),
('ConsumerElectronics_standalonestreamingmediaplayer', 51, 1),
('ConsumerElectronics_ToggleSwitch', 51, 1),
('ConsumerElectronics_turntable', 51, 1),
('ConsumerElectronics_vehiclesafetycamera', 51, 1),
('ConsumerElectronics_videodiscplayer', 51, 1),
('ConsumerElectronics_virtualrealityheadset', 51, 1),
('Eyewear_correctiveeyeglasses', 51, 1),
('Eyewear_eyeglassframe', 51, 1),
('Eyewear_sunglasses', 51, 1),
('FoodAndBeverages_bakingmix', 51, 1),
('FoodAndBeverages_bread', 51, 1),
('FoodAndBeverages_breakfastcereal', 51, 1),
('FoodAndBeverages_cake', 51, 1),
('FoodAndBeverages_candy', 51, 1),
('FoodAndBeverages_cereal', 51, 1),
('FoodAndBeverages_chewinggum', 51, 1),
('FoodAndBeverages_chocolatecandy', 51, 1),
('FoodAndBeverages_coffee', 51, 1),
('FoodAndBeverages_condiment', 51, 1),
('FoodAndBeverages_cookie', 51, 1),
('FoodAndBeverages_cracker', 51, 1),
('FoodAndBeverages_culinarysalt', 51, 1),
('FoodAndBeverages_dairybasedbutter', 51, 1),
('FoodAndBeverages_dairybasedcheese', 51, 1),
('FoodAndBeverages_dairybasedcream', 51, 1),
('FoodAndBeverages_dairybaseddrink', 51, 1),
('FoodAndBeverages_dairybasedicecream', 51, 1),
('FoodAndBeverages_drinkflavored', 51, 1),
('FoodAndBeverages_edibleoilanimal', 51, 1),
('FoodAndBeverages_edibleoilvegetable', 51, 1),
('FoodAndBeverages_fish', 51, 1),
('FoodAndBeverages_flavoreddrinkconcentrate', 51, 1),
('FoodAndBeverages_flour', 51, 1),
('FoodAndBeverages_fruit', 51, 1),
('FoodAndBeverages_fruitsnack', 51, 1),
('FoodAndBeverages_herb', 51, 1),
('FoodAndBeverages_honey', 51, 1),
('FoodAndBeverages_jerky', 51, 1),
('FoodAndBeverages_juiceandjuicedrink', 51, 1),
('FoodAndBeverages_leaveningagent', 51, 1),
('FoodAndBeverages_legume', 51, 1),
('FoodAndBeverages_mealreplacementbeverage', 51, 1),
('FoodAndBeverages_meat', 51, 1),
('FoodAndBeverages_milksubstitute', 51, 1),
('FoodAndBeverages_nondairycream', 51, 1),
('FoodAndBeverages_noodle', 51, 1),
('FoodAndBeverages_nutandseed', 51, 1),
('FoodAndBeverages_nutbutter', 51, 1),
('FoodAndBeverages_packagedsoupandstew', 51, 1),
('FoodAndBeverages_pastry', 51, 1),
('FoodAndBeverages_popcorn', 51, 1),
('FoodAndBeverages_poultry', 51, 1),
('FoodAndBeverages_pretzel', 51, 1),
('FoodAndBeverages_proteindrink', 51, 1),
('FoodAndBeverages_ricemix', 51, 1),
('FoodAndBeverages_saladdressing', 51, 1),
('FoodAndBeverages_sauce', 51, 1),
('FoodAndBeverages_seafood', 51, 1),
('FoodAndBeverages_shellfish', 51, 1),
('FoodAndBeverages_snackchipandcrisp', 51, 1),
('FoodAndBeverages_snackmix', 51, 1),
('FoodAndBeverages_sugar', 51, 1),
('FoodAndBeverages_sugarcandy', 51, 1),
('FoodAndBeverages_sugarsubstitute', 51, 1),
('FoodAndBeverages_tea', 51, 1),
('FoodAndBeverages_thickeningagent', 51, 1),
('FoodAndBeverages_vegetable', 51, 1),
('FoodAndBeverages_vinegar', 51, 1),
('FoodAndBeverages_water', 51, 1),
('FoodServiceAndJanSan_trashcan', 51, 1),
('Health_astringentsubstance', 51, 1),
('Health_bathwateradditive', 51, 1),
('Health_bloodpressuremonitor', 51, 1),
('Health_bodylubricant', 51, 1),
('Health_condom', 51, 1),
('Health_dentalfloss', 51, 1),
('Health_earplug', 51, 1),
('Health_electricshaver', 51, 1),
('Health_essentialoil', 51, 1),
('Health_firstaidkit', 51, 1),
('Health_hairdryer', 51, 1),
('Health_hairiron', 51, 1),
('Health_herbalsupplement', 51, 1),
('Health_incontinenceprotector', 51, 1),
('Health_insectrepellent', 51, 1),
('Health_kneepad', 51, 1),
('Health_massager', 51, 1),
('Health_massagestick', 51, 1),
('Health_medicalteststrip', 51, 1),
('Health_medication', 51, 1),
('Health_menstrualcup', 51, 1),
('Health_mineralsupplement', 51, 1),
('Health_mouthwash', 51, 1),
('Health_muscleroller', 51, 1),
('Health_nutritionalsupplement', 51, 1),
('Health_oralirrigator', 51, 1),
('Health_orthopedicbrace', 51, 1),
('Health_personalpilldispenser', 51, 1),
('Health_proteinsupplementpowder', 51, 1),
('Health_sanitarynapkin', 51, 1),
('Health_shoeinsert', 51, 1),
('Health_sleepmask', 51, 1),
('Health_toothbrush', 51, 1),
('Health_toothbrushhead', 51, 1),
('Health_toothcleaningagent', 51, 1),
('Health_toothwhitener', 51, 1),
('Health_vitamin', 51, 1),
('Health_wounddressing', 51, 1),
('Home_airmattress', 51, 1),
('Home_bedskirt', 51, 1),
('Home_bodypositioner', 51, 1),
('Home_bottlerack', 51, 1),
('Home_broom', 51, 1),
('Home_coffeemaker', 51, 1),
('Home_crib', 51, 1),
('Home_deepfryer', 51, 1),
('Home_electricwaterboiler', 51, 1),
('Home_fooddehydrator', 51, 1),
('Home_hammock', 51, 1),
('Home_incense', 51, 1),
('Home_mattresscover', 51, 1),
('Home_pillowcase', 51, 1),
('Home_portablestove', 51, 1),
('Home_pressurecooker', 51, 1),
('Home_roastingpan', 51, 1),
('Home_rubberstamp', 51, 1),
('Home_rugpad', 51, 1),
('Home_sculpture', 51, 1),
('Home_sewingmachine', 51, 1),
('Home_stoolseating', 51, 1),
('Home_timer', 51, 1),
('Home_toaster', 51, 1),
('Home_toiletpaperholder', 51, 1),
('Home_toothbrushholder', 51, 1),
('HomeImprovement_aircompressor', 51, 1),
('HomeImprovement_areadeodorizer', 51, 1),
('HomeImprovement_ashtray', 51, 1),
('HomeImprovement_barbecuegrill', 51, 1),
('HomeImprovement_basket', 51, 1),
('HomeImprovement_bathtub', 51, 1),
('HomeImprovement_blowtorch', 51, 1),
('HomeImprovement_bottle', 51, 1),
('HomeImprovement_caddy', 51, 1),
('HomeImprovement_chainsaw', 51, 1),
('HomeImprovement_cleaningagent', 51, 1),
('HomeImprovement_clothesrack', 51, 1),
('HomeImprovement_cosmeticbrush', 51, 1),
('HomeImprovement_dishwasherdetergent', 51, 1),
('HomeImprovement_door', 51, 1),
('HomeImprovement_doorstop', 51, 1),
('HomeImprovement_drill', 51, 1),
('HomeImprovement_electricitygenerator', 51, 1),
('HomeImprovement_fastenerdrivebit', 51, 1),
('HomeImprovement_faucet', 51, 1),
('HomeImprovement_foodstoragebag', 51, 1),
('HomeImprovement_gassmokefirealarm', 51, 1),
('HomeImprovement_hangingrod', 51, 1),
('HomeImprovement_hardwareclampvise', 51, 1),
('HomeImprovement_hardwarehandle', 51, 1),
('HomeImprovement_hardwarehinge', 51, 1),
('HomeImprovement_hardwaretubing', 51, 1),
('HomeImprovement_hosepipefitting', 51, 1),
('HomeImprovement_jar', 51, 1),
('HomeImprovement_jewelrystorage', 51, 1),
('HomeImprovement_lampshade', 51, 1),
('HomeImprovement_laundrydetergent', 51, 1),
('HomeImprovement_laundryhamper', 51, 1),
('HomeImprovement_lock', 51, 1),
('HomeImprovement_multitool', 51, 1),
('HomeImprovement_pliers', 51, 1),
('HomeImprovement_portabletoolbox', 51, 1),
('HomeImprovement_safe', 51, 1),
('HomeImprovement_sander', 51, 1),
('HomeImprovement_saw', 51, 1),
('HomeImprovement_scissors', 51, 1),
('HomeImprovement_screwdriver', 51, 1),
('HomeImprovement_screwgun', 51, 1),
('HomeImprovement_securitycamera', 51, 1),
('HomeImprovement_shippingbox', 51, 1),
('HomeImprovement_showerhead', 51, 1),
('HomeImprovement_sink', 51, 1),
('HomeImprovement_snackfoodbar', 51, 1),
('HomeImprovement_solderingiron', 51, 1),
('HomeImprovement_storagebag', 51, 1),
('HomeImprovement_storagebox', 51, 1),
('HomeImprovement_storagedrawer', 51, 1),
('HomeImprovement_storagehook', 51, 1),
('HomeImprovement_storagerack', 51, 1),
('HomeImprovement_tile', 51, 1),
('HomeImprovement_toilet', 51, 1),
('HomeImprovement_toiletseat', 51, 1),
('HomeImprovement_utilityknife', 51, 1),
('HomeImprovement_valve', 51, 1),
('HomeImprovement_wallpaper', 51, 1),
('HomeImprovement_Washer', 51, 1),
('HomeImprovement_washerdryercombination', 51, 1),
('HomeImprovement_wastebag', 51, 1),
('HomeImprovement_waterpump', 51, 1),
('HomeImprovement_wrench', 51, 1),
('Industrial_adhesivetapes', 51, 1),
('Industrial_agriculturalsupplies', 51, 1),
('Industrial_bondingadhesives', 51, 1),
('Industrial_drillbits', 51, 1),
('Industrial_electromechanicalgauge', 51, 1),
('Industrial_ElectronicCable', 51, 1),
('Industrial_ElectronicComponentFan', 51, 1),
('Industrial_ElectronicComponentTerminal', 51, 1),
('Industrial_electronicswitch', 51, 1),
('Industrial_ElectronicWire', 51, 1),
('Industrial_endmills', 51, 1),
('Industrial_fertilizer', 51, 1),
('Industrial_horsetackequipment', 51, 1),
('Industrial_irrigationequipment', 51, 1),
('Industrial_livestockhousing', 51, 1),
('Industrial_Relay', 51, 1),
('Industrial_sawblade', 51, 1),
('Industrial_TerminalBlock', 51, 1),
('Industrial_thermometer', 51, 1),
('Industrial_weatherstation', 51, 1),
('Industrial_weighscale', 51, 1),
('Jewelry_apparelpin', 51, 1),
('Jewelry_charm', 51, 1),
('Jewelry_earring', 51, 1),
('Jewelry_jewelryset', 51, 1),
('Jewelry_piercingjewelry', 51, 1),
('Jewelry_ring', 51, 1),
('Jewelry_watchband', 51, 1),
('Kitchen_bakingcup', 51, 1),
('Kitchen_bakingpan', 51, 1),
('Kitchen_bakingpaper', 51, 1),
('Kitchen_bottleopener', 51, 1),
('Kitchen_bottlestopper', 51, 1),
('Kitchen_canopener', 51, 1),
('Kitchen_Casseroles', 51, 1),
('Kitchen_cocktailshaker', 51, 1),
('Kitchen_coffeefilter', 51, 1),
('Kitchen_cookiecutter', 51, 1),
('Kitchen_cookingpot', 51, 1),
('Kitchen_corepitremover', 51, 1),
('Kitchen_cuttingboard', 51, 1),
('Kitchen_drinkingcup', 51, 1),
('Kitchen_drinkingstraw', 51, 1),
('Kitchen_DutchOvens', 51, 1),
('Kitchen_flatware', 51, 1),
('Kitchen_foodpreparationmold', 51, 1),
('Kitchen_foodshaker', 51, 1),
('Kitchen_foodslicer', 51, 1),
('Kitchen_garlicpress', 51, 1),
('Kitchen_icecubetray', 51, 1),
('Kitchen_kitchenknife', 51, 1),
('Kitchen_knife', 51, 1),
('Kitchen_knifeblockset', 51, 1),
('Kitchen_knifesharpener', 51, 1),
('Kitchen_mealholder', 51, 1),
('Kitchen_measuringcup', 51, 1),
('Kitchen_pastamaker', 51, 1),
('Kitchen_pipingtip', 51, 1),
('Kitchen_pitcher', 51, 1),
('Kitchen_potablewaterfilter', 51, 1),
('Kitchen_RiceCookers', 51, 1),
('Kitchen_rollingpin', 51, 1),
('Kitchen_seasoningmill', 51, 1),
('Kitchen_sheetpan', 51, 1),
('Kitchen_teainfuser', 51, 1),
('Kitchen_teapot', 51, 1),
('Kitchen_thermos', 51, 1),
('Kitchen_wheelcutter', 51, 1),
('LabSupplies_Flask', 51, 1),
('LabSupplies_waterpurificationunit', 51, 1),
('LargeAppliances_hvacairfilter', 51, 1),
('LargeAppliances_vacuumfilter', 51, 1),
('LawnAndGarden_compostbin', 51, 1),
('LawnAndGarden_firepit', 51, 1),
('LawnAndGarden_freestandingshelter', 51, 1),
('LawnAndGarden_lawnmower', 51, 1),
('LawnAndGarden_leafblower', 51, 1),
('LawnAndGarden_metaldetector', 51, 1),
('LawnAndGarden_outbuilding', 51, 1),
('LawnAndGarden_pestcontroldevice', 51, 1),
('LawnAndGarden_plantseed', 51, 1),
('LawnAndGarden_pressurewasher', 51, 1),
('LawnAndGarden_shovelspade', 51, 1),
('LawnAndGarden_snowblower', 51, 1),
('LawnAndGarden_stringtrimmer', 51, 1),
('LawnAndGarden_wildlifefeeder', 51, 1),
('Lighting_candle', 51, 1),
('Lighting_lamp', 51, 1),
('Lighting_lightbulb', 51, 1),
('Lighting_lightfixture', 51, 1),
('Lighting_stringlight', 51, 1),
('Luggage_cosmeticcase', 51, 1),
('Luggage_duffelbag', 51, 1),
('Luggage_suitcase', 51, 1),
('Luggage_waistpack', 51, 1),
('MotoApparel_powersportsridinghelmet', 51, 1),
('MusicalInstruments_musicalinstruments', 51, 1),
('Office_badgeholder', 51, 1),
('Office_cardstock', 51, 1),
('Office_craftbead', 51, 1),
('Office_decorativeribbontrim', 51, 1),
('Office_disposablenapkin', 51, 1),
('Office_envelope', 51, 1),
('Office_fabricappliquepatch', 51, 1),
('Office_facialtissue', 51, 1),
('Office_filefolder', 51, 1),
('Office_glitter', 51, 1),
('Office_inkjetprinterink', 51, 1),
('Office_label', 51, 1),
('Office_markingpen', 51, 1),
('Office_papertowel', 51, 1),
('Office_pinboard', 51, 1),
('Office_printcopypaper', 51, 1),
('Office_sculptingmaterial', 51, 1),
('Office_selfsticknote', 51, 1),
('Office_stapler', 51, 1),
('Office_storagebinder', 51, 1),
('Office_templatestencil', 51, 1),
('Office_thermoplasticfilament', 51, 1),
('Office_toiletpaper', 51, 1),
('Office_writingboard', 51, 1),
('Office_writingpaper', 51, 1),
('Office_yarn', 51, 1),
('PetSupplies_animalcage', 51, 1),
('PetSupplies_animalcollar', 51, 1),
('PetSupplies_animalharness', 51, 1),
('PetSupplies_animallitter', 51, 1),
('PetSupplies_leash', 51, 1),
('PetSupplies_litterbox', 51, 1),
('PetSupplies_petbedmat', 51, 1),
('PetSupplies_petfeeder', 51, 1),
('PetSupplies_petpestcontrol', 51, 1),
('PetSupplies_pettoy', 51, 1),
('PetSupplies_vivarium', 51, 1),
('Shoes_slipper', 51, 1),
('SoftwareVideoGames_videogameconsole', 51, 1),
('SoftwareVideoGames_videogamecontroller', 51, 1),
('Sports_abdominalexerciser', 51, 1),
('Sports_aimingscopesight', 51, 1),
('Sports_airgun', 51, 1),
('Sports_airpump', 51, 1),
('Sports_barbell', 51, 1),
('Sports_basketballhoop', 51, 1),
('Sports_bicycletrainer', 51, 1),
('Sports_biometricmonitor', 51, 1),
('Sports_boxingglove', 51, 1),
('Sports_cyclingtire', 51, 1),
('Sports_exerciseband', 51, 1),
('Sports_exercisemat', 51, 1),
('Sports_fishinghook', 51, 1),
('Sports_fishingline', 51, 1),
('Sports_fishingreel', 51, 1),
('Sports_fitnessbench', 51, 1),
('Sports_golfclubbag', 51, 1),
('Sports_gunholster', 51, 1),
('Sports_icechest', 51, 1),
('Sports_jumprope', 51, 1),
('Sports_kickscooter', 51, 1),
('Sports_messkit', 51, 1),
('Sports_punchingbag', 51, 1),
('Sports_recreationball', 51, 1),
('Sports_rollerskate', 51, 1),
('Sports_rowingmachine', 51, 1),
('Sports_skateboard', 51, 1),
('Sports_sleepingbag', 51, 1),
('Sports_sleepingmat', 51, 1),
('Sports_snowboardboot', 51, 1),
('Sports_snowshoe', 51, 1),
('Sports_sportactivityglove', 51, 1),
('Sports_sportbinding', 51, 1),
('Sports_sporthelmet', 51, 1),
('Sports_sportmitt', 51, 1),
('Sports_sportracket', 51, 1),
('Sports_sporttablegame', 51, 1),
('Sports_sportwetsuit', 51, 1),
('Sports_stationarybicycle', 51, 1),
('Sports_sweatband', 51, 1),
('Sports_tent', 51, 1),
('Sports_trampoline', 51, 1),
('Sports_treadmill', 51, 1),
('Sports_utilityholsterpouch', 51, 1),
('Sports_walkingstick', 51, 1),
('Sports_waterflotationdevice', 51, 1),
('TiresAndWheels_vehicletire', 51, 1)
) as NewGroups(cName, kPlattform, nAktiv)
WHERE NOT EXISTS (
SELECT 1
FROM dbo.pf_amazon_group
WHERE pf_amazon_group.cName = NewGroups.cName
AND pf_amazon_group.kPlattform = NewGroups.kPlattform
)
2021-11-22T14:20:36 DEBUG - Dauer: 115ms, AffectedRows: 526
2021-11-22T14:20:36 DEBUG - --END AMA Lister

MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 0
WHERE AttributSprache.cName = 'jtl_voucher')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-11-22T14:20:36 DEBUG - Dauer: 41ms, AffectedRows: 1
2021-11-22T14:20:36 DEBUG - MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 1
WHERE AttributSprache.cName = 'jtl_voucher')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-11-22T14:20:36 DEBUG - Dauer: 60ms, AffectedRows: 0
2021-11-22T14:20:36 DEBUG - MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 0
WHERE AttributSprache.cName = 'jtl_voucher_flex')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-11-22T14:20:36 DEBUG - Dauer: 14ms, AffectedRows: 1
2021-11-22T14:20:36 DEBUG - MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 1
WHERE AttributSprache.cName = 'jtl_voucher_flex')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-11-22T14:20:36 DEBUG - Dauer: 4ms, AffectedRows: 0
2021-11-22T14:20:36 DEBUG - DECLARE @Reservierung TYPE_spReservierungAktualisieren;
INSERT INTO @Reservierung ( kBestellPos )
SELECT tbestellpos.kBestellPos
FROM dbo.tbestellpos
JOIN dbo.tBestellung ON tBestellung.kBestellung = tbestellpos.tBestellung_kBestellung
WHERE tBestellung.nKomplettAusgeliefert = 0;

EXEC dbo.spReservierungAktualisieren @Positionen = @Reservierung;
2021-11-22T14:20:37 DEBUG - Dauer: 460ms, AffectedRows: 26260
2021-11-22T14:20:37 DEBUG - SELECT * FROM tUpdateLog WHERE kUpdateLog > @kUpdateLog
kUpdateLog = 2
2021-11-22T14:20:37 DEBUG - Dauer: 0ms, (bis zum Reader)
2021-11-22T14:20:37 DEBUG - Dauer: 1ms, 0 Zeilen
2021-11-22T14:20:37 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2021-11-22T14:20:37 DEBUG - Dauer: 0ms, Result: local
Zeitstempel: 2021-11-22T14:21:52
Locale: German (Germany)
Locale: German (Germany)
Version: 1.5.51.1
Plattform: Wawi
WawiSeed: 5.1.13267.214301
Prozessname: JTL-Wawi
Physikalischer Speicher: 544821248 / Peak: 662855680
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:01:55,046875
CPU-Zeit (System): 0:00:10,796875
Page-Size (Sytem): 1953744 / Peak: 631566336
Page-Size: 482398208 / Peak: 631566336
Offene Handles: 1331
Database:
Build: 2111111225 df62843e8c13f04731af3522ab489d5256fb6c2c
 
Ähnliche Themen
Titel Forum Antworten Datum
Neu Update von 5.1.2 -> 5.1.3 Fehler Dateistruktur Installation / Updates von JTL-Shop 0
Neu Update von 5.1.2 auf 5.1.3 SQL Fehler Installation / Updates von JTL-Shop 9
Neu Problem / Fehler beim Update von JTL Connector 2.2.5.3 auf 2.13.0 (Shopware 5.5.10) Shopware-Connector 1
Neu Fehler beim heutigen Update von 1.6.38.1 auf 1.6.38.2 Installation von JTL-Wawi 1
Neu Update 5.1.1 --> 5.1.4: Fehler im Bestellvorgang "unknown tag 'getCountry'" (inc_billing_address_form.tpl) (NOVA) Installation / Updates von JTL-Shop 1
Neu JTL Shop Update 5.1.3 - Datenbank Fehler: 1062 Duplicate entry 'COUNTRY_VIEW' for key 'PRIMARY' Installation / Updates von JTL-Shop 6
Fehler bei Update: "SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined" Upgrade JTL-Shop4 auf JTL-Shop5 1
Neu JTL Wawi Update fehler nach Serverumzug JTL-Wawi - Fehler und Bugs 3
Fehler beim Update JTL-Wawi 1.6 0
Neu Probleme beim Update auf 1.6 - Datenbank Fehler? Ideen zur Lösung? JTL-Wawi 1.6 1
Neu Nach Update: Meldung Steuerklassen ohne Steuerschlüssel OSS User helfen Usern - Fragen zu JTL-Wawi 0
Neu JTL WAWI Update mit WoodmartCore JTL-Wawi - Fehler und Bugs 0
Neu Update auf aktuelle Version - keine Plusbuchung nur mit Scanner mehr möglich JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 0
Update von Version 1.5.31.0 auf 1.6.41.2 ungültiger Spaltenname JTL-Wawi 1.6 1
Neu FCC Update schlägt fehl JTL-POS - Fehler und Bugs 9
Neu Update Wawi 1.5... auf 1.6.41.2 Installation von JTL-Wawi 3
SQL-Abfrage funktioniert seit Update nicht mehr JTL-Wawi 1.6 7
Neu Darstellungsprobleme nach Update auf 5.1.4 JTL-Shop - Fehler und Bugs 2
Seit Update sind Artikel reserviert und können nicht im Packtisch versandt werden JTL-Wawi 1.6 2
Neu Update auf 1.6 FOREIGN KEY-Einschränkung Absturz Servicedesk (Beta) 0
Neu Lizenzproblem bei eigenem Nova Child nach Update auf 5.1.4 JTL-Shop - Fehler und Bugs 0
Neu Update 5.0 auf 5.1.4 Datenbank update funktioniert nicht Installation / Updates von JTL-Shop 1
Beantwortet nach Update von 1.55.5.2 zu 1.6.40.0 kein Scannen des "#Verpacken" mehr möglich JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 2
Neu Nach Shop Update (5.1.4) funzt die Theme Kompilierung nicht mehr. JTL-Shop - Fehler und Bugs 3
Neu 1.6 Update UmsatzsteuerID nicht mehr auf den Belegen User helfen Usern - Fragen zu JTL-Wawi 2
Seit Update auf Wawi 16 werden uns keine Variationen im Shop mehr angezeigt!!!! JTL-Wawi 1.6 16
Gelöst linke Seitenliste in Artikelübersicht verschwunden, einstellen nach Update JTL-Shop - Fehler und Bugs 1
Neu Generelle Update Reihenfolge Leitfaden erwünscht Installation / Updates von JTL-Shop 5
Beantwortet Update unter Windows Server 2012 R2 Installation von JTL-Wawi 5
Neu Nach Update auf 5.1.4: Modifizierte Datei Installation / Updates von JTL-Shop 3
Nach Update Shop4 auf Shop5 keine Neukunden Anmeldung möglich Upgrade JTL-Shop4 auf JTL-Shop5 1
Neu Fehlende Information in Positionstext nach update auf JTL Wawi 1.64 JTL-Wawi 1.6 4
Seit Update auf Worker 2.0 und WaWi 1.6 Fehlermeldungen JTL-Wawi 1.6 3
Issue angelegt Hinzufügen großer Artikelmengen per Touchscreen nach Update nicht mehr möglich [WAWI-62158] JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 3
Datenbank Update: Cannot load template-no template Upgrade JTL-Shop4 auf JTL-Shop5 1
Beantwortet Nach update von JTL Shop4 auf 5.1 Bilder von Vaterartikel werden nicht angezeigt Betrieb / Pflege von JTL-Shop 1
Neu Nach Update auf JTL Woocommerce Connector 1.37.1 Backend extrem langsam für Order-Quickview WooCommerce-Connector 0
Neu Update 1.6 Begrenzung der Zeichen bei Beschreibung umgehen User helfen Usern - Fragen zu JTL-Wawi 0
Bilder kleiner machen - Update von 1.5 auf 1.6 Datenbank SQL Express JTL-Wawi 1.6 6
Neu JTL Ameise Exportvorlage nach Update fehlerhaft JTL-Ameise - Fehler und Bugs 0
Neu Nach Update Linke Seitenleiste oben statt links JTL-Shop - Fehler und Bugs 1
Neu PP Checkout Error seit Update auf 1.04 Plugins für JTL-Shop 3
Neu Update der Datenbanken von 1.5.55.2 auf 1.6.40.0 schlägt fehl JTL-Wawi - Fehler und Bugs 2
Fällige Abonnements können seit Update auf Wawi 1.6.XX.X nicht mehr ausgelöst werden JTL-Wawi 1.6 2
Seit Update von 1.5.5.0 auf 1.6.39.0 funktioniert der Worker nicht mehr JTL-Wawi 1.6 2
Neu Bestand Variantenartikel nach Update 0 User helfen Usern - Fragen zu JTL-Wawi 4
Nach Update (Stunden später) keine Unterseiten mehr aufrufbar - nur Startseite Upgrade JTL-Shop4 auf JTL-Shop5 0
Neu Impressum-Update durch Plug-in JTL-Shop - Fehler und Bugs 4
Neu Nach Update auf 1.6 Artikel offline JTL-Wawi - Fehler und Bugs 4
Nach Update von 1.5 auf 1.6 Versandlabel merkwürdig trotz angepassten Einstellungen in JTL und DHL Geschäftskundenportal JTL-Wawi 1.6 10

Ähnliche Themen