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, Action1 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, IEnumerable1 sqlParams, HashSet1 onlyFields) in C:'Users'User'Desktop'yafsrc'ServiceStack'ServiceStack.OrmLite'OrmLiteResultsFilterExtensions.cs:line 209 at ServiceStack.OrmLite.ReadExpressionCommandExtensions.Select[T](IDbCommand dbCmd, Expression1 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, Func2 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, Expression1 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](Func2 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, Expression1 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

Most upvoted comments

The count for both inbox and outbox should be correct now

Okay found the problem. Issue(s) should be fixed now