[06.05.2025 05:20:03.032 +00:00 INF] 0HNCBPGTKV7HC:00000001 / called [06.05.2025 05:20:03.481 +00:00 INF] 0HNCBPGTKV7HC:00000002 /Images/ called [06.05.2025 05:20:04.381 +00:00 INF] 0HNCBPGTKV7HC:00000003 /invoices/ called [06.05.2025 05:20:04.825 +00:00 INF] 0HNCBPGTKV7HC:00000004 /Logs/ called [06.05.2025 05:20:05.393 +00:00 INF] 0HNCBPGTKV7HC:00000005 /Resources/ called [06.05.2025 05:41:01.799 +00:00 INF] 0HNCBPGTKV7HD:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 05:41:01.816 +00:00 INF] 0HNCBPGTKV7HE:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 05:41:02.248 +00:00 INF] 0HNCBPGTKV7HE:00000002 /api/Order/GetAllByStatus called [06.05.2025 06:47:16.641 +00:00 INF] 0HNCBPGTKV7HF:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 06:47:16.652 +00:00 INF] 0HNCBPGTKV7HG:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 06:47:17.068 +00:00 INF] 0HNCBPGTKV7HF:00000002 /api/Order/GetAllByStatus called [06.05.2025 08:27:26.960 +00:00 INF] 0HNCBPGTKV7HH:00000001 / called [06.05.2025 08:27:27.081 +00:00 INF] 0HNCBPGTKV7HI:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 08:27:27.324 +00:00 INF] 0HNCBPGTKV7HI:00000002 /api/ProductCategory/GetHierarchy called [06.05.2025 08:27:27.564 +00:00 INF] 0HNCBPGTKV7HI:00000003 /api/Order/GetAllByStatus called [06.05.2025 08:55:17.504 +00:00 INF] 0HNCBPGTKV7HJ:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 08:55:17.771 +00:00 INF] 0HNCBPGTKV7HJ:00000002 /api/Order/GetAllByStatus called [06.05.2025 08:55:19.086 +00:00 INF] 0HNCBPGTKV7HJ:00000003 /api/ProductCategory/GetHierarchy called [06.05.2025 08:55:19.091 +00:00 INF] 0HNCBPGTKV7HK:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 08:55:19.484 +00:00 INF] 0HNCBPGTKV7HK:00000002 /api/SiteSetting/GetByNameAsync called [06.05.2025 08:55:19.527 +00:00 INF] 0HNCBPGTKV7HJ:00000004 /api/Order/GetAllByStatus called [06.05.2025 08:55:19.564 +00:00 INF] 0HNCBPGTKV7HL:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 08:55:19.858 +00:00 INF] 0HNCBPGTKV7HL:00000002 /api/Order/GetAllByStatus called [06.05.2025 08:55:34.654 +00:00 INF] 0HNCBPGTKV7HL:00000003 /api/ProductCategory/GetHierarchy called [06.05.2025 08:55:34.939 +00:00 INF] 0HNCBPGTKV7HL:00000004 /api/Order/GetAllByStatus called [06.05.2025 09:56:58.168 +00:00 INF] 0HNCBPGTKV7HM:00000001 / called [06.05.2025 09:57:02.945 +00:00 INF] 0HNCBPGTKV7HM:00000002 /favicon.ico called [06.05.2025 09:57:04.035 +00:00 INF] 0HNCBPGTKV7HM:00000003 /ads.txt called [06.05.2025 11:22:30.940 +00:00 INF] 0HNCBPGTKV7HN:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 11:22:30.966 +00:00 INF] 0HNCBPGTKV7HO:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 11:22:31.365 +00:00 INF] 0HNCBPGTKV7HO:00000002 /api/Order/GetAllByStatus called [06.05.2025 11:22:31.586 +00:00 INF] 0HNCBPGTKV7HO:00000003 /api/FavouriteOrder/GetAllByUserId called [06.05.2025 11:22:35.164 +00:00 INF] 0HNCBPGTKV7HO:00000005 /api/Account/GetUserData called [06.05.2025 11:22:36.441 +00:00 INF] 0HNCBPGTKV7HO:0000000A /api/Notification/GetAllByToUserId/0/8 called [06.05.2025 11:22:36.453 +00:00 INF] 0HNCBPGTKV7HN:00000002 /api/SiteSetting/GetEnumValues called [06.05.2025 11:22:36.467 +00:00 INF] 0HNCBPGTKV7HQ:00000001 /api/ProductCategory/populars/0/3 called [06.05.2025 11:22:36.655 +00:00 INF] 0HNCBPGTKV7HN:00000003 /api/UserCoupon/getForCurrentUser called [06.05.2025 11:22:52.870 +00:00 INF] 0HNCBPGTKV7HN:00000004 /api/ProductCategory/GetHierarchy called [06.05.2025 11:22:53.161 +00:00 INF] 0HNCBPGTKV7HN:00000005 /api/Order/GetAllByStatus called [06.05.2025 11:22:53.376 +00:00 INF] 0HNCBPGTKV7HN:00000006 /api/FavouriteOrder/GetAllByUserId called [06.05.2025 11:22:55.142 +00:00 INF] 0HNCBPGTKV7HN:00000007 /api/ProductCategory/GetHierarchy called [06.05.2025 11:22:55.143 +00:00 INF] 0HNCBPGTKV7HQ:00000002 /api/SiteSetting/GetByNameAsync called [06.05.2025 11:22:55.408 +00:00 INF] 0HNCBPGTKV7HN:00000008 /api/Order/GetAllByStatus called [06.05.2025 11:22:55.623 +00:00 INF] 0HNCBPGTKV7HN:00000009 /api/FavouriteOrder/GetAllByUserId called [06.05.2025 12:22:57.584 +00:00 INF] 0HNCBPGTKV7I6:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 12:22:57.604 +00:00 INF] 0HNCBPGTKV7I7:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 12:22:57.961 +00:00 INF] 0HNCBPGTKV7I7:00000002 /api/Order/GetAllByStatus called [06.05.2025 12:22:59.178 +00:00 INF] 0HNCBPGTKV7I7:00000003 /api/FavouriteOrder/GetAllByUserId called [06.05.2025 12:22:59.680 +00:00 INF] 0HNCBPGTKV7I7:00000005 /api/Account/GetUserData called [06.05.2025 12:23:00.946 +00:00 INF] 0HNCBPGTKV7I6:00000002 /api/SiteSetting/GetEnumValues called [06.05.2025 12:23:00.960 +00:00 INF] 0HNCBPGTKV7I8:00000001 /api/ProductCategory/populars/0/3 called [06.05.2025 12:23:00.961 +00:00 INF] 0HNCBPGTKV7I9:00000001 /api/Notification/GetAllByToUserId/0/8 called [06.05.2025 12:23:01.208 +00:00 INF] 0HNCBPGTKV7I9:00000002 /api/UserCoupon/getForCurrentUser called [06.05.2025 12:26:51.314 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 12:26:53.085 +00:00 INF] Migrations [06.05.2025 12:26:53.128 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 12:26:53.132 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 12:26:53.133 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 12:26:53.134 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 12:26:53.135 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 12:26:53.136 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 12:26:53.137 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 12:26:53.138 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 12:26:53.139 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 12:26:53.140 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 12:26:53.141 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 12:26:53.142 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 12:26:53.143 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 12:26:53.144 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 12:26:53.145 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 12:26:53.146 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 12:26:53.147 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 12:26:53.148 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 12:26:53.149 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 12:26:53.150 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 12:26:53.152 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 12:26:53.153 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 12:26:53.159 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 12:26:53.160 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 12:26:53.162 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 12:26:53.163 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 12:26:53.164 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 12:26:53.165 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 12:26:53.167 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 12:26:53.168 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 12:26:53.169 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 12:26:53.170 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 12:26:53.171 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 12:26:53.172 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 12:26:53.173 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 12:26:53.174 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 12:26:53.175 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 12:26:53.176 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 12:26:53.177 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 12:26:53.178 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 12:26:53.179 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 12:26:53.180 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 12:26:53.181 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 12:26:53.182 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 12:26:53.183 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 12:26:53.184 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 12:26:53.185 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 12:26:53.186 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 12:26:53.186 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 12:26:53.187 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 12:26:53.188 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 12:26:53.189 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 12:26:53.190 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 12:26:53.191 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 12:26:53.192 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 12:26:53.193 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 12:26:53.194 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 12:26:53.194 +00:00 INF] 20250506160000: _20250506160000_UpdateOrderGetAllByStatusSP [06.05.2025 12:26:53.195 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 12:26:53.197 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 12:26:53.197 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 12:26:53.198 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 12:26:53.199 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 12:26:53.200 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 12:26:54.789 +00:00 INF] 0HNCCJ54LRIUQ:00000001 /robots933456.txt called [06.05.2025 12:26:56.722 +00:00 INF] 0HNCCJ54LRIUR:00000001 /robots933456.txt called [06.05.2025 12:26:57.504 +00:00 INF] 0HNCCJ54LRIUS:00000001 /robots933456.txt called [06.05.2025 13:10:09.512 +00:00 INF] 0HNCCJ54LRIV7:00000001 / called [06.05.2025 13:10:09.934 +00:00 INF] 0HNCCJ54LRIV7:00000002 /Images/ called [06.05.2025 13:10:10.512 +00:00 INF] 0HNCCJ54LRIV7:00000003 /invoices/ called [06.05.2025 13:10:10.908 +00:00 INF] 0HNCCJ54LRIV7:00000004 /Logs/ called [06.05.2025 13:10:11.500 +00:00 INF] 0HNCCJ54LRIV7:00000005 /Resources/ called [06.05.2025 14:58:43.358 +00:00 INF] 0HNCCJ54LRIVE:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 14:58:43.375 +00:00 INF] 0HNCCJ54LRIVF:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 14:58:43.735 +00:00 INF] 0HNCCJ54LRIVE:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:02:31.372 +00:00 INF] 0HNCCJ54LRIVG:00000001 /sftp-config.json called [06.05.2025 15:02:32.302 +00:00 INF] 0HNCCJ54LRIVG:00000002 /.vscode/sftp.json called [06.05.2025 15:10:02.455 +00:00 INF] 0HNCCJ54LRIVH:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 15:10:02.474 +00:00 INF] 0HNCCJ54LRIVI:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:10:04.092 +00:00 INF] 0HNCCJ54LRIVH:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:10:04.530 +00:00 ERR] 0HNCCJ54LRIVH:00000002 Api Error: 0HNCCJ54LRIVH:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:b4d3c2fb-d941-4048-874c-d7ab51ac46b5 Error Number:102,State:1,Class:15 ClientConnectionId before routing:d4b57f2c-affb-42dd-8060-46a0ad1563bb Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:10:05.585 +00:00 INF] 0HNCCJ54LRIVH:00000004 /api/Account/GetUserData called [06.05.2025 15:10:06.656 +00:00 INF] 0HNCCJ54LRIVH:00000007 /api/SiteSetting/GetEnumValues called [06.05.2025 15:10:06.827 +00:00 INF] 0HNCCJ54LRIVI:00000002 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:10:29.465 +00:00 INF] 0HNCCJ54LRIVI:00000003 /api/ProductCategory/GetHierarchy called [06.05.2025 15:10:30.004 +00:00 INF] 0HNCCJ54LRIVI:00000004 /api/Order/GetAllByStatus called [06.05.2025 15:10:30.216 +00:00 ERR] 0HNCCJ54LRIVI:00000004 Api Error: 0HNCCJ54LRIVI:00000004 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:b4d3c2fb-d941-4048-874c-d7ab51ac46b5 Error Number:102,State:1,Class:15 ClientConnectionId before routing:d4b57f2c-affb-42dd-8060-46a0ad1563bb Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:10:37.083 +00:00 INF] 0HNCCJ54LRIVI:00000005 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:10:37.104 +00:00 INF] 0HNCCJ54LRIVH:00000008 /api/ProductCategory/GetHierarchy called [06.05.2025 15:10:37.395 +00:00 INF] 0HNCCJ54LRIVH:00000009 /api/Order/GetAllByStatus called [06.05.2025 15:10:37.627 +00:00 ERR] 0HNCCJ54LRIVH:00000009 Api Error: 0HNCCJ54LRIVH:00000009 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:b4d3c2fb-d941-4048-874c-d7ab51ac46b5 Error Number:102,State:1,Class:15 ClientConnectionId before routing:d4b57f2c-affb-42dd-8060-46a0ad1563bb Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:10:38.026 +00:00 INF] 0HNCCJ54LRIVH:0000000B /api/Account/GetUserData called [06.05.2025 15:10:38.638 +00:00 INF] 0HNCCJ54LRIVI:00000007 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:10:38.638 +00:00 INF] 0HNCCJ54LRIVH:0000000D /api/SiteSetting/GetEnumValues called [06.05.2025 15:18:50.805 +00:00 INF] 0HNCCJ54LRIVL:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:18:50.845 +00:00 INF] 0HNCCJ54LRIVM:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 15:18:51.335 +00:00 INF] 0HNCCJ54LRIVL:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:18:51.546 +00:00 ERR] 0HNCCJ54LRIVL:00000002 Api Error: 0HNCCJ54LRIVL:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:8813f1e9-e91d-4541-ac15-5aa326998847 Error Number:102,State:1,Class:15 ClientConnectionId before routing:20554386-0d6f-4a8f-b33d-c49dc06e55cf Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:18:52.491 +00:00 INF] 0HNCCJ54LRIVL:00000004 /api/Account/GetUserData called [06.05.2025 15:18:53.410 +00:00 INF] 0HNCCJ54LRIVL:00000007 /api/SiteSetting/GetEnumValues called [06.05.2025 15:18:53.587 +00:00 INF] 0HNCCJ54LRIVM:00000002 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:19:14.186 +00:00 INF] 0HNCCJ54LRIVM:00000003 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:19:14.200 +00:00 INF] 0HNCCJ54LRIVL:00000008 /api/ProductCategory/GetHierarchy called [06.05.2025 15:19:15.060 +00:00 INF] 0HNCCJ54LRIVL:00000009 /api/Order/GetAllByStatus called [06.05.2025 15:19:21.987 +00:00 INF] 0HNCCJ54LRIVL:0000000C /api/ProductCategory/populars/0/3 called [06.05.2025 15:19:22.627 +00:00 INF] 0HNCCJ54LRIVL:0000000D /api/ProductCategory/populars/0/3 called [06.05.2025 15:20:15.101 +00:00 INF] 0HNCCJ54LRIVL:0000000F /api/Auth/SendSms called [06.05.2025 15:20:15.345 +00:00 INF] 0HNCCJ54LRIVL:0000000F Start processing HTTP request POST https://www.google.com/recaptcha/api/siteverify [06.05.2025 15:20:15.355 +00:00 INF] 0HNCCJ54LRIVL:0000000F Sending HTTP request POST https://www.google.com/recaptcha/api/siteverify [06.05.2025 15:20:16.411 +00:00 INF] 0HNCCJ54LRIVL:0000000F Received HTTP response headers after 1046.3651ms - 200 [06.05.2025 15:20:16.421 +00:00 INF] 0HNCCJ54LRIVL:0000000F End processing HTTP request after 1083.1214ms - 200 [06.05.2025 15:20:16.523 +00:00 INF] 0HNCCJ54LRIVL:0000000F Start processing HTTP request POST https://findin-otp.azurewebsites.net/api/Otp [06.05.2025 15:20:16.524 +00:00 INF] 0HNCCJ54LRIVL:0000000F Sending HTTP request POST https://findin-otp.azurewebsites.net/api/Otp [06.05.2025 15:20:18.279 +00:00 INF] 0HNCCJ54LRIVL:0000000F Received HTTP response headers after 1754.0364ms - 200 [06.05.2025 15:20:18.282 +00:00 INF] 0HNCCJ54LRIVL:0000000F End processing HTTP request after 1758.8052ms - 200 [06.05.2025 15:20:22.797 +00:00 INF] 0HNCCJ54LRIVL:00000011 /api/Auth/VerifySmsCode called [06.05.2025 15:20:23.574 +00:00 INF] 0HNCCJ54LRIVL:00000013 /api/Account/GetUserData called [06.05.2025 15:20:24.172 +00:00 INF] 0HNCCJ54LRIVL:00000016 /api/SiteSetting/GetEnumValues called [06.05.2025 15:20:24.180 +00:00 INF] 0HNCCJ54LRIVM:00000004 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:20:24.772 +00:00 INF] 0HNCCJ54LRIVL:00000017 /api/ProductCategory/GetHierarchy called [06.05.2025 15:20:26.113 +00:00 INF] 0HNCCJ54LRIVL:00000018 /api/Order/GetAllByStatus called [06.05.2025 15:20:26.329 +00:00 ERR] 0HNCCJ54LRIVL:00000018 Api Error: 0HNCCJ54LRIVL:00000018 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:8813f1e9-e91d-4541-ac15-5aa326998847 Error Number:102,State:1,Class:15 ClientConnectionId before routing:20554386-0d6f-4a8f-b33d-c49dc06e55cf Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:21:38.485 +00:00 INF] 0HNCCJ54LRIVL:00000019 /api/ProductCategory/GetHierarchy called [06.05.2025 15:21:38.509 +00:00 INF] 0HNCCJ54LRIVP:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:21:39.781 +00:00 INF] 0HNCCJ54LRIVP:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:21:39.982 +00:00 ERR] 0HNCCJ54LRIVP:00000002 Api Error: 0HNCCJ54LRIVP:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:8813f1e9-e91d-4541-ac15-5aa326998847 Error Number:102,State:1,Class:15 ClientConnectionId before routing:20554386-0d6f-4a8f-b33d-c49dc06e55cf Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:21:40.449 +00:00 INF] 0HNCCJ54LRIVP:00000004 /api/Account/GetUserData called [06.05.2025 15:22:08.060 +00:00 INF] 0HNCCJ54LRIVP:00000007 /api/SiteSetting/GetEnumValues called [06.05.2025 15:22:08.073 +00:00 INF] 0HNCCJ54LRIVL:0000001A /api/UserCoupon/getForCurrentUser called [06.05.2025 15:22:11.034 +00:00 INF] 0HNCCJ54LRIVP:00000008 /api/ProductCategory/GetHierarchy called [06.05.2025 15:22:11.044 +00:00 INF] 0HNCCJ54LRIVQ:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:22:12.363 +00:00 INF] 0HNCCJ54LRIVQ:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:22:12.582 +00:00 ERR] 0HNCCJ54LRIVQ:00000002 Api Error: 0HNCCJ54LRIVQ:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:e6af0a5e-d44a-4b96-a260-04f0517a2ab4 Error Number:102,State:1,Class:15 ClientConnectionId before routing:3abb5866-f30a-4f21-ad12-48ce136d0080 Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:22:12.846 +00:00 INF] 0HNCCJ54LRIVQ:00000003 /api/Account/GetUserData called [06.05.2025 15:22:16.126 +00:00 INF] 0HNCCJ54LRIVQ:00000006 /api/SiteSetting/GetEnumValues called [06.05.2025 15:22:16.137 +00:00 INF] 0HNCCJ54LRIVP:0000000A /api/UserCoupon/getForCurrentUser called [06.05.2025 15:23:03.229 +00:00 INF] 0HNCCJ54LRIVR:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 15:23:03.240 +00:00 INF] 0HNCCJ54LRIVS:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:23:04.533 +00:00 INF] 0HNCCJ54LRIVS:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:23:04.732 +00:00 ERR] 0HNCCJ54LRIVS:00000002 Api Error: 0HNCCJ54LRIVS:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:8813f1e9-e91d-4541-ac15-5aa326998847 Error Number:102,State:1,Class:15 ClientConnectionId before routing:20554386-0d6f-4a8f-b33d-c49dc06e55cf Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:23:05.094 +00:00 INF] 0HNCCJ54LRIVS:00000003 /api/Account/GetUserData called [06.05.2025 15:23:15.719 +00:00 INF] 0HNCCJ54LRIVS:00000006 /api/SiteSetting/GetEnumValues called [06.05.2025 15:23:15.726 +00:00 INF] 0HNCCJ54LRIVR:00000003 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:24:58.351 +00:00 INF] 0HNCCJ54LRIVT:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 15:24:58.351 +00:00 INF] 0HNCCJ54LRIVU:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:24:59.672 +00:00 INF] 0HNCCJ54LRIVU:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:24:59.877 +00:00 ERR] 0HNCCJ54LRIVU:00000002 Api Error: 0HNCCJ54LRIVU:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:e6af0a5e-d44a-4b96-a260-04f0517a2ab4 Error Number:102,State:1,Class:15 ClientConnectionId before routing:3abb5866-f30a-4f21-ad12-48ce136d0080 Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:25:00.117 +00:00 INF] 0HNCCJ54LRIVU:00000003 /api/Account/GetUserData called [06.05.2025 15:25:00.800 +00:00 INF] 0HNCCJ54LRIVU:00000006 /api/SiteSetting/GetEnumValues called [06.05.2025 15:25:00.805 +00:00 INF] 0HNCCJ54LRIVT:00000003 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:27:20.731 +00:00 INF] 0HNCCJ54LRJ00:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 15:27:20.741 +00:00 INF] 0HNCCJ54LRJ01:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 15:27:21.517 +00:00 INF] 0HNCCJ54LRJ01:00000002 /api/Order/GetAllByStatus called [06.05.2025 15:27:21.718 +00:00 ERR] 0HNCCJ54LRJ01:00000002 Api Error: 0HNCCJ54LRJ01:00000002 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:e6af0a5e-d44a-4b96-a260-04f0517a2ab4 Error Number:102,State:1,Class:15 ClientConnectionId before routing:3abb5866-f30a-4f21-ad12-48ce136d0080 Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:27:23.649 +00:00 INF] 0HNCCJ54LRJ01:00000004 /api/Account/GetUserData called [06.05.2025 15:27:24.414 +00:00 INF] 0HNCCJ54LRJ01:00000007 /api/SiteSetting/GetEnumValues called [06.05.2025 15:27:24.601 +00:00 INF] 0HNCCJ54LRJ02:00000001 /api/UserCoupon/getForCurrentUser called [06.05.2025 15:27:24.994 +00:00 INF] 0HNCCJ54LRJ02:00000003 /styles/modern.deepsea.css called [06.05.2025 15:27:24.995 +00:00 INF] 0HNCCJ54LRJ01:00000008 /styles/modern.common.css called [06.05.2025 15:29:12.162 +00:00 INF] 0HNCCJ54LRJ05:00000001 /api/Order/GetAllByStatus called [06.05.2025 15:29:12.376 +00:00 ERR] 0HNCCJ54LRJ05:00000001 Api Error: 0HNCCJ54LRJ05:00000001 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryMultipleAsync(IDbConnection cnn, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 1042 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 173 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 90 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 274 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status, String categorySlug) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.<>c__DisplayClass11_0.<g__ExecuteResponseAsync|0>d.MoveNext() --- End of stack trace from previous location --- at Microsoft.AspNetCore.OutputCaching.WorkDispatcher`2.ScheduleAsync(TKey key, Func`2 valueFactory) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:e6af0a5e-d44a-4b96-a260-04f0517a2ab4 Error Number:102,State:1,Class:15 ClientConnectionId before routing:3abb5866-f30a-4f21-ad12-48ce136d0080 Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 [06.05.2025 15:34:29.873 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 15:34:31.460 +00:00 INF] Migrations [06.05.2025 15:34:31.500 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 15:34:31.508 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 15:34:31.509 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 15:34:31.511 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 15:34:31.512 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 15:34:31.513 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 15:34:31.514 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 15:34:31.515 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 15:34:31.516 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 15:34:31.517 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 15:34:31.518 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 15:34:31.519 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 15:34:31.520 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 15:34:31.521 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 15:34:31.522 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 15:34:31.523 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 15:34:31.524 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 15:34:31.525 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 15:34:31.526 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 15:34:31.527 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 15:34:31.528 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 15:34:31.529 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 15:34:31.530 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 15:34:31.531 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 15:34:31.532 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 15:34:31.533 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 15:34:31.534 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 15:34:31.535 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 15:34:31.536 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 15:34:31.537 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 15:34:31.538 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 15:34:31.539 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 15:34:31.540 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 15:34:31.541 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 15:34:31.542 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 15:34:31.543 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 15:34:31.544 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 15:34:31.545 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 15:34:31.546 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 15:34:31.547 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 15:34:31.547 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 15:34:31.548 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 15:34:31.549 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 15:34:31.550 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 15:34:31.551 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 15:34:31.552 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 15:34:31.553 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 15:34:31.554 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 15:34:31.555 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 15:34:31.556 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 15:34:31.557 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 15:34:31.558 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 15:34:31.559 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 15:34:31.560 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 15:34:31.561 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 15:34:31.562 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 15:34:31.563 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 15:34:31.565 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP (not applied) [06.05.2025 15:34:31.566 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 15:34:31.567 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 15:34:31.568 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 15:34:31.569 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 15:34:31.570 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 15:34:31.571 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 15:34:31.587 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP migrating [06.05.2025 15:34:31.590 +00:00 INF] Beginning Transaction [06.05.2025 15:34:31.602 +00:00 INF] BEGIN TRANSACTION [06.05.2025 15:34:31.635 +00:00 INF] ExecuteSqlStatement ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:34:31.642 +00:00 INF] ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:34:31.726 +00:00 ERR] An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. System.Exception: An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'slug'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.<>c__DisplayClass38_0.b__1(Object sender, SpecialTokenEventArgs args) at FluentMigrator.Runner.BatchParser.SqlBatchParser.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SqlBatchParser.<>c__DisplayClass10_0.b__1(Object sender, SpecialTokenEventArgs evt) at FluentMigrator.Runner.BatchParser.SearchContext.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SearchStatus.FindTokenOrRangeStart() at FluentMigrator.Runner.BatchParser.SearchStatus.Process() at FluentMigrator.Runner.BatchParser.SqlBatchParser.Process(ITextSource source, Boolean stripComments) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) ClientConnectionId:9933e794-9230-4127-b72f-a6569cc2bf7e Error Number:207,State:1,Class:16 ClientConnectionId before routing:6fd20990-1563-46ef-a3e4-4c8a8022befa Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 --- End of inner exception stack trace --- at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Execute(String template, Object[] args) at FluentMigrator.Runner.Processors.ProcessorBase.Execute(String sql) at FluentMigrator.Expressions.ExecuteSqlStatementExpression.ExecuteWith(IMigrationProcessor processor) at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass75_0.b__1() at FluentMigrator.Runner.StopWatch.Time(Action action) at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action) at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) [06.05.2025 15:34:31.763 +00:00 INF] Rolling back transaction [06.05.2025 15:34:31.772 +00:00 INF] ROLLBACK TRANSACTION [06.05.2025 15:35:33.364 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 15:35:34.878 +00:00 INF] Migrations [06.05.2025 15:35:34.918 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 15:35:34.919 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 15:35:34.920 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 15:35:34.921 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 15:35:34.922 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 15:35:34.932 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 15:35:34.933 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 15:35:34.934 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 15:35:34.935 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 15:35:34.936 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 15:35:34.937 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 15:35:34.938 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 15:35:34.939 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 15:35:34.941 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 15:35:34.942 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 15:35:34.942 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 15:35:34.943 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 15:35:34.944 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 15:35:34.945 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 15:35:34.946 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 15:35:34.947 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 15:35:34.949 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 15:35:34.950 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 15:35:34.951 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 15:35:34.952 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 15:35:34.953 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 15:35:34.954 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 15:35:34.955 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 15:35:34.956 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 15:35:34.957 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 15:35:34.958 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 15:35:34.959 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 15:35:34.960 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 15:35:34.961 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 15:35:34.962 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 15:35:34.968 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 15:35:34.982 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 15:35:34.983 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 15:35:34.984 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 15:35:34.986 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 15:35:34.987 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 15:35:34.988 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 15:35:34.989 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 15:35:34.990 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 15:35:34.991 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 15:35:34.995 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 15:35:34.996 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 15:35:34.996 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 15:35:34.997 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 15:35:34.997 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 15:35:34.997 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 15:35:34.997 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 15:35:34.997 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 15:35:34.997 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 15:35:34.997 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 15:35:34.997 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 15:35:34.997 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 15:35:34.998 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP (not applied) [06.05.2025 15:35:34.998 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 15:35:34.998 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 15:35:34.998 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 15:35:34.998 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 15:35:34.998 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 15:35:34.998 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 15:35:35.020 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP migrating [06.05.2025 15:35:35.021 +00:00 INF] Beginning Transaction [06.05.2025 15:35:35.036 +00:00 INF] BEGIN TRANSACTION [06.05.2025 15:35:35.069 +00:00 INF] ExecuteSqlStatement ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:35:35.070 +00:00 INF] ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:35:35.152 +00:00 ERR] An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. System.Exception: An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'slug'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.<>c__DisplayClass38_0.b__1(Object sender, SpecialTokenEventArgs args) at FluentMigrator.Runner.BatchParser.SqlBatchParser.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SqlBatchParser.<>c__DisplayClass10_0.b__1(Object sender, SpecialTokenEventArgs evt) at FluentMigrator.Runner.BatchParser.SearchContext.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SearchStatus.FindTokenOrRangeStart() at FluentMigrator.Runner.BatchParser.SearchStatus.Process() at FluentMigrator.Runner.BatchParser.SqlBatchParser.Process(ITextSource source, Boolean stripComments) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) ClientConnectionId:8bda180a-72ff-4901-8506-33121b833ab2 Error Number:207,State:1,Class:16 ClientConnectionId before routing:e5ddfb0f-1b0f-4754-9f09-d8423953cbcd Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 --- End of inner exception stack trace --- at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Execute(String template, Object[] args) at FluentMigrator.Runner.Processors.ProcessorBase.Execute(String sql) at FluentMigrator.Expressions.ExecuteSqlStatementExpression.ExecuteWith(IMigrationProcessor processor) at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass75_0.b__1() at FluentMigrator.Runner.StopWatch.Time(Action action) at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action) at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) [06.05.2025 15:35:35.184 +00:00 INF] Rolling back transaction [06.05.2025 15:35:35.192 +00:00 INF] ROLLBACK TRANSACTION [06.05.2025 15:36:58.883 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 15:37:00.469 +00:00 INF] Migrations [06.05.2025 15:37:00.499 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 15:37:00.507 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 15:37:00.508 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 15:37:00.509 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 15:37:00.510 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 15:37:00.511 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 15:37:00.512 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 15:37:00.514 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 15:37:00.515 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 15:37:00.516 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 15:37:00.517 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 15:37:00.518 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 15:37:00.519 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 15:37:00.519 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 15:37:00.519 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 15:37:00.519 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 15:37:00.520 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 15:37:00.520 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 15:37:00.520 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 15:37:00.520 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 15:37:00.520 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 15:37:00.520 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 15:37:00.520 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 15:37:00.520 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 15:37:00.520 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 15:37:00.520 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 15:37:00.520 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 15:37:00.520 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 15:37:00.520 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 15:37:00.520 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 15:37:00.520 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 15:37:00.520 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 15:37:00.521 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 15:37:00.521 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 15:37:00.521 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 15:37:00.521 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 15:37:00.521 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 15:37:00.521 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 15:37:00.521 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 15:37:00.521 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 15:37:00.521 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 15:37:00.521 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 15:37:00.521 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 15:37:00.521 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 15:37:00.521 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 15:37:00.521 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 15:37:00.521 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 15:37:00.521 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 15:37:00.522 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 15:37:00.522 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 15:37:00.522 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 15:37:00.522 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 15:37:00.522 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 15:37:00.522 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 15:37:00.522 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 15:37:00.522 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 15:37:00.527 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 15:37:00.528 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP (not applied) [06.05.2025 15:37:00.528 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 15:37:00.528 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 15:37:00.528 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 15:37:00.528 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 15:37:00.528 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 15:37:00.528 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 15:37:00.548 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP migrating [06.05.2025 15:37:00.550 +00:00 INF] Beginning Transaction [06.05.2025 15:37:00.568 +00:00 INF] BEGIN TRANSACTION [06.05.2025 15:37:00.599 +00:00 INF] ExecuteSqlStatement ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:37:00.600 +00:00 INF] ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:37:00.680 +00:00 ERR] An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. System.Exception: An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'slug'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.<>c__DisplayClass38_0.b__1(Object sender, SpecialTokenEventArgs args) at FluentMigrator.Runner.BatchParser.SqlBatchParser.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SqlBatchParser.<>c__DisplayClass10_0.b__1(Object sender, SpecialTokenEventArgs evt) at FluentMigrator.Runner.BatchParser.SearchContext.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SearchStatus.FindTokenOrRangeStart() at FluentMigrator.Runner.BatchParser.SearchStatus.Process() at FluentMigrator.Runner.BatchParser.SqlBatchParser.Process(ITextSource source, Boolean stripComments) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) ClientConnectionId:5b0ae3f4-4cf7-4e0e-8633-16a314f8f369 Error Number:207,State:1,Class:16 ClientConnectionId before routing:46f09e80-a097-45c9-90da-ca5f01bbfb0f Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 --- End of inner exception stack trace --- at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Execute(String template, Object[] args) at FluentMigrator.Runner.Processors.ProcessorBase.Execute(String sql) at FluentMigrator.Expressions.ExecuteSqlStatementExpression.ExecuteWith(IMigrationProcessor processor) at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass75_0.b__1() at FluentMigrator.Runner.StopWatch.Time(Action action) at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action) at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) [06.05.2025 15:37:00.709 +00:00 INF] Rolling back transaction [06.05.2025 15:37:00.719 +00:00 INF] ROLLBACK TRANSACTION [06.05.2025 15:37:48.677 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 15:37:50.275 +00:00 INF] Migrations [06.05.2025 15:37:50.315 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 15:37:50.316 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 15:37:50.317 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 15:37:50.318 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 15:37:50.325 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 15:37:50.327 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 15:37:50.329 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 15:37:50.334 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 15:37:50.335 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 15:37:50.336 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 15:37:50.343 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 15:37:50.345 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 15:37:50.346 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 15:37:50.350 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 15:37:50.351 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 15:37:50.352 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 15:37:50.353 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 15:37:50.354 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 15:37:50.356 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 15:37:50.357 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 15:37:50.358 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 15:37:50.359 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 15:37:50.360 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 15:37:50.361 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 15:37:50.363 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 15:37:50.364 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 15:37:50.365 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 15:37:50.366 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 15:37:50.367 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 15:37:50.367 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 15:37:50.367 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 15:37:50.367 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 15:37:50.368 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 15:37:50.368 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 15:37:50.368 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 15:37:50.368 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 15:37:50.368 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 15:37:50.368 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 15:37:50.368 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 15:37:50.368 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 15:37:50.368 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 15:37:50.368 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 15:37:50.368 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 15:37:50.368 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 15:37:50.368 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 15:37:50.369 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 15:37:50.369 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 15:37:50.369 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 15:37:50.369 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 15:37:50.369 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 15:37:50.369 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 15:37:50.369 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 15:37:50.369 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 15:37:50.369 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 15:37:50.369 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 15:37:50.369 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 15:37:50.370 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 15:37:50.370 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP (not applied) [06.05.2025 15:37:50.374 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 15:37:50.374 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 15:37:50.375 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 15:37:50.375 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 15:37:50.375 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 15:37:50.375 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 15:37:50.395 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP migrating [06.05.2025 15:37:50.396 +00:00 INF] Beginning Transaction [06.05.2025 15:37:50.414 +00:00 INF] BEGIN TRANSACTION [06.05.2025 15:37:50.448 +00:00 INF] ExecuteSqlStatement ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:37:50.449 +00:00 INF] ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:37:50.527 +00:00 ERR] An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. System.Exception: An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'slug'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.<>c__DisplayClass38_0.b__1(Object sender, SpecialTokenEventArgs args) at FluentMigrator.Runner.BatchParser.SqlBatchParser.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SqlBatchParser.<>c__DisplayClass10_0.b__1(Object sender, SpecialTokenEventArgs evt) at FluentMigrator.Runner.BatchParser.SearchContext.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SearchStatus.FindTokenOrRangeStart() at FluentMigrator.Runner.BatchParser.SearchStatus.Process() at FluentMigrator.Runner.BatchParser.SqlBatchParser.Process(ITextSource source, Boolean stripComments) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) ClientConnectionId:873ddf93-1b6b-4579-ac19-bace6593f031 Error Number:207,State:1,Class:16 ClientConnectionId before routing:60585ab3-5ccd-4273-98ca-5dd04b4da405 Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 --- End of inner exception stack trace --- at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Execute(String template, Object[] args) at FluentMigrator.Runner.Processors.ProcessorBase.Execute(String sql) at FluentMigrator.Expressions.ExecuteSqlStatementExpression.ExecuteWith(IMigrationProcessor processor) at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass75_0.b__1() at FluentMigrator.Runner.StopWatch.Time(Action action) at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action) at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) [06.05.2025 15:37:50.551 +00:00 INF] Rolling back transaction [06.05.2025 15:37:50.559 +00:00 INF] ROLLBACK TRANSACTION [06.05.2025 15:38:31.644 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 15:38:33.230 +00:00 INF] Migrations [06.05.2025 15:38:33.272 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 15:38:33.273 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 15:38:33.274 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 15:38:33.275 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 15:38:33.276 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 15:38:33.277 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 15:38:33.278 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 15:38:33.282 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 15:38:33.282 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 15:38:33.283 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 15:38:33.284 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 15:38:33.285 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 15:38:33.286 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 15:38:33.287 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 15:38:33.288 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 15:38:33.289 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 15:38:33.290 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 15:38:33.291 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 15:38:33.292 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 15:38:33.292 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 15:38:33.293 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 15:38:33.294 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 15:38:33.295 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 15:38:33.296 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 15:38:33.296 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 15:38:33.297 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 15:38:33.298 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 15:38:33.299 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 15:38:33.300 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 15:38:33.301 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 15:38:33.302 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 15:38:33.304 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 15:38:33.305 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 15:38:33.307 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 15:38:33.308 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 15:38:33.309 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 15:38:33.309 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 15:38:33.310 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 15:38:33.311 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 15:38:33.312 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 15:38:33.313 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 15:38:33.314 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 15:38:33.319 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 15:38:33.320 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 15:38:33.321 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 15:38:33.321 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 15:38:33.321 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 15:38:33.321 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 15:38:33.321 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 15:38:33.321 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 15:38:33.321 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 15:38:33.321 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 15:38:33.321 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 15:38:33.321 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 15:38:33.322 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 15:38:33.322 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 15:38:33.322 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 15:38:33.322 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP (not applied) [06.05.2025 15:38:33.322 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 15:38:33.322 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 15:38:33.322 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 15:38:33.322 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 15:38:33.322 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 15:38:33.322 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 15:38:33.337 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP migrating [06.05.2025 15:38:33.338 +00:00 INF] Beginning Transaction [06.05.2025 15:38:33.356 +00:00 INF] BEGIN TRANSACTION [06.05.2025 15:38:33.393 +00:00 INF] ExecuteSqlStatement ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:38:33.394 +00:00 INF] ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:38:33.478 +00:00 ERR] An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. System.Exception: An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'slug'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.<>c__DisplayClass38_0.b__1(Object sender, SpecialTokenEventArgs args) at FluentMigrator.Runner.BatchParser.SqlBatchParser.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SqlBatchParser.<>c__DisplayClass10_0.b__1(Object sender, SpecialTokenEventArgs evt) at FluentMigrator.Runner.BatchParser.SearchContext.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SearchStatus.FindTokenOrRangeStart() at FluentMigrator.Runner.BatchParser.SearchStatus.Process() at FluentMigrator.Runner.BatchParser.SqlBatchParser.Process(ITextSource source, Boolean stripComments) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) ClientConnectionId:1b8894ff-7217-414a-9a9d-1d0ccb6a3047 Error Number:207,State:1,Class:16 ClientConnectionId before routing:fdcd92c2-5054-4aa5-a445-35133da90cb1 Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 --- End of inner exception stack trace --- at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Execute(String template, Object[] args) at FluentMigrator.Runner.Processors.ProcessorBase.Execute(String sql) at FluentMigrator.Expressions.ExecuteSqlStatementExpression.ExecuteWith(IMigrationProcessor processor) at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass75_0.b__1() at FluentMigrator.Runner.StopWatch.Time(Action action) at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action) at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) [06.05.2025 15:38:33.518 +00:00 INF] Rolling back transaction [06.05.2025 15:38:33.524 +00:00 INF] ROLLBACK TRANSACTION [06.05.2025 15:39:12.284 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 15:39:13.815 +00:00 INF] Migrations [06.05.2025 15:39:13.854 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 15:39:13.856 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 15:39:13.857 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 15:39:13.858 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 15:39:13.859 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 15:39:13.860 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 15:39:13.861 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 15:39:13.862 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 15:39:13.863 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 15:39:13.864 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 15:39:13.865 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 15:39:13.865 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 15:39:13.865 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 15:39:13.865 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 15:39:13.865 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 15:39:13.866 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 15:39:13.866 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 15:39:13.866 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 15:39:13.866 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 15:39:13.866 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 15:39:13.866 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 15:39:13.866 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 15:39:13.866 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 15:39:13.866 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 15:39:13.866 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 15:39:13.866 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 15:39:13.866 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 15:39:13.866 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 15:39:13.866 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 15:39:13.867 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 15:39:13.867 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 15:39:13.867 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 15:39:13.867 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 15:39:13.867 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 15:39:13.867 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 15:39:13.867 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 15:39:13.867 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 15:39:13.867 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 15:39:13.867 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 15:39:13.867 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 15:39:13.867 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 15:39:13.867 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 15:39:13.867 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 15:39:13.867 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 15:39:13.867 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 15:39:13.867 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 15:39:13.867 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 15:39:13.867 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 15:39:13.867 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 15:39:13.867 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 15:39:13.868 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 15:39:13.868 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 15:39:13.868 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 15:39:13.868 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 15:39:13.868 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 15:39:13.868 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 15:39:13.868 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 15:39:13.868 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP (not applied) [06.05.2025 15:39:13.868 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 15:39:13.868 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 15:39:13.868 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 15:39:13.868 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 15:39:13.868 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 15:39:13.874 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 15:39:13.887 +00:00 INF] 20250506160001: _20250506160001_UpdateOrderGetAllByStatusSP migrating [06.05.2025 15:39:13.895 +00:00 INF] Beginning Transaction [06.05.2025 15:39:13.907 +00:00 INF] BEGIN TRANSACTION [06.05.2025 15:39:13.937 +00:00 INF] ExecuteSqlStatement ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:39:13.945 +00:00 INF] ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END GO [06.05.2025 15:39:14.025 +00:00 ERR] An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. System.Exception: An error occurred executing the following sql: ALTER PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2), @status int = null, @categorySlug varchar(256) = null ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId OR pc.Slug = @categorySlug UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId OR ct.slug = pc.Slug) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo + '#' + pc.DefaultImageUrl FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id JOIN dbo.ProductCategories P ON P.Id = oi.ProductCategoryId JOIN dbo.TextContents C ON C.Id = P.TextContentId JOIN dbo.Translations tr ON C.Id = tr.TextContentId WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL OR tr.TranslationInfo LIKE '%' + @productName + '%') AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (@status IS NULL OR o.Status = @status) AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND o.Status in (3, 4) END The error was Invalid column name 'slug'. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'slug'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.<>c__DisplayClass38_0.b__1(Object sender, SpecialTokenEventArgs args) at FluentMigrator.Runner.BatchParser.SqlBatchParser.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SqlBatchParser.<>c__DisplayClass10_0.b__1(Object sender, SpecialTokenEventArgs evt) at FluentMigrator.Runner.BatchParser.SearchContext.OnSpecialToken(SpecialTokenEventArgs e) at FluentMigrator.Runner.BatchParser.SearchStatus.FindTokenOrRangeStart() at FluentMigrator.Runner.BatchParser.SearchStatus.Process() at FluentMigrator.Runner.BatchParser.SqlBatchParser.Process(ITextSource source, Boolean stripComments) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) ClientConnectionId:65199d1c-8c58-4169-bb1d-2b4ad8fbafbf Error Number:207,State:1,Class:16 ClientConnectionId before routing:fb1e6880-15c5-45e8-a942-20ddcef55f1f Routing Destination:ba1573cfd8e8.tr712.uaenorth1-a.worker.database.windows.net,11013 --- End of inner exception stack trace --- at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteBatchNonQuery(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql) at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Execute(String template, Object[] args) at FluentMigrator.Runner.Processors.ProcessorBase.Execute(String sql) at FluentMigrator.Expressions.ExecuteSqlStatementExpression.ExecuteWith(IMigrationProcessor processor) at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass75_0.b__1() at FluentMigrator.Runner.StopWatch.Time(Action action) at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action) at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) [06.05.2025 15:39:14.055 +00:00 INF] Rolling back transaction [06.05.2025 15:39:14.061 +00:00 INF] ROLLBACK TRANSACTION [06.05.2025 16:08:11.495 +00:00 INF] Starting Detection version 8.14.0.0 [06.05.2025 16:08:13.030 +00:00 INF] Migrations [06.05.2025 16:08:13.069 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [06.05.2025 16:08:13.070 +00:00 INF] 20240229001: Migration_GetAllByStatus [06.05.2025 16:08:13.071 +00:00 INF] 20240229002: Migration_GetAll [06.05.2025 16:08:13.072 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [06.05.2025 16:08:13.077 +00:00 INF] 20240105195988: Migration_20240105195988 [06.05.2025 16:08:13.081 +00:00 INF] 20240106150801: Migration_20240106150801 [06.05.2025 16:08:13.084 +00:00 INF] 20240222282856: Migration_20240222282856 [06.05.2025 16:08:13.085 +00:00 INF] 20240225185332: Migration_20240225185332 [06.05.2025 16:08:13.086 +00:00 INF] 20240226001548: Migration_20240226001548 [06.05.2025 16:08:13.087 +00:00 INF] 20240229112234: Migration_20240229112234 [06.05.2025 16:08:13.088 +00:00 INF] 20240404234500: Migration_20240404234500 [06.05.2025 16:08:13.089 +00:00 INF] 20240411223124: Migration_20240411223124 [06.05.2025 16:08:13.090 +00:00 INF] 20240411233788: Migration_20240411233788 [06.05.2025 16:08:13.091 +00:00 INF] 20240416180711: Migration_20240416180711 [06.05.2025 16:08:13.092 +00:00 INF] 20240418235744: Migration_20240418235744 [06.05.2025 16:08:13.093 +00:00 INF] 20240422204700: Migration_20240422204700 [06.05.2025 16:08:13.094 +00:00 INF] 20240424002834: Migration_20240424002834 [06.05.2025 16:08:13.095 +00:00 INF] 20240522120865: Migration_20240522120865 [06.05.2025 16:08:13.096 +00:00 INF] 20240605165234: Migration_20240605165234 [06.05.2025 16:08:13.097 +00:00 INF] 20240607133587: Migration_20240607133587 [06.05.2025 16:08:13.098 +00:00 INF] 20240621144023: Migration_20240621144023 [06.05.2025 16:08:13.099 +00:00 INF] 20240622160323: Migration_20240622160323 [06.05.2025 16:08:13.100 +00:00 INF] 20240624180224: Migration_20240624180224 [06.05.2025 16:08:13.100 +00:00 INF] 20240703175787: Migration_20240703175787 [06.05.2025 16:08:13.101 +00:00 INF] 20240709130523: Migration_20240709130523 [06.05.2025 16:08:13.102 +00:00 INF] 20240725213744: Migration_20240725213744 [06.05.2025 16:08:13.103 +00:00 INF] 20240726111626: Migration_20240726111626 [06.05.2025 16:08:13.103 +00:00 INF] 20240728152901: Migration_20240728152901 [06.05.2025 16:08:13.103 +00:00 INF] 20240804210998: Migration_20240804210998 [06.05.2025 16:08:13.103 +00:00 INF] 20240816175945: Migration_20240816175945 [06.05.2025 16:08:13.103 +00:00 INF] 20240817174587: Migration_20240817174587 [06.05.2025 16:08:13.103 +00:00 INF] 20240822233401: Migration_20240822233401 [06.05.2025 16:08:13.103 +00:00 INF] 20240903132456: Migration_20240903132456 [06.05.2025 16:08:13.103 +00:00 INF] 20240903164034: Migration_20240903164034 [06.05.2025 16:08:13.103 +00:00 INF] 20240908142505: Migration_20240908142505 [06.05.2025 16:08:13.103 +00:00 INF] 20240924104345: Migration_20240924104345 [06.05.2025 16:08:13.103 +00:00 INF] 20240926102006: Migration_20240926102006 [06.05.2025 16:08:13.104 +00:00 INF] 20240929152890: Migration_20240929152890 [06.05.2025 16:08:13.104 +00:00 INF] 20240929154431: Migration_20240929154431 [06.05.2025 16:08:13.104 +00:00 INF] 20240929172067: Migration_20240929172067 [06.05.2025 16:08:13.104 +00:00 INF] 20240930165689: Migration_20240930165689 [06.05.2025 16:08:13.104 +00:00 INF] 20241003130612: Migration_20241003130612 [06.05.2025 16:08:13.104 +00:00 INF] 20241003184355: Migration_20241003184355 [06.05.2025 16:08:13.104 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [06.05.2025 16:08:13.104 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [06.05.2025 16:08:13.104 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [06.05.2025 16:08:13.104 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [06.05.2025 16:08:13.104 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [06.05.2025 16:08:13.104 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [06.05.2025 16:08:13.104 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [06.05.2025 16:08:13.104 +00:00 INF] 20242403195365: Migration_20242403195365 [06.05.2025 16:08:13.104 +00:00 INF] 20242403210101: Migration_20242403210101 [06.05.2025 16:08:13.104 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [06.05.2025 16:08:13.104 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [06.05.2025 16:08:13.104 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [06.05.2025 16:08:13.104 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [06.05.2025 16:08:13.104 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [06.05.2025 16:08:13.104 +00:00 INF] 20250506160002: _20250506160002_UpdateOrderGetAllByStatusSP [06.05.2025 16:08:13.104 +00:00 INF] 202403091170645: Migration_202403091170645 [06.05.2025 16:08:13.105 +00:00 INF] 202404032111114: Migration_20240403211111 [06.05.2025 16:08:13.105 +00:00 INF] 2024032122165643: Migration_2024032122165643 [06.05.2025 16:08:13.105 +00:00 INF] 2024040820368776: Migration_2024040820368776 [06.05.2025 16:08:13.105 +00:00 INF] 2024042112358764: Migration_2024042112358764 [06.05.2025 16:08:13.105 +00:00 INF] 2024110406487223: Migration_2024110406487223 [06.05.2025 16:08:14.859 +00:00 INF] 0HNCCN0QEGPNI:00000001 /robots933456.txt called [06.05.2025 16:08:15.596 +00:00 INF] 0HNCCN0QEGPNJ:00000001 /robots933456.txt called [06.05.2025 16:08:16.582 +00:00 INF] 0HNCCN0QEGPNK:00000001 /robots933456.txt called [06.05.2025 16:08:17.583 +00:00 INF] 0HNCCN0QEGPNL:00000001 /robots933456.txt called [06.05.2025 16:08:18.685 +00:00 INF] 0HNCCN0QEGPNM:00000001 /robots933456.txt called [06.05.2025 16:08:19.162 +00:00 INF] 0HNCCN0QEGPNO:00000001 /api/SiteSetting/GetByNameAsync called [06.05.2025 16:08:19.164 +00:00 INF] 0HNCCN0QEGPNN:00000001 /api/ProductCategory/GetHierarchy called [06.05.2025 16:08:20.833 +00:00 INF] 0HNCCN0QEGPNN:00000002 /api/Order/GetAllByStatus called [06.05.2025 16:08:21.251 +00:00 INF] 0HNCCN0QEGPNN:00000003 /api/FavouriteOrder/GetAllByUserId called [06.05.2025 16:08:22.223 +00:00 INF] 0HNCCN0QEGPNN:00000005 /api/Account/GetUserData called [06.05.2025 16:08:23.567 +00:00 INF] 0HNCCN0QEGPNO:00000003 /api/SiteSetting/GetEnumValues called [06.05.2025 16:08:23.572 +00:00 INF] 0HNCCN0QEGPNQ:00000001 /api/ProductCategory/populars/0/3 called [06.05.2025 16:08:23.572 +00:00 INF] 0HNCCN0QEGPNP:00000001 /api/Notification/GetAllByToUserId/0/8 called [06.05.2025 16:08:23.743 +00:00 INF] 0HNCCN0QEGPNR:00000001 /api/UserCoupon/getForCurrentUser called