When a query returns no results, this error is displayed at the top of the screen: "Error! 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 '-500' at line 17"
The " -500 " in the error message directly correlates to the "Logs Per Page" setting.
Seems purely cosmetic, as it does not seem to impair functionality.
Technitium 15.0.1
MariaDB 12.2.2
The full error from log file:
MySqlConnector.MySqlException (0x80004005): 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 '-500' at line 17 at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 1125 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/MySqlDataReader.cs:line 489
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/Core/CommandExecutor.cs:line 58
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 352
at QueryLogsMySql.App.QueryLogsAsync(Int64 pageNumber, Int32 entriesPerPage, Boolean descendingOrder, Nullable1 start, Nullable1 end, IPAddress clientIpAddress, Nullable1 protocol, Nullable1 responseType, Nullable1 rcode, String qname, Nullable1 qtype, Nullable1 qclass) in Z:\Technitium\Projects\DnsServer\Apps\QueryLogsMySqlApp\App.cs:line 850 at QueryLogsMySql.App.QueryLogsAsync(Int64 pageNumber, Int32 entriesPerPage, Boolean descendingOrder, Nullable1 start, Nullable1 end, IPAddress clientIpAddress, Nullable1 protocol, Nullable1 responseType, Nullable1 rcode, String qname, Nullable1 qtype, Nullable1 qclass) in Z:\Technitium\Projects\DnsServer\Apps\QueryLogsMySqlApp\App.cs:line 852
at QueryLogsMySql.App.QueryLogsAsync(Int64 pageNumber, Int32 entriesPerPage, Boolean descendingOrder, Nullable1 start, Nullable1 end, IPAddress clientIpAddress, Nullable1 protocol, Nullable1 responseType, Nullable1 rcode, String qname, Nullable1 qtype, Nullable1 qclass) in Z:\Technitium\Projects\DnsServer\Apps\QueryLogsMySqlApp\App.cs:line 885 at DnsServerCore.DnsWebService.WebServiceLogsApi.QueryLogsAsync(HttpContext context) in Z:\Technitium\Projects\DnsServer\DnsServerCore\WebServiceLogsApi.cs:line 206 at DnsServerCore.DnsWebService.WebServiceApiMiddleware(HttpContext context, RequestDelegate next) in Z:\Technitium\Projects\DnsServer\DnsServerCore\DnsWebService.cs:line 2222 at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|10_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)
When a query returns no results, this error is displayed at the top of the screen: "Error! 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 '-500' at line 17"
The " -500 " in the error message directly correlates to the "Logs Per Page" setting.
Seems purely cosmetic, as it does not seem to impair functionality.
Technitium 15.0.1
MariaDB 12.2.2
The full error from log file:
MySqlConnector.MySqlException (0x80004005): 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 '-500' at line 17 at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 1125 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/MySqlDataReader.cs:line 489at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/Core/CommandExecutor.cs:line 58
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 352
at QueryLogsMySql.App.QueryLogsAsync(Int64 pageNumber, Int32 entriesPerPage, Boolean descendingOrder, Nullable
1 start, Nullable1 end, IPAddress clientIpAddress, Nullable1 protocol, Nullable1 responseType, Nullable1 rcode, String qname, Nullable1 qtype, Nullable1 qclass) in Z:\Technitium\Projects\DnsServer\Apps\QueryLogsMySqlApp\App.cs:line 850 at QueryLogsMySql.App.QueryLogsAsync(Int64 pageNumber, Int32 entriesPerPage, Boolean descendingOrder, Nullable1 start, Nullable1 end, IPAddress clientIpAddress, Nullable1 protocol, Nullable1 responseType, Nullable1 rcode, String qname, Nullable1 qtype, Nullable1 qclass) in Z:\Technitium\Projects\DnsServer\Apps\QueryLogsMySqlApp\App.cs:line 852at QueryLogsMySql.App.QueryLogsAsync(Int64 pageNumber, Int32 entriesPerPage, Boolean descendingOrder, Nullable
1 start, Nullable1 end, IPAddress clientIpAddress, Nullable1 protocol, Nullable1 responseType, Nullable1 rcode, String qname, Nullable1 qtype, Nullable1 qclass) in Z:\Technitium\Projects\DnsServer\Apps\QueryLogsMySqlApp\App.cs:line 885 at DnsServerCore.DnsWebService.WebServiceLogsApi.QueryLogsAsync(HttpContext context) in Z:\Technitium\Projects\DnsServer\DnsServerCore\WebServiceLogsApi.cs:line 206 at DnsServerCore.DnsWebService.WebServiceApiMiddleware(HttpContext context, RequestDelegate next) in Z:\Technitium\Projects\DnsServer\DnsServerCore\DnsWebService.cs:line 2222 at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|10_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)