{ "timestamp": "2026-04-24 04:49:06.8943", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.InspectionsRepo.GetAllInspectionTypes(Int32 orgId, InspectionTypeFilter filter, List`1 siteIds) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\InspectionsRepo.cs:line 2909\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-24 04:49:06.9339", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-24 04:50:05.2622", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ht.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ht.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryAsync>d__33`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.DAL.Repositories.HealthRepo.<GetAllHealthTypes>d__10.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\HealthRepo.cs:line 399\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.API.BLL.HealthBLL.<GetAllHealthTypes>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\HealthBLL.cs:line 503" }
{ "timestamp": "2026-04-24 04:50:05.2622", "level": "Error", "severity": "ERROR" }