Support

Home Forums Event Espresso Premium Duplicate ATT_ID's causing problems?

Duplicate ATT_ID's causing problems?

Posted: June 24, 2020 at 2:38 pm


tyler

June 24, 2020 at 2:38 pm

Our client contacted us today because someone registered for their site, but the confirmation was sent to a previous attendee. 

I’ll post additional details privately, but from what I can see by looking at the DB, it appears that EE has begun reusing the ATT_ID and so there are multiple people with the same ATT_ID


tyler

June 24, 2020 at 2:39 pm

This reply has been marked as private.


tyler

June 26, 2020 at 9:55 am

Circling back here as the client is concerned about registrations being mixed up due to this issue. Please let us know. Thanks!


Tony

  • Support Staff

June 29, 2020 at 6:46 am

Hi tyler,

This is strange because the ATT_ID value is the ID of the espresso_attendee custom post type in the wp_posts table, EE simply can not start reusing them as the row ID is an auto-incrementing ID so adding a new row will always have a new ID.

The client upgraded from EE3 to EE4 several months ago and I’m wondering if that plays a part it what’s going on here.

Because of the above, this again seems unlikely as the espresso_attendee row is inserted into wp_posts and then the ID saves to wp_esp_attendee_meta table you are viewing.

Have the database tables ever been reset/altered? The only way I can think of this happening is if the WP tables were rest, but wp_esp_attendee_meta was not.

Can you send me a copy of the database itself?


tyler

June 29, 2020 at 7:41 am

Hey Tony, thanks for the note back. The database has never been altered. Happy to send a copy along, just let me know where to send it!


tyler

June 29, 2020 at 7:52 am

This reply has been marked as private.


tyler

July 1, 2020 at 7:16 am

Have you had a moment to review the db?


tyler

July 6, 2020 at 8:55 am

Could you please let us know what you see?


Tony

  • Support Staff

July 6, 2020 at 9:40 am

Hi Tyler,

My apologies for the delay, there’s a lot of info to go through in your DB.

EE isn’t ‘reusing’ ID’s but somewhere along the way, something is returning the ‘wrong’ ID. Is there any caching enabled on the site/server?

There’s definitely something strange going on with the site as it appears every attendee has a duplicate entry and then fairly recently entries started referencing ID’s that don’t match their attendee meta.

I’ve requested some feedback from out developers to see if hey can think of a cause for this.


tyler

July 6, 2020 at 9:43 am

Hi Tony,

The site is hosted at WPEngine and has been hosted there since its inception back in the EE3 days (6 years or so). Caching has previously been disabled for EE pages. Again though, they just saw this start happening and as far as I know nothing has changed other than the update to EE4 a couple months back.


tyler

July 7, 2020 at 10:35 am

Hi Tony,

Any word from the developers? Thanks!

You must be logged in to reply to this support post. Sign In or Register for an Account

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: publish

Updated by  tyler 2 days, 5 hours ago ago

Topic Tags

Notifications

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