Hi Stephen,

I have the following problem.

- Customer makes order and register with email address as account name.
- Customer use the following emails address "name@name.nl " (See the space at the end)
 

When I try to add a pyment then the email address give a error.
I have removed the space at the end on the email address in the user accounts of dnn.
However this space is not removed in the order.

Now the order has 2 email adresses and does not respnd on changing any order, payment or shipping status.
I cannot remove this order.

Do you have a suggestion?
(see below the error in the eventlog)

Regards, Ton

---------------------------------------------------

AbsoluteURL:/Default.aspx
DefaultDataProviderotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:4fa31b01-6c55-4f9f-b653-611ed180042a
AssemblyVersion:8.0.4
PortalId:0
UserId:1773
TabId:718

RawUrl:/nl-nl/Shop-Kantoor?rvdsfpt=Sales-SalesOrderControl&rvdsfsppvi=0&rvdsfspsortdrt=1&rvdsfspsortexp=PaymentDate&language=nl-NL&rvdsfsoid=1770&returnurl=%2fnl-nl%2fShop-Kantoor%3frvdsfpt%3dSales-SalesOrderControl%26rvdsfsopvi%3d0%26rvdsfsopvs%3d10%26rvdsfsosortdrt

Referrer:https://www.mywebsite.com...vdsfsopvi%3d0%26rvds

UserAgent:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36

ExceptionHash:Caxn+M8AOd3Eh9M6C6kKdg==

Message:The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_Revindex_Storefront_SalesPayment_Revindex_Storefront_SalesPayment". The conflict occurred in database "DB4825_waterman", table "dbo.Revindex_Storefront_SalesPayment", column 'ParentSalesPaymentID'. The statement has been terminated.

StackTrace:

InnerMessage:The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_Revindex_Storefront_SalesPayment_Revindex_Storefront_SalesPayment". The conflict occurred in database "DB4825_waterman", table "dbo.Revindex_Storefront_SalesPayment", column 'ParentSalesPaymentID'. The statement has been terminated.

InnerStackTrace:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicDelete(TrackedObject item)
   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
   at Revindex.Data.Linq.ControllerBase`2.Delete(T entity)
   at Revindex.Dnn.RevindexStorefront.SalesPaymentControl.SalesPaymentGridView_RowDeleting(Object sender, GridViewDeleteEventArgs e)
   at System.Web.UI.WebControls.GridView.HandleDelete(GridViewRow row, Int32 rowIndex)
   at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup)
   at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
   at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e)
   at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Source:

FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Naam: 40ftip14