I have several forms using a Paypal redirect and a Paypal listener action. Most of them work fine, but one form recently started consistently executing the ON IPN event multiple times after the user completes the Paypal transaction and is redirected back to a confirmation page. The On IPN event has the following actions:
[list]Sends me an email listing the contents of the Post array with the information returned from Paypal (this works)[/list]
[list]Paypal listener. There are no actions in the On Verified, On Invalid, or On Error sections.[/list]
[list]A custom code action which runs several queries to update the database. This code executes the first few queries but then apparently stops.[/list]
[list]An email action to indicate that the database updates have completed. This email is never sent.[/list]
There is probably an error in the custom code that I haven't found causing it to stop running, but I don't understand why this would cause the IPN action to start again. The initial email is sent and the database partially updated several times in the first few minutes, and then repeatedly, but at longer intervals, over the following few days.
Can anyone give me an ideas about what might be causing this?
[list]Sends me an email listing the contents of the Post array with the information returned from Paypal (this works)[/list]
[list]Paypal listener. There are no actions in the On Verified, On Invalid, or On Error sections.[/list]
[list]A custom code action which runs several queries to update the database. This code executes the first few queries but then apparently stops.[/list]
[list]An email action to indicate that the database updates have completed. This email is never sent.[/list]
There is probably an error in the custom code that I haven't found causing it to stop running, but I don't understand why this would cause the IPN action to start again. The initial email is sent and the database partially updated several times in the first few minutes, and then repeatedly, but at longer intervals, over the following few days.
Can anyone give me an ideas about what might be causing this?