Support

Home Forums Event Espresso Premium Orphaned Transactions

Orphaned Transactions

Posted: March 4, 2020 at 10:36 am


TinyTechs

March 4, 2020 at 10:36 am

We are having an issue with an apparently orphaned transaction somehow being accessed and triggering a fatal error. This sends an email to the admin. The transaction can’t be accessed through any registrations. Would it be ok to just delete the transactions directly from the database or is this likely to cause more problems. It doesn’t appear to affect website functionality, but is more of an annoyance. phpmyadmin screenshot

Thanks


Josh

  • Support Staff

March 4, 2020 at 10:40 am

Hi,

If you view the transaction in the WordPress admin, what’s the fatal error?


TinyTechs

March 4, 2020 at 11:11 am

This is from the notification email:

WordPress version 5.3.2
Current theme: Tiny Techs Club (version )
Current plugin: Event Espresso (version 4.10.3.p)
PHP version 7.2.28

Error Details
=============
An error of type E_ERROR was caused in line 1046 of the file /wordpressroot/wp-content/plugins/event-espresso-core-reg/admin_pages/transactions/Transactions_Admin_Page.core.php. Error message: Uncaught Error: Call to a member function reg_code() on boolean in /home/tinytechsclub/public_html/wp-content/plugins/event-espresso-core-reg/admin_pages/transactions/Transactions_Admin_Page.core.php:1046
Stack trace:
#0 /home/tinytechsclub/public_html/wp-admin/includes/template.php(1343): Transactions_Admin_Page->txn_details_meta_box(NULL, Array)
#1 /home/tinytechsclub/public_html/wp-content/plugins/event-espresso-core-reg/core/admin/templates/admin_details_wrapper.template.php(31): do_meta_boxes(Object(WP_Screen), ‘normal’, NULL)
#2 /home/tinytechsclub/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Template.helper.php(386): include(‘/home/tinytechs…’)
#3 /home/tinytechsclub/public_html/wp-content/plugins/event-espresso-core-reg/core/admin/EE_Admin_Page.core.php(2869): EEH_Template::display_template(‘/home/tinytechs…’, Array, true)
#4 /home/tinytechsclub/public_html/wp-content/plugins/event-espresso-core-reg/core/admin/EE_Admin_Page.core.php(2798): EE_Admin_Page->_display_admin_p


Josh

  • Support Staff

March 4, 2020 at 12:22 pm

Thank you.

The code in question is trying to retrieve the primary registration related to the transaction, and the primary registration has apparently been deleted.

You could also delete the transaction, but that could lead to more orphaned data if there are other registrations related to the transaction. So before you delete the transaction you could also check the esp_registration table to see if any other registrations belong to that transaction. You’ll check the TXN_ID column.


TinyTechs

March 4, 2020 at 4:16 pm

Great! Thanks for the info.

The support post ‘Orphaned Transactions’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso