Guest Checkout Error

[roadkill]

I am getting this error show at times when people are using Guest Checkout. Suggestions???

I have Gold R6

Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.checkout_editbilladdress_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\a3abb1a9\12748306\App_Web_bztnxnup.8.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: could not execute native bulk manipulation query:update ac_OrderNotes set UserId = :newUserId where UserId = :oldUserId[SQL: update ac_OrderNotes set UserId = @p0 where UserId = @p1] Inner Exception Stack Trace: at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at CommerceBuilder.Orders.OrderRepository.UpdateUser(Int32 oldUserId, Int32 newUserId) at CommerceBuilder.Users.User.Migrate(User oldUser, User newUser, Boolean includeOrderData, Boolean isNewUserAccount) at AbleCommerce.Checkout.EditBillAddress.BillingPageContinue_Click(Object sender, EventArgs e) in d:\Websites\BadIdeaTShirts\Checkout\EditBillAddress.aspx.cs:line 89 at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not execute native bulk manipulation query:update ac_OrderNotes set UserId = :newUserId where UserId = :oldUserId[SQL: update ac_OrderNotes set UserId = @p0 where UserId = @p1] Inner Exception Stack Trace: at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at CommerceBuilder.Orders.OrderRepository.UpdateUser(Int32 oldUserId, Int32 newUserId) at CommerceBuilder.Users.User.Migrate(User oldUser, User newUser, Boolean includeOrderData, Boolean isNewUserAccount) at AbleCommerce.Checkout.EditBillAddress.BillingPageContinue_Click(Object sender, EventArgs e) in d:\Websites\BadIdeaTShirts\Checkout\EditBillAddress.aspx.cs:line 89 at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[mazhar]

A suggestion was posted in this thread viewtopic.php?f=65&t=17950