Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = delete |
JTL-Wawi PK = 10710 | [db9d64df-5b4b-4269-b13a-fff9f27a315a] The
Shopware 6 Admin API responded with an error:
Code = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pcs
WHERE pcs.product_id IN ('z\0002=\0013;?D)?r??\0015Q')
AN...' at line 1
Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [a55b3fcf-8ea8-49b3-b2c3-a7e68c95ec74] The Shopware 6 Admin API responded with an error:
Code = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pcs
WHERE pcs.product_id IN ('z\0002=\0013;?D)?r??\0015Q')
AN...' at line 1
Artikel-Löschen-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.delete: Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [db9d64df-5b4b-4269-b13a-fff9f27a315a] The Shopware 6 Admin API responded with an error:
Code = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pcs
WHERE pcs.product_id IN ('z\0002=\0013;?D)?r??\0015Q')
AN...' at line 1
Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [a55b3fcf-8ea8-49b3-b2c3-a7e68c95ec74] The Shopware 6 Admin API responded with an error:
Code = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pcs
WHERE pcs.product_id IN ('z\0002=\0013;?D)?r??\0015Q')
AN...' at line 1
Response: {"jtlrpc":"2.0","id":"7cfe648e6b6a4a68bba741ff3605442d","result":null,"error":{"code":520,"message":"Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [342f60ef-32e1-422a-9430-d11fb9245ef0] The Shopware 6 Admin API responded with an error: \nCode = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \u0027pcs\n WHERE pcs.product_id IN (\u0027z\\0002=\\0013;?D)?\u07fbr??\\0015Q\u0027)\n AN...\u0027 at line 1","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:110"},"warnings":[]}
Exception bei product.delete: Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [db9d64df-5b4b-4269-b13a-fff9f27a315a] The Shopware 6 Admin API responded with an error:
Code = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pcs
WHERE pcs.product_id IN ('z\0002=\0013;?D)?r??\0015Q')
AN...' at line 1
Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [a55b3fcf-8ea8-49b3-b2c3-a7e68c95ec74] The Shopware 6 Admin API responded with an error:
Code = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pcs
WHERE pcs.product_id IN ('z\0002=\0013;?D)?r??\0015Q')
AN...' at line 1
Response: {"jtlrpc":"2.0","id":"ff8644ea3d374d7fbc853c2e1788fd20","result":null,"error":{"code":520,"message":"Controller = Product | Action = delete | JTL-Wawi PK = 10710 | [db9d64df-5b4b-4269-b13a-fff9f27a315a] The Shopware 6 Admin API responded with an error: \nCode = 1064 | Detail = An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \u0027pcs\n WHERE pcs.product_id IN (\u0027z\\0002=\\0013;?D)?\u07fbr??\\0015Q\u0027)\n AN...\u0027 at line 1","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:110"},"warnings":[]}
bei jtlCore.ControllerClasses.
Connector.Abgleich.Connector.Call(String method, Object parameters, Boolean withSession, NetworkCredential credentials)
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.RepeatCall(String method, Object parameters, Boolean withSession, NetworkCredential credentials, Boolean newSession)
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.Call(String method, Object parameters, Boolean withSession, NetworkCredential credentials)
2026-01-03T08:14:44 DEBUG - [SQL] SELECT * FROM [tWidget]
LEFT JOIN [dbo].[tWidgetTemplate] ON [tWidgetTemplate].kWidgetTemplate = tWidget.kWidgetTemplate
WHERE ((kBenutzer = @kBenutzer) OR (kBenutzer = -1)) AND (nApplikation = @nApplikation) AND (cArbeitsplatz = @cArbeitsplatz)
kBenutzer = 1,
nApplikation = 1,
cArbeitsplatz = 'JTLSERVER'
2026-01-03T08:14:44 DEBUG - [SQL] Dauer: 2ms
2026-01-03T08:14:44 DEBUG - SELECT * FROM [tWidgetLayout] WHERE [kBenutzer] = @kBenutzer
@kBenutzer = 1
2026-01-03T08:14:44 DEBUG - Dauer: 1ms, (bis zum Reader)
2026-01-03T08:14:44 DEBUG - Dauer: 4ms, 11 Zeilen
2026-01-03T08:14:46 DEBUG - SELECT [cVersion] FROM [dbo].[tVersion]
2026-01-03T08:14:47 DEBUG - Dauer: 1ms, Result: 1.11.5.0
2026-01-03T08:14:47 DEBUG - SELECT [cVersion] FROM [dbo].[tVersion]
2026-01-03T08:14:47 DEBUG - Dauer: 1ms, Result: 1.11.5.0
2026-01-03T08:14:47 DEBUG - SELECT [cVersion] FROM [dbo].[tVersion]
2026-01-03T08:14:47 DEBUG - Dauer: 1ms, Result: 1.11.5.0
2026-01-03T08:14:47 DEBUG - SELECT [cVersion] FROM [dbo].[tVersion]
2026-01-03T08:14:47 DEBUG - Dauer: 0ms, Result: 1.11.5.0
2026-01-03T08:14:47 DEBUG - SELECT [cVersion] FROM [dbo].[tVersion]
2026-01-03T08:14:47 DEBUG - Dauer: 1ms, Result: 1.11.5.0
2026-01-03T08:14:49 DEBUG - UPDATE [dbo].[tWidgetLayout] SET cLayout = @cLayout_0 WHERE kWidgetLayout = @kWidgetLayout_0;
@cLayout_0 = '<?xml version="1.0" encoding="utf-16"?><LayoutRoot xmlns:xsd="
http://www.w3.org/2001/XMLSchema" xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" SelectedTheme="Standard"><RootPanel Orientation="Horizontal"><LayoutDocumentPaneGroup Orientation="Vertical"><LayoutDocumentPane DockHeight="0.275819403673064*"><LayoutDocument Title="Sie verwenden die neueste Version" IsSelected="True" ContentId="312" FloatingLeft="773" FloatingTop="353" FloatingWidth="636" FloatingHeight="104" LastActivationTimeStamp="01/02/2026 23:03:42" /></LayoutDocumentPane><LayoutDocumentPaneGroup Orientation="Horizontal"><LayoutDocumentPane><LayoutDocument Title="Unbezahlte Aufträge" IsSelected="True" ContentId="313" FloatingLeft="-40" FloatingTop="488" FloatingWidth="1920" FloatingHeight="250" LastActivationTimeStamp="01/02/2026 23:03:43" /></LayoutDocumentPane><LayoutDocumentPane><LayoutDocument Title="Onlineshop-Neukunden" IsSelected="True" IsLastFocusedDocument="True" ContentId="314" LastActivationTimeStamp="01/02/2026 23:03:43" /></LayoutDocumentPane></LayoutDocumentPaneGroup><LayoutDocumentPane><LayoutDocument Title="Fällige Abonnements" IsSelected="True" ContentId="315" FloatingLeft="-9" FloatingTop="966" FloatingWidth="1920" FloatingHeight="243" LastActivationTimeStamp="01/02/2026 23:03:43" /></LayoutDocumentPane></LayoutDocumentPaneGroup></RootPanel><TopSide /><RightSide /><LeftSide /><BottomSide /><FloatingWindows /><Hidden /></LayoutRoot>'
@kWidgetLayout_0 = 49
2026-01-03T08:14:49 DEBUG - Dauer: 3ms, AffectedRows: 1
2026-01-03T08:14:49 DEBUG - UPDATE [dbo].[tWidgetLayout] SET cLayout = @cLayout_0 WHERE kWidgetLayout = @kWidgetLayout_0;
@cLayout_0 = '<?xml version="1.0" encoding="utf-16"?><LayoutRoot xmlns:xsd="
http://www.w3.org/2001/XMLSchema" xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" SelectedTheme="Standard"><RootPanel Orientation="Horizontal"><LayoutDocumentPaneGroup Orientation="Vertical"><LayoutDocumentPane DockHeight="0.275819403673064*"><LayoutDocument Title="Update verfügbar" IsSelected="True" ContentId="312" FloatingLeft="773" FloatingTop="353" FloatingWidth="636" FloatingHeight="104" LastActivationTimeStamp="01/03/2026 08:14:44" /></LayoutDocumentPane><LayoutDocumentPaneGroup Orientation="Horizontal"><LayoutDocumentPane><LayoutDocument Title="Unbezahlte Aufträge" IsSelected="True" ContentId="313" FloatingLeft="-40" FloatingTop="488" FloatingWidth="1920" FloatingHeight="250" LastActivationTimeStamp="01/03/2026 08:14:44" /></LayoutDocumentPane><LayoutDocumentPane><LayoutDocument Title="Onlineshop-Neukunden" IsSelected="True" IsLastFocusedDocument="True" ContentId="314" LastActivationTimeStamp="01/03/2026 08:14:44" /></LayoutDocumentPane></LayoutDocumentPaneGroup><LayoutDocumentPane><LayoutDocument Title="Fällige Abonnements" IsSelected="True" ContentId="315" FloatingLeft="-9" FloatingTop="966" FloatingWidth="1920" FloatingHeight="243" LastActivationTimeStamp="01/03/2026 08:14:44" /></LayoutDocumentPane></LayoutDocumentPaneGroup></RootPanel><TopSide /><RightSide /><LeftSide /><BottomSide /><FloatingWindows /><Hidden /></LayoutRoot>'
@kWidgetLayout_0 = 49
2026-01-03T08:14:49 DEBUG - Dauer: 3ms, AffectedRows: 1
2026-01-03T08:14:58 INFO - Force Flush
2026-01-03T08:15:06 DEBUG - UPDATE dbo.tKategorieShop
SET dbo.tKategorieShop.nInBearbeitung = 0
WHERE dbo.tKategorieShop.kShop = 19
AND dbo.tKategorieShop.nInBearbeitung = 1
2026-01-03T08:15:07 DEBUG - Dauer: 416ms, AffectedRows: 0
2026-01-03T08:15:07 DEBUG - UPDATE dbo.tArtikelShop
SET dbo.tArtikelShop.nInBearbeitung = 0
WHERE dbo.tArtikelShop.kShop = 19
AND dbo.tArtikelShop.nInBearbeitung = 1
2026-01-03T08:15:07 DEBUG - Dauer: 552ms, AffectedRows: 7140
2026-01-03T08:15:28 INFO - Force Flush
Zeitstempel: 2026-01-03T08:15:39
Locale: German (Germany)
Locale: German (Germany)
Version: 1.11.5.0
Plattform: Wawi
WawiSeed: 0.0.00000.00001
Prozessname: JTL-SharpWawi
Physikalischer Speicher: 772911104 / Peak: 775606272
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:18:30,078125
CPU-Zeit (System): 0:15:50,875
Page-Size (Sytem): 1863008 / Peak: 553320448
Page-Size: 543424512 / Peak: 553320448
Offene Handles: 2946
Database:
Build: 2512031422 2e818026da657cac98c592c6333235329e325955
