We have had a new member complete our membership form and pay through Paypal. However, no record was written to our database. In speaking with the member, he tells me the connection failed to return him to our site giving him a 500 error. The payment was complete. Our Paypal account shows the payment and he received a receipt by email.
We have found, and reported, that if someone goes to Paypal for payment but then closes his tab without paying, a record is written to the database giving us the idea that payment has been made until we see no Transaction ID in the record. This gave me the idea that a record is written upon submit and then updated when the Trans ID is returned. But that didn't happen in this case. At what point are records written to the database? How can we be sure we are not losing other records? Is there anything I can do to ensure this does not happen in the future?
In case it helps, I asked our host support what that all meant. Here is his response:
This is a block applied by "Imunify WAF rule ID 33321" and related to a protecting Joomla Registrations. Something within the way it redirected the user to the registration page back is what has triggered the error. This rule was introduced in their v3.31 release as per blog.imunify360.com/waf-rules-v.3.30-and-v.3.31-released
We have had 19 new registrants from the same form in the past month and 2 on that same day with no problem. I can check with some of them to see if they did indeed return to our site if that might help you.