|
Oguzhan Altun
|
May 23, 2018 at 4:32 am
Hello,
Recently we found out 2 cases of people trying to pay through Stripe, the system gets their payment but no registration is created. They think that the payment didn’t go through, and they try again, this time they succeed.
I found these 2 transactions, and with the help of the gateway transaction ID, I found who they belong to and refunded through Stripe. However their payments are still in EE4 and there is no way to delete or refund them (see the screenshot):
https://screencast.com/t/TELDmzSf
How can I remove these records from EE4? Right now, they create an imbalance on total payments received vs actual payments received.
|
|
Tony
|
May 24, 2018 at 7:54 am
Hi there,
Recently we found out 2 cases of people trying to pay through Stripe, the system gets their payment but no registration is created.
Registration objects are created in the database way before the payment objects even come into play so they will, at some point, have been created.
I found these 2 transactions, and with the help of the gateway transaction ID, I found who they belong to and refunded through Stripe. However their payments are still in EE4 and there is no way to delete or refund them (see the screenshot):
https://screencast.com/t/TELDmzSf
May I ask where you pulled the gateway transaction ID from? It’s not visible in your screenshot and there are no payments assigned to that transaction.
Do you have caching enabled on the site? We’ve seen something similar to this before when there was a conflict with sessions and that was due to caching.
|
|
Josh
|
May 24, 2018 at 7:58 am
Hi there,
You’re correct, there isn’t a way within the UI to delete those, but you can go into the database and remove those entries from the esp_transactions table.
|
|
Oguzhan Altun
|
May 28, 2018 at 6:58 am
Hi Tony,
May I ask where you pulled the gateway transaction ID from? It’s not visible in your screenshot and there are no payments assigned to that transaction.
I got these ID’s from the csv regsitration downloads.
Do you have caching enabled on the site?
Yes but it excludes all the event espresso key pages. We never had this problem before. It might be that there was an update happening on the website during the transaction..
Josh,
Could you explain how I can do this exactly? I’m quite afraid to touch the database, as I don’t have the technical knowledge. I can access it via php admin.
|
|
Josh
|
May 29, 2018 at 2:39 pm
It’d probably be best to leave them. If you really need them deleted, the esp_transaction table will have one row for each transaction. The ID column shown in phpmyadmin will match the ID in Event Espresso > Transactions. As a good rule of thumb, it’s best to do a database backup before working directly on the database.
|
