Did search on many different lingos of the eror but i am getting a new error on the events module. I have not upgraded to the RC's so i am not sure if this has been found before. Not sure if he had errored out on paypal and tried to go back in or not. Just thought i would offer it up as i didnt see a solution in my searches and figured it might be worth reporting no matter how obscure. BTEW, Looking at the event enrollment, he was showing False for approvals. I usually need to delete them as they can not seem to finish the paypal register . (i have 5 out of 24 saying false for paypal. One of this sites main complaints about the events module hence i seem to need to admin it and delete the false approvals all the time. Not sure how to fix this).

ModuleId: 375
ModuleDefId: 102
FriendlyName: Paypal Event Enrollment
ModuleControlSource: DesktopModules/Events/EventPPEnroll.ascx
AssemblyVersion: 04.09.00
PortalID: 0
PortalName: FantasyQuest Productions Inc.
UserID: 62
UserName: Darcrath
ActiveTabID: 55
ActiveTabName: Events
RawURL: /PlayersArea/Events/tabid/55/ctl/PPEnroll/Mid/375/ItemID/17/Default.aspx?selecteddate=1/31/2009
AbsoluteURL: /Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB5; .NET CLR 1.1.4322; .NET CLR 2.0.50727; IEMB3; IEMB3)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: e55d41c2-87e6-4f1e-b60e-ef083d6f7558
InnerException: Violation of UNIQUE KEY constraint 'IX_dnn_EventsSignups'. Cannot insert duplicate key in object 'dbo.dnn_EventsSignups'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Violation of UNIQUE KEY constraint 'IX_dnn_EventsSignups'. Cannot insert duplicate key in object 'dbo.dnn_EventsSignups'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_dnn_EventsSignups'. Cannot insert duplicate key in object 'dbo.dnn_EventsSignups'. The statement has been terminated. 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.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) 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.Events.Data.SqlDataProvider.EventsSignupsSave(Int32 EventID, Int32 SignupID, Int32 ModuleID, Int32 UserID, Boolean Approved, String PayPalStatus, String PayPalReason, String PayPalTransID, String PayPalPayerID, String PayPalPayerStatus, String PayPalRecieverEmail, String PayPalUserEmail, String PayPalPayerEmail, String PayPalFirstName, String PayPalLastName, String PayPalAddress, String PayPalCity, String PayPalState, String PayPalZip, String PayPalCountry, String PayPalCurrency, DateTime PayPalPaymentDate, Double PayPalAmount, Double PayPalFee, DateTime EventTimeBegin, Int32 TimeZoneOffset) at DotNetNuke.Modules.Events.EventSignupsController.EventsSignupsSave(EventSignupsInfo objEventSignup) at DotNetNuke.Modules.Events.EventPPEnroll.cmdPurchase_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:

Hi Dean,

What is happening here is that the user has clicked that they want to purchase the event, then clicked back on the PayPal page, to get back to the purchase page, then click Purchase again. This then tries to put the same purchase stub record into the database twice. I'll see if I can think up something to work round this.

Cheers
Roger

So, it sounds like you were able to recreate the process? If so, then i do not have to try to contact the user. If that is the case then i do agree it is hard to stop them from backing out to paypal to hit purchase a second time.  only way to prevent is maybe checking for record exist and if false enrollment then just don't write and allow to go to paypal? Then again, it shouldn't allow paypal if enrolled allready equal true? Of course, i don't know if you write a key to the record to identify it coming back from paypal if so, it sounds like an update is in order as a second attempt?

Thanks for the prompt reply. I haven't erased any records yet in case i needed to go snorkling for you folks. Just surprised this incident hasn't come up before.

Thank you,

Dean