Support

Home Forums Event Espresso Premium Can't delete old registration

Can't delete old registration

Posted: December 31, 2014 at 9:47 am


Lawrence Seltzer

December 31, 2014 at 9:47 am

There is a registration record that was created in EE3, and we want to delete it. The price is listed as:
Fatal error: Call to a member function name() on a non-object in /home/gateways/public_html/wp-content/plugins/event-espresso-core-reg/admin_pages/registrations/EE_Registrations_List_Table.class.php on line 384
When we click on TRASH we get this error:
Fatal error: Call to a member function ID() on a non-object in /home/gateways/public_html/wp-content/plugins/event-espresso-core-reg/admin_pages/registrations/Registrations_Admin_Page.core.php on line 1763
What can we do to delete this record permanently? It was only a test by the secretary, and seems to be causing problems. Thank you.


Josh

  • Support Staff

December 31, 2014 at 12:04 pm

Hi Lawrence,

Can you try updating the matching transaction record first?


Lawrence Seltzer

December 31, 2014 at 12:18 pm

I found the matching transaction record (price was “free”), but I do not see an option to “update”
In the end, I do not need the transaction or the registration – both were for a test.


Josh

  • Support Staff

December 31, 2014 at 1:05 pm

Hi Lawrence,

Was the site running Event Espresso 3.1.36 before the migration, or was this running a lower version like 3.1.30?


Lawrence Seltzer

December 31, 2014 at 1:39 pm

Version: 3.1.30.5P


Josh

  • Support Staff

December 31, 2014 at 2:04 pm

Hi Lawrence,

The migration scripts were built to migrate data from EE 3.1.36 or greater to EE4. The error message indicates something was not converted over correctly, which could be more than just this one registration.

If you’re familiar with phpmyadmin, it may help to look in the _esp_ticket table to see if there’s any tickets that don’t have a value for TKT_name.

If not, if you can send detailed log in credentials via our secure form someone from support can take a look.

If you need to send credentials please send them via the contact form on this page:

https://eventespresso.com/send-login-details/


Lawrence Seltzer

January 4, 2015 at 12:47 am

I looked in that one table, but I do not see anything wrong. I have sent you credentials to login.

Thank you.


Josh

  • Support Staff

January 5, 2015 at 10:31 am

Hi Lawrence,

It turns out that we do need FTP credentials or access to your server’s PHPmyadmin to look at the database. Can you resend those credentials and include either of the above?


Josh

  • Support Staff

January 6, 2015 at 3:13 pm

Hi there,

I checked the tables and there are 18 registrations that aren’t associated with any tickets. You can do a quick fix for this by running a SQL query in the phpmyadmin interface.

Here’s an example query you can use:

https://gist.github.com/joshfeck/4d9f80ac65ff67bc31fa

The above linked query will make it so the un-associated registrations (due to not updating to EE 3.1.36 before migrating to EE4) will become associated with a ticket.

We recommend backing up the database before doing any database work.


Lawrence Seltzer

January 7, 2015 at 11:37 am

This seems to have corrected the error. Thank you very much.


Lorenzo Orlando Caum

  • Support Staff

January 7, 2015 at 2:25 pm

Hi Lawrence,

Thanks for confirming. If you need help with anything else, be sure to create a new support post via our support forums:

https://eventespresso.com/support/forums/


Lorenzo

The support post ‘Can't delete old registration’ 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