Support

Home Forums Event Espresso Premium unable to remove old registrations/attendees

unable to remove old registrations/attendees

Posted: January 14, 2019 at 5:57 am


skleijer

January 14, 2019 at 5:57 am

On the website we want to keep old events but removing attendees/registrations that attended that event. It is not possible to delete attendees from 2012 – 2015 (2016 and later doesn’t have this problem). Also an error 500 occurs when trying to delete these old attendees. Can you help?


Tony

  • Support Staff

January 14, 2019 at 8:40 am

Hi there,

Did you originally migrate over from EE3 and that’s where those 2012-2015 registrations are from?

Also an error 500 occurs when trying to delete these old attendees. Can you help?

If you check the servers error logs you should see the full error for this, can you post that here?

Usually your host will have a section within their control panel to view errors from the site.


skleijer

January 16, 2019 at 2:29 am

I did migrate from E3 originally that’s correct. Error that occurs the most in the log files: [Mon Jan 7 14:04:29 2019] [error] [client 91.184.19.40] ap_pass_brigade failed with error 103: Software caused connection abort, referer: http://www.**.nl/wp-cron.php?doing_wp_cron=1546866269.2512590885162353515625


skleijer

January 16, 2019 at 2:29 am

I did migrate from E3 originally that’s correct. Error that occurs the most in the log files: [Mon Jan 7 14:04:29 2019] [error] [client 91.184.19.40] ap_pass_brigade failed with error 103: Software caused connection abort, referer: http://www.**.nl/wp-cron.php?doing_wp_cron=1546866269.2512590885162353515625


Tony

  • Support Staff

January 16, 2019 at 3:26 am

I think that error is from the wrong log file, it looks like the access log.

The error log should show ‘Fatal error’ if your getting error 500.


skleijer

January 18, 2019 at 3:03 am

Hello Tony, I checked the error log files (debug mode is on). I cannot find an error 500. I did find this one: [Thu Jan 17 14:41:17 2019] [error] [client 90.145.108.250] ap_pass_brigade failed with error 103: Software caused connection abort.
Nevertheless is the result when I try to remove old attendees an http error 500 (see attached screenshot). It only happens with events from 2012 and 2013.

error 500 sreenshot


Tony

  • Support Staff

January 18, 2019 at 5:01 am

Hello Tony, I checked the error log files (debug mode is on).

WP_DEBUG mode is on? If so on the page you’ve added the screenshot to you would normally see the full error, or if you’ve only got error logging enabled it would log to /wp-content/debug.log

For WP_DEBUG mode to log errors and not display them, use this snippet in your wp-config.php file:

https://eventespresso.com/wiki/troubleshooting-checklist/#wpdebug

Can you also post a link to the site?


skleijer

January 18, 2019 at 5:21 am

This reply has been marked as private.


Tony

  • Support Staff

January 18, 2019 at 7:38 am

Thank you, that’s the full error.

So that means EE can’t find the ticket the registration has been assigned to l, is the Event that registration is for a valid event?


skleijer

January 18, 2019 at 9:47 am

Yes it is a valid event. It has not been removed. But the date was June 15th 2012.


Tony

  • Support Staff

January 21, 2019 at 4:35 am

Hmm, strange.

Can I take a quick look at this in the admin?

If so you can send login details using this form:

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


Tony

  • Support Staff

January 21, 2019 at 8:53 am

It looks like the password submitted is incorrect, can you re-check and re-send, please?

Also the ID of the registration you are trying to delete so I know where to look.


skleijer

January 27, 2019 at 4:45 pm

This reply has been marked as private.


skleijer

February 4, 2019 at 5:19 am

This reply has been marked as private.


Tony

  • Support Staff

February 6, 2019 at 1:32 pm

Hmm, ok, so I’ve had a look over your registrations and the ones from 2012 don’t load the transactions page correctly, which leads me to believe there are issues with line items on those registrations.

The problem with that is the delete routines pull various data, verify its valid and then remove the data, this is to prevent orphaned data within the database, but as that data is apparently broken, the delete routines fail.

There’s no easy fix for this and it’s not something you can work around within the UI.

Does your database still have the EE3 tables within it? I’d like to take a look at the DB to see if anything stands out there for this. (Both the EE3 and EE4 tables)


skleijer

February 7, 2019 at 5:23 am

Do you need the login for this or can I send the sql? (60 MB)


Tony

  • Support Staff

February 7, 2019 at 6:58 am

You can just send the SQL but at that size, you’ll need to host it somewhere and post the link I can use to download it (you can set it in a private reply)


skleijer

February 12, 2019 at 2:18 am

This reply has been marked as private.

The support post ‘unable to remove old registrations/attendees’ 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.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  skleijer 1 month, 1 week ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!