Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogCouple of blog issuesCouple of blog issues
Previous
 
Next
New Post
1/12/2006 7:40 PM
 

DNN 4.00.2  Blog 3.01.20

1. If a new blog is created, the content of that blog doesn't show up in "Most Recent Blog Entries".  It isn't until a 2nd entry is added that it shows up there.

2. Somehow one of my users created a blog twice.  How do I combine them to one blog?

 

Thanks,

James

 
New Post
1/13/2006 1:44 AM
 

James,

1. Could you reprocure that problem. I don't !. If yes, could you exactly describe step by step how the problem occur.

2. Not sure what happens on your installation but a user is only able to create one blog. Please look at the database whether there are two blogs with the same user id.

Does the portal run without problems with other modules and or the core feature.

Your problems sounds a little bit like a problem with your installation what effects the blog module.

regards

HP


Best regards
Hans-Peter Schelian
www.schelian.com (English)
German DotNetNuke Community
 
New Post
1/13/2006 9:16 PM
 

If you like, check out http://www.mhs87.com/Blogs/tabid/61/Default.aspx

Issue 1 you can see in the "Most recent blog entries" there are only entries for myself and Kym's 2nd post.  There are none for 1st posts other then the very first one I created.

Issue 2 you can see under the list.  There are two entries from Edwina.  I think what happened was I was rebuilding the site while she was posting and that kicked her off, but some how save the blog.  I'll see if there are dupe entries (need to run right now).

Thanks,

James

 
New Post
1/20/2006 9:24 PM
 

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 ---

 
New Post
1/23/2006 11:51 PM
 

I finally got a chance to look in the database and I do have duplicate rows:

PortalID BlogID UserID Title Description Public AllowComments AllowAnonymous LastEntry Created ShowFullName DateFormat Culture TimeZone ParentBlogID Syndicated SyndicateIndependant SyndicationURL SyndicationEmail EmailNotification
0 7 12 Sherry (Kennedy) Edwards What I have been doing! True True False   1/20/2006 8:27:43 PM False g en-US -8 -1 False False     False
0 8 12 Sherry's Bad blog Need to delete False False False   1/20/2006 8:28:07 PM False g en-US -8 -1 False False     False

To fix this problem, can I just run "Sql delete from dbo.Blog_Blogs where BlogID = 8"?

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogCouple of blog issuesCouple of blog issues


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out