SqlCE error publishing a blog comment

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
1/27/2013 7:17:41 PM
Gravatar
Total Posts 1

SqlCE error publishing a blog comment

What operating system? Windows Home Server 2011 (essentially Windows Server 2008)

What database platform? SQL CE

What version of mojoPortal? 2.3.9.4 SqlCe

What version of .NET? 4.0 (possibly 4.5)

Steps to produce the problem, expected results, and actual results.

I'm running multiple sites with UseRelatedSiteMode = true, and site-specific Mail settings. Otherwise, a default installation using Web Platform Installer.

Our blogs on any site are configured to allow comments and require approval. When we get a comment and click Publish, we get an error. I temporarily disabled customErrors in web.config. Below is the full stack trace.

[IndexOutOfRangeException: An SqlCeParameter with ParameterName 'ParentGuid' is not contained by this SqlCeParameterCollection.]
   System.Data.SqlServerCe.SqlCeParameterCollection.ThrowParamterNotFoundException(String parameterName) +222
   System.Data.SqlServerCe.SqlCeParameterCollection.get_Item(String parameterName) +32
   System.Data.SqlServerCe.SqlCeCommand.CreateParameterAccessor(MetaData[] metadata) +190
   System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() +1321
   System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) +362
   System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() +44
   mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +205
   mojoPortal.Data.DBComments.Update(Guid guid, Guid userGuid, String title, String userComment, String userName, String userEmail, String userUrl, String userIp, DateTime lastModUtc, Byte moderationStatus, Guid moderatedBy, String moderationReason) +2053
   mojoPortal.Business.CommentRepository.Save(Comment comment) +1556
   mojoPortal.Web.UI.CommentsWidget.rptComments_ItemCommand(Object source, RepeaterCommandEventArgs e) +246
   System.Web.UI.WebControls.Repeater.OnBubbleEvent(Object sender, EventArgs e) +55
   System.Web.UI.WebControls.RepeaterItem.OnBubbleEvent(Object source, EventArgs e) +164
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +52
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707

1/28/2013 10:19:00 AM
Gravatar
Total Posts 18439

Re: SqlCE error publishing a blog comment

Hi,

Thanks for the bug report.

This is now fixed in the source code repository so it will be fixed in the next release coming soon. I've also emailed you an updated version of mojoPortal.Data.dll that should solve it for you right away.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.