{"data":{"exception":"PostgresException","message":"42601: syntax error at or near \"OR\"\n\nPOSITION: 3354","helpLink":null,"data":{"severity":"ERROR","invariantSeverity":"ERROR","sqlState":"42601","messageText":"syntax error at or near \"OR\"","position":3354,"file":"scan.l","line":"1241","routine":"scanner_yyerror"},"source":"Npgsql","stackTrace":" at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\n at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\n at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 418\n at SqlKata.Execution.QueryFactory.GetAsync[T](Query query, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)\n at SqlKata.Execution.QueryExtensions.GetAsync[T](Query query, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)\n at SqlKata.Execution.QueryExtensions.GetAsync(Query query, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)\n at Redsand.Site.Api.FbConversationController.GetConversations(FBConversationFilter filter) in E:\\redsand\\BaseV2-Net6\\Api\\Nobichat\\ConversationController.cs:line 627\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)","inner":null},"status":400,"statusText":"","headers":{"cache-control":"no-store","content-type":"application/json; charset=utf-8","date":"Sun, 14 Dec 2025 11:17:27 GMT","expires":"0","pragma":"no-cache","server":"nginx/1.28.0"},"config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http","fetch"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json","Authorization":"Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjgwIiwiaHR0cDovL3NjaGVtYXMueG1sc29hcC5vcmcvd3MvMjAwNS8wNS9pZGVudGl0eS9jbGFpbXMvbmFtZSI6IjA5MzYwMTQxMTEiLCJBc3BOZXQuSWRlbnRpdHkuU2VjdXJpdHlTdGFtcCI6IlVOVFZNT0xKRlBOUktPTkNRVkJYVUFFTFpSUUxaQzdEIiwic3ViIjoiMDkzNjAxNDExMSIsImp0aSI6ImFmZDllZmExLTAzMzAtNGViMy05YzkyLWY5NGE0Njc4MDA3YyIsImlhdCI6MTc2NTY4NjI3NCwiaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS93cy8yMDA4LzA2L2lkZW50aXR5L2NsYWltcy9yb2xlIjpbIjMtbmhhbi12aWVuLWtpbmgtZG9hbmgiLCIxMS1uaGFuLXZpZW4tYmFuLWhhbmciXSwibmJmIjoxNzY1Njg2Mjc0LCJleHAiOjE3NjU3NzI2NzQsImlzcyI6IlJTIiwiYXVkIjoiUlMifQ.Sqt7BroQ8d2EV-nByHZ9fBw7KJQcJPCkj9qOP0Oc8C0","ContentType":"application/json","x-hour-offset":"7","BranchId":"7","Locale":"vi"},"baseURL":"https://zito.ecrm.vn","paramsSerializer":{},"params":{"searchTarget":"customer","offset":0,"facebook":[],"zalo":[],"shopee":[],"lazada":[],"tiktok":[],"zaloProfile":[4],"instagram":[]},"signal":{},"method":"get","url":"/api/conversations"},"request":{}}