level: Error

severity: ERROR

message: Unknown column 'mc.id' in 'on clause'

stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'mc.id' in 'on clause'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Dapper.SqlMapper.<QueryAsync>d__33`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at IncidentReporter.DAL.Repositories.WorkPermitRepo.<GetAllWorkPermitCategories>d__65.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\WorkPermitRepo.cs:line 2331
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at IncidentReporter.API.BLL.WorkPermitBLL.<GetAllWorkPermitCategories>d__29.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\WorkPermitBLL.cs:line 2871