Hi

I am getting this error in the New blog module.

An error has occurred.
Error: New Blog is currently unavailable.

I tried for the solution given for Editentry  i.e replacing "e" in line 21 but still the problem

persists.Observed that this error is occuring for only those users who delete thier parent blog and try to create

it again.I will explain in brief when this error is coming

1).While creating New parent Blog after filling all the fields and  clicking Add for adding a new child, if the user does not fill any fields in the child blog creation and clicks cancel it redirects to the parent blog creation page where all the fields get refreshed now i fill all the fields again and click update then the above error comes.

2).When i repeat above step in other scenario i.e create new parent Blog after filling all the fields , I click Add for adding a new child and i dont fill any fields in the child blog creation and click cancel it redirects to the parent blog creation page where all the fields get refreshed now I dont fill any details in the refreshed fields of the parent blog and just click update then everything works fine .

can someone please tell me what is the reason for this exception and where can i fix it.

Thanks in advance.

Hi

Please find the Log entry below ,Getting this Exception in NewBlog Module in blogs page.

ModuleId: 722
ModuleDefId: 95
FriendlyName: New Blog
ModuleControlSource: DesktopModules/Blog/Blog.ascx
AssemblyVersion: 04.03.07
PortalID: 0
PortalName: SemanticSpace
UserID: 8
UserName: semanticindia\sirisha krothapalli
ActiveTabID: 173
ActiveTabName: Blogs
RawURL: /Gallery/Blogs/tabid/173/Default.aspx?BlogID=20
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://10.10.200.180/Gallery/Blogs/tabid/173/ctl/Login/Default.aspx?returnurl=%2fGallery%2fBlogs%2ftabid%2f173%2fDefault.aspx%3fBlogID%3d20
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; IEMB3; .NET CLR 1.1.4322; .NET CLR 2.0.50727; IEMB3)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 6a4b19dd-ed92-468e-8745-e90d14c5d6f4
InnerException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
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 ---

Thanks in advance.

yes i have access to my database and please let me know how can i contact tony .

Thanks