YAFNET: Exception when deleting all private messages
In the latest source under: User Menu > My Inbox > Sent Items > Delete All throws the following exception:
Exception of type 'System.Web.HttpUnhandledException' was thrown. (User-IP: 127.0.0.1 | URL:'http://localhost:50165/Default.aspx?g=MyMessages') System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException (0x80131904): An expression of non-boolean type specified in a context where a condition is expected, near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at ServiceStack.OrmLite.OrmLiteCommand.ExecuteReader() in C:'Users'User'Desktop'yafsrc'ServiceStack'ServiceStack.OrmLite'OrmLiteCommand.cs:line 108 at ServiceStack.OrmLite.OrmLiteReadCommandExtensions.ExecReader(IDbCommand dbCmd, String sql) in C:'Users'User'Desktop'yafsrc'ServiceStack'ServiceStack.OrmLite'OrmLiteReadCommandExtensions.cs:line 59 at ServiceStack.OrmLite.OrmLiteResultsFilterExtensions.ExprConvertToList[T](IDbCommand dbCmd, String sql, IEnumerable
1 sqlParams, HashSet1 onlyFields) in C:'Users'User'Desktop'yafsrc'ServiceStack'ServiceStack.OrmLite'OrmLiteResultsFilterExtensions.cs:line 209 at ServiceStack.OrmLite.ReadExpressionCommandExtensions.Select[T](IDbCommand dbCmd, Expression
1 predicate) in C:'Users’User’Desktop’yafsrc’ServiceStack’ServiceStack.OrmLite’Expressions’ReadExpressionCommandExtensions.cs:line 47
at ServiceStack.OrmLite.OrmLiteReadExpressionsApi.<>c__DisplayClass30_01.<Select>b__0(IDbCommand dbCmd) in C:'Users'User'Desktop'yafsrc'ServiceStack'ServiceStack.OrmLite'OrmLiteReadExpressionsApi.cs:line 418 at ServiceStack.OrmLite.OrmLiteExecFilter.Exec[T](IDbConnection dbConn, Func
2 filter) in C:'Users’User’Desktop’yafsrc’ServiceStack’ServiceStack.OrmLite’OrmLiteExecFilter.cs:line 177
at ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Exec[T](IDbConnection dbConn, Func2 filter) in C:'Users'User'Desktop'yafsrc'ServiceStack'ServiceStack.OrmLite'OrmLiteReadExpressionsApi.cs:line 33 at ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Select[T](IDbConnection dbConn, Expression
1 predicate) in C:'Users’User’Desktop’yafsrc’ServiceStack’ServiceStack.OrmLite’OrmLiteReadExpressionsApi.cs:line 418
at YAF.Core.Extensions.IRepositoryExtensions.<>c__DisplayClass16_01.<Get>b__0(IDbCommand db) in C:'Users'User'Desktop'yafsrc'YAF.Core'Extensions'IRepositoryExtensions.cs:line 495 at YAF.Core.Data.DbAccessBase.Execute[T](Func
2 execFunc, IDbCommand cmd, IDbTransaction dbTransaction) in C:'Users’User’Desktop’yafsrc’YAF.Core’Data’DbAccessBase.cs:line 99
at YAF.Core.Extensions.IRepositoryExtensions.Get[T](IRepository1 repository, Expression
1 criteria) in C:'Users’User’Desktop’yafsrc’YAF.Core’Extensions’IRepositoryExtensions.cs:line 495
at YAF.Controls.PMList.DeleteAll_Click(Object source, EventArgs e) in C:'Users’User’Desktop’yafsrc’YetAnotherForum.NET’Controls’PMList.ascx.cs:line 173
at YAF.Web.Controls.ThemeButton.OnClick(EventArgs e) in C:'Users’User’Desktop’yafsrc’YAF.Web’Controls’ThemeButton.cs:line 703
at YAF.Web.Controls.ThemeButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) in C:'Users’User’Desktop’yafsrc’YAF.Web’Controls’ThemeButton.cs:line 429
at System.Web.UI.Page.<ProcessRequestMainAsync>d__523.MoveNext()
ClientConnectionId:d4ebab83-603b-4ec8-8122-62fcf6b4cf17
Error Number:4145,State:1,Class:15
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.<ProcessRequestMainAsync>d__523.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Util.WithinCancellableCallbackTaskAwaitable.WithinCancellableCallbackTaskAwaiter.GetResult()
at System.Web.UI.Page.<ProcessRequestAsync>d__515.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.UI.Page.<ProcessRequestAsync>d__554.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.TaskAsyncHelper.EndTask(IAsyncResult ar)
at ASP.default_aspx.EndProcessRequest(IAsyncResult ar) in c:'Users’User’AppData’Local’Temp’Temporary ASP.NET Files’vs’90b5084c’e86377db’App_Web_psddbh2t.2.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)`
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 21 (10 by maintainers)
Commits related to this issue
- [FIXED #766] wrong delete all count — committed to YAFNET/YAFNET by w8tcha 2 years ago
The count for both inbox and outbox should be correct now
Okay found the problem. Issue(s) should be fixed now