|
Nicole Ouellette
|
May 27, 2015 at 12:14 am
We have been having some problems with some registrations not ending up in the database. They are being paid for and the buyer gets the confirmation e-mail about the order but when we request the list of attendees a few hours before that event some registrations are missing. We haven’t been able to figure out exactly when this happens, it seems random and our client is getting very frustrated.
We’ve looked at your support forums about this symptom and there are a few posts that seem to match it. For example; https://eventespresso.com/topic/attendees-not-showing-in-database/
Some posts say this problem may be addressed in EE4, so we tried to upgrade today following the procedure documented here; https://eventespresso.com/wiki/updating-event-espresso/
* We made a copy of the site to test the upgrade
* We disabled EE3 and isntalled EE4.
* When we activated EE4 your documentation said it should have put us in ‘Maintenance mode’ and asked about importing our old events, but this never happened. None of our events and registrations appear.
So we need help getting the events and registrations from EE3 into EE4. I can see the registrations in the database tables
Database: devdive_wp
Table: vjqqok9a_events_attendee
Table: vjqqok9a_events_attendee_meta
and I can see the events in;
Table: vjqqok9a_events_detail
Yet they don’t show up in EE4. Is it possible EE4 uses different tables and it’s not importing the old ones because we’re not using the standard wp_ database prefix?
How can we get these imported?
|
|
Tony
|
May 27, 2015 at 4:00 am
Hi Nicole,
They are being paid for and the buyer gets the confirmation e-mail about the order but when we request the list of attendees a few hours before that event some registrations are missing.
Do you know if these user registering for multiple events?
Yet they don’t show up in EE4. Is it possible EE4 uses different tables and it’s not importing the old ones because we’re not using the standard wp_ database prefix?
EE4 does use different tables to EE3, but that’s not why your data is not migrating over and the wp_ database prefix won’t effect this either.
To explain, EE4 is a vastly different system to EE3, its not simply an upgrade but a completely new system built from the ground up… so EE4 doesn’t simply read the details from your current tables and display them. It actually ‘migrates’ your data from the EE3 tables to the EE4 tables and then uses the data in the new format (the migration only happens once and then all the new details go in the new tables)
The reason for this is to leave your EE3 data intact, meaning if something goes wrong during the migrations, no EE3 data is lost/altered.
That make sense? Its basically to ensure that your current EE3 data remains safe regardless of what EE4 does.
So with that said, EE4 will only migrate your EE3 data if you currently use version 3.1.36+ and EE4 has not been activated previously.
So starting from the beginning, which specific version number of EE3 are you using?
Has EE4 been activated on the site previously?
|
|
Tony
|
May 27, 2015 at 4:59 am
Hi Nicole,
I noticed you purchased a support token for this so I have contacted you through that, please continue this there.
|
|
Nicole Ouellette
|
June 7, 2015 at 10:15 am
Follow up on this, the solution was to remove some old tables leftover from a previous EE4 install (I guess when we were setting it up) and then it allowwed us to import the EE3 events.
The problem is since your support removed the tables &/or field we dont know what you did exactly so now that we are trying to do this on our production site and we are having the same problem. I see that EE4 creates tables prefaced with _esp_ so I tried dropping all those tables to get it to allow us to import our EE3 events, but that didn’t seem to be enough. Our old EE3 tables were all prefaced with _events_ cand you tell if there is some flag in there that I can set to allow us to import these events? Thanks
|
|
Lorenzo Orlando Caum
|
June 7, 2015 at 5:53 pm
Hi Nicole, the removal was done through the WP dashboard and not manually through a tool like PHPMyAdmin. I think you may be manually removing the database tables which won’t work since Event Espresso information is stored in native WordPress tables along with the dbprefix_events_ tables.
You can find the remove option by following these steps:
WP-admin –> Event Espresso –> Maintenance –> Reset/Delete Data. Scroll to end of page and click on the last option to remove everything.
—
Lorenzo
|
