Neu UPDATE Fehler von 1.5.36.2 auf 1.5.51.1

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 auf 5.11 Fehler Installation / Updates von JTL-Shop 3
Neu DB-Fehler beim Update von 1.5 auf 1.6: Foreign Key in tBestellung JTL-Wawi - Fehler und Bugs 0
Neu Fehler bei Update von 1.35 auf neueste Version JTL-Wawi - Fehler und Bugs 2
Neu Fehler bei Update auf 1.5.52 - Lizenzen danach in allen Mandanten gleich User helfen Usern - Fragen zu JTL-Wawi 0
Neu Nach Update auf JTL-Wawi 1.6.33.1 - Fehler beim Onlineshopabgleich JTL-Wawi - Fehler und Bugs 5
Neu Fehler Update 5.0.1 auf 5.0.4 Installation / Updates von JTL-Shop 1
Neu Update Fehler 1.6.33.1 - Collations JTL-Wawi - Fehler und Bugs 5
Neu Fehler bei Update 16.32.0 auf 1.6.32.1: Datenbank-Sortierungskonflikt JTL-Wawi - Fehler und Bugs 4
Fehler bei Update: "" is not a valid SemVer Upgrade JTL-Shop4 auf JTL-Shop5 0
Neu Update Fehler auf JTL-Wawi Open Beta 1.6.31.2 Installation von JTL-Wawi 18
Neu Update auf Open Beta Fehler Installation von JTL-Wawi 2
Neu Lagerwert nach Update ca. 50% höher User helfen Usern - Fragen zu JTL-Wawi 0
Neu SyncException: 3 Nach update von JTL Shop 4 auf 5 , KEINE ANBINDUNG mehr möglich. HILFE Onlineshop-Anbindung 6
Neu Update 1.6.33.1 nicht möglich JTL-Wawi - Fehler und Bugs 2
Neu Update von 1.5.52.0 auf 1.5.53.1 bleibt bei 100% stehen Installation von JTL-Wawi 7
Neu Nach Wawi 1.6.32.0 Update, neue Firma: Gelöscht vor Update 1.6 JTL-Wawi - Fehler und Bugs 2
Neu Probleme beim Update von Version 1.5.48.2 auf 1.5.53.1 Installation von JTL-Wawi 0
Neu Nach Update keine DB vorhanden bei Client User helfen Usern - Fragen zu JTL-Wawi 0
Shop Update von 4.xx auf 5.1.1 - Eine oder mehrere Linkgruppen nutzen keine eindeutigen Template-Namen: Gesetzliche Informationen Upgrade JTL-Shop4 auf JTL-Shop5 1
Neu Amazon Bestellungen werden nicht übernommen ( Sonderfall MARS-Batch / Update-CHECK-Konflikt) Amazon-Anbindung - Fehler und Bugs 14
Liefertermine werden nach Update nicht mehr angezeigt Upgrade JTL-Shop4 auf JTL-Shop5 0
Neu JTL WAWI Update 1.46x auf 1.48x Installation von JTL-Wawi 2
JTL Update nach Plugin aktivierung ist der admin bereich weiß Upgrade JTL-Shop4 auf JTL-Shop5 1
Neu Importierte Artikel nach Update nicht im Shop sichtbar User helfen Usern - Fragen zu JTL-Wawi 16
Neu Nach Update auf 5.1.1 - Productstream keine Möglichkeit Ware zum Warenkorb hinzufügen Allgemeine Fragen zu JTL-Shop 2
Problem Update 4 auf 5 Upgrade JTL-Shop4 auf JTL-Shop5 6
Neu Update von 5.0.3 auf 5.1.1 dbupdate beendet nicht richtig Installation / Updates von JTL-Shop 3
Nach Update und Datenbank-Abbild hochladen Shop unerreichbar Upgrade JTL-Shop4 auf JTL-Shop5 1
Neu Update 4x oder Neuinstallation 5x ? Installation / Updates von JTL-Shop 1
Neu Nach Update auf 1.5.52.0 funktioniert Rechnungsdruck nicht mehr JTL-Wawi - Fehler und Bugs 4
Neu Update PayPal Plugin 2.1.0 nicht möglich Plugins für JTL-Shop 0
Neu Nach Update auf 1.5.52.0 Wareneingang wegen "Chargen" nicht mehr möglich JTL-Wawi - Fehler und Bugs 1
Neu Nach Update JTL Worker läuft nicht mehr JTL-Wawi - Fehler und Bugs 2
Neu Fehlermeldung beim Update von Version 1.5.45.1 auf 1.5.52.0 JTL-Wawi - Fehler und Bugs 1
Neu Nach Wawi Update - Artikel nur noch im Shop sichtbar User helfen Usern - Fragen zu JTL-Wawi 4
Neu Kategoriebox auf Startseite verschwunden nach Update auf Shop 5.0.4 JTL-Shop - Fehler und Bugs 11
Neu update von 1.5.51.1 auf 1.6.32.1 Installation von JTL-Wawi 0
Neu Nach Update auf 1.5.52.0 wird nicht mehr der bill-name übernommen, sondern nur der buyer-name!!! Amazon-Anbindung - Fehler und Bugs 4
Neu Welche Reihenfolge Update erst Wawi von 1.5.X auf 1.6 oder erst Shop 4.06. auf 5? Installation von JTL-Wawi 3
Weißer Bildschirm nach Update auf 5.1.1. Upgrade JTL-Shop4 auf JTL-Shop5 2
Neu Update Paypal auf 2.1.x Betrieb / Pflege von JTL-Shop 2
Neu Update von 4.06 auf Shop 5.1.1 - Schweiz lässt sich bei Registrierung nicht mehr auswählen JTL-Shop - Fehler und Bugs 1
Beantwortet JTL-POS Update Einrichtung / Updates von JTL-POS 1
Neu Shop 5 - Artikelvariationen lassen sich nach Update nicht mehr auswählen JTL-Shop - Fehler und Bugs 1
Neu Vorlage Lieferantenbestellung: Variablen in deutsch => Update auf die 1.6 Druck-/ E-Mail-/ Exportvorlagen in JTL-Wawi 0
Neu Konvertierung der Datenbank bei Update Installation / Updates von JTL-Shop 0
Neu Update von 1.6.29.3 auf 1.6.32 schlägt fehl. Installation von JTL-Wawi 0
Nach Update bleibt Seite weiß mit Nova Upgrade JTL-Shop4 auf JTL-Shop5 3
Neu Update WaWi von 1.5.51.0 auf 1.6.32.0 Installation von JTL-Wawi 12
Gelöst Nach update 4.06 auf 5.11 - kein on page composer, keine Produkte, keine Anzeige Wartungsmodus Upgrade JTL-Shop4 auf JTL-Shop5 1

Ähnliche Themen