This happened again and a resulting Exception was logged about the same time (a symptom afterwards I believe based on the error). Can you provide the details on the tables so I can look to see if there are duplicate entries in the tables?
Thanks, James
ModuleId: 386
ModuleDefId: 110
FriendlyName: New_Blog
ModuleControlSource: DesktopModules/Blog/Blog.ascx
AssemblyVersion: 04.00.02
Method: System.Data.SqlClient.SqlConnection.OnError
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: 0
PortalName: Meadowdale High School Class of 1987
UserID: 12
UserName: SherryKennedy
ActiveTabID: 61
ActiveTabName: Blogs
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.mhs87.com/Blogs/tabid/61/ctl/Edit_Blog/mid/386/BlogID/-1/Default.aspx
ExceptionGUID: d415d03d-3542-464c-84af-0f2b9010605b
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. ---> System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.GetBlogByUserID(Int32 PortalID, Int32 UserID) at DotNetNuke.Modules.Blog.Business.BlogController.GetBlogByUserID(Int32 PortalID, Int32 UserID) at DotNetNuke.Modules.Blog.Blog.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---