Support

Home Forums Event Espresso Premium how to delete old REGISTRATION in A MASS way without deleting attached Payment

how to delete old REGISTRATION in A MASS way without deleting attached Payment

Posted: June 20, 2023 at 8:35 am

Viewing 7 reply threads


mborlongan

June 20, 2023 at 8:35 am

I’ve read previous posts regarding deleting registration however I did not find anything regarding MASS deletion of registration with out deleting attached payment individually which seem to be a lot of work to do. We now have over 10,000 registration in the system and it is giving us error “out of memory”

Fatal error: Out of memory (allocated 191090688) (tried to allocate 23919880 bytes) in /hermes/bosnacweb06/bosnacweb06ac/b2526/sl.XXXXXXXXX/public_html/wordpress/wp-includes/kses.php on line 1845

Please help.


Tony

  • Support Staff

June 20, 2023 at 9:16 am

Hi there,

On what page are you getting the above error?

Having 10,000 registrations in the system, does not load 10,000 registrations on the page at once so may I ask what makes you sure that is the issue?


mborlongan

June 20, 2023 at 9:27 am

This reply has been marked as private.


Tony

  • Support Staff

June 20, 2023 at 10:32 am

Also I have over 10,000 registrations and the error messages read “out of memory:….

Sure, but Event Espresso (by default) would never query 10k rows from the database. Our default limits are set at 50 and the error you are getting is from processing the page itself (kses.php is used to process the output, not database queries) so I don’t think relates to the number of registrations you have saved unless you have some code somewhere trying to pull everything in and process everything.

You maxing out at around 200MB of memory for the request, that’s pretty high but depends on what is going on within the page.

Can you post a link to an event I can register onto to take a look at this, please?


mborlongan

June 20, 2023 at 11:10 am

This reply has been marked as private.


Tony

  • Support Staff

June 20, 2023 at 11:15 am

Ah, yeah, so you’ve manually overridden the limit of 50 with 999 which is a LOT more processing for each page.

The above should help a lot 🙂


mborlongan

June 20, 2023 at 2:09 pm

This reply has been marked as private.


Tony

  • Support Staff

June 20, 2023 at 2:20 pm

Deleting the events?

Deleting the events should trigger a batch job to delete the related registrations (and their related data).

How exactly did you delete the events?

Viewing 7 reply threads

The support post ‘how to delete old REGISTRATION in A MASS way without deleting attached Payment’ 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