Support

Home Forums Event Espresso Premium Nothing shows up after migrating from EE3 to EE4

Nothing shows up after migrating from EE3 to EE4

Posted: June 2, 2015 at 7:28 am


mpurse

June 2, 2015 at 7:28 am

Dear,

yesterday I tried to migrate from EE3 to EE4, I’ve setup a dev site, and first installed EE3 Lite latest version, then transferred all EE3 tables to the dev site, then deactivated EE3 and installed premium EE4. Now the problem is that no events show up http://www.thegoodlifecentre.co.uk/dev/workshops/ , but in admin panel under EE Events, there are some events, but all of them have statuses either Out of date, Sold out or Inactive, which is strange.

Do you have any idea to why is this happening?

Also on original website there are couple of additional plugins for EE3: Event Espresso – Attendee Mover Tool, Event Espresso – Calendar, Event Espresso – MailChimp Integration, Event Espresso – Multi Event Registration, Event Espresso – Recurring Events,Event Espresso API Plugin. Do you think some of these maybe messed up something?


Josh

  • Support Staff

June 2, 2015 at 9:39 am

Can you try activating the EE4 calendar add-on, then refresh this page:

http://www.thegoodlifecentre.co.uk/dev/calendar/

Your /workshops/ page may not have an EE4 compatible shortcode on it as well. You can also try change the shortcode on the workshops page to be: [ESPRESSO_EVENTS].


mpurse

June 3, 2015 at 1:19 am

Activated. As you can see I’ve added one Test event that does show up, so it isn’t anything related to wrong shortcodes. What I’ve discovered as well is that by just opening event in admin panel to edit, and then doing nothing to change it, and just pressing update does change their status Expired or Inactive to Sold Out?? Which shouldn’t be the case. I also figured out that dates are wrong. Everything starts at 03-07-2015 8:00 am…


Josh

  • Support Staff

June 3, 2015 at 8:21 am

Can you check on the EE3 site to see what format the dates for events are being input?


mpurse

June 3, 2015 at 3:25 pm

They are in this format http://prntscr.com/7ct2ao


Michael Nelson

  • Support Staff

June 3, 2015 at 7:40 pm

Hi mpurse, it sounds like the migration had trouble interpreting the dates in your database. (1) Can you send us a database export/dump, or send us admin access to the dev site? That way we can see exactly how the dates were formatted in EE3, and what the event status is in EE4 (because it sounds like the migration had issues and set the event status to something invalid, but it fixes it when you visit the admin event page).

Also, are the events that are giving you grief for recurring events? Because that’s something basically not supported her, and the migrations can’t migrate yet (mostly because we aren’t yet 100% certain what format they will have in EE4).


mpurse

June 4, 2015 at 3:16 am

Happy to send you access. To which email address please?

No problem to stop using recurring events. There is one left over from old use, which we are happy to set up again as a non-recurring event anyway.


Dean

June 4, 2015 at 4:51 am

Hi,

Please send the export to support@eventespresso.com.

Please include a link to this forum page so we can match up the email and forum. Thanks!


Michael Nelson

  • Support Staff

June 4, 2015 at 2:49 pm

Hi mpurse! Looking at the DEV database dump you sent us, I see the EE3 table wp_evens_start_end was empty, even though it’s got lots of data in it in the LIVE database. That table should have at least one entry for each event, indicating what time of day the event starts (and if there are multiple sessions that day, there can be multiple). This table being empty is the reason for the issues you’ve experienced.
Did you possibly forget to include that table when making an export from the live site to your development one?


mpurse

June 5, 2015 at 9:36 am

Hi Michael,

so I did export/import all over again. I deactivated EE4, deleted tables wp_esp_ and wp_events_ in DB, then imported wp_events_ from EE3, and then activated EE4 again. But the problem is still there. Before activating EE4 I made sure that wp_events_start_end have rows in them.


Michael Nelson

  • Support Staff

June 5, 2015 at 9:47 am

could you please send us the updated database export?


Josh

  • Support Staff

June 8, 2015 at 11:55 am

I can advise doing a fresh migration of your live site to your dev site. Instead of manually copying over tables (where you’ll miss copying over the options), you can use a plugin like WP Migrate DB or WP Migrate DB Pro. This will ensure that the data is correctly migrated over from the live site to development.


Michael Nelson

  • Support Staff

June 8, 2015 at 12:13 pm

Hi mpurse, I looked at the database you sent us, and it certainly does contain the EE3 wp_events_start_end table this time, but somehow the EE4 wp_esp_datetime table is empty after the migrations, but it should be full of entries after the 4.1 migration. Looking at the migration history data on the system status page, what seems contradictory though, is that it reports you had 805 rows in the wp_esp_datetime table during the 4.2 migration. So somehow all the rows from your wp_esp_datetime table existed when the 4.2 migration happened but have since been deleted. I’m not sure but I somewhat suspect maybe there was some issue in exporting your data from your live site to the development site.

So, in that database export you provided, it looks like the EE4 data is somehow busted (in the wp_esp_* tables and a few wordpress options). But the EE3 data looks intact (in the wp_events_* tables and a few different wordpress options). So I went to the wp dashboard -> Event Espresso -> maintenance -> Reset/Delete Data tab and “Permanently Delete All Event Espresso Data”, which ACTUALLY just deletes all EE4 data. Then I reactivated EE4 and ran the migrations, and it looked to have worked fine. Specifically, the wp_esp_datetime table had all the entries in it it should have.

Looking at your description of how you moved the data from your live site to your testing site, I think I might see a problem. You said

I deactivated EE4, deleted tables wp_esp_ and wp_events_ in DB, then imported wp_events_ from EE3, and then activated EE4 again.

By that I undestand that you deactivated EE4, deleted all tables starting with wp_esp_* and wp_events_* from your DEVELOPMENT site, then imported all the wp_events_* tables from your LIVE site into the DEVELOPMENT site, and activated EE4 on the DEVELOPMENT site again, right?

I think that might be part of the problem: EE3 and EE4 both have important data in the wp_options table too. In particular, they have important EE3 -> EE4 migration data in them. So if I understand what you did correctly to get your live data into your development site, that explains why you’re again having migration issues.

Your strategy of only exporting only specific tables from your live site is causing the Event Espresso migration issues you’re having, because you’re only exporting a part of Event Espresso’s data. This means that the last two times you’ve tried the migrations, you’ve started with a busted EE3 database, and so ended up with a busted EE4 database after the migrations. So please be careful that you are getting ALL your live site’s EE3 data and exporting it into your development site.

Are you using a plugin to get data from your live database into your development database? We recommend using WP Migrate DB. Use that to make your development site a nearly identical mirror of your live site (not just EE3 tables). Then try upgrading to EE4 on the development site, and running the migrations.


mpurse

June 9, 2015 at 9:05 am

OK, we’ve nailed it, thanks! All events and registrations are now transferred to our development site. Phew!

However, they display a bit strangely on the admin side. The default view seems to be ALL events (even expired ones). Is that correct?

Also, are there no waiting lists/overflow options in EE4? We have used that a lot on EE3. And might be a bit disastrous if we can’t continue to use them.

Thanks.


Josh

  • Support Staff

June 9, 2015 at 10:48 am

The default view seems to be ALL events (even expired ones). Is that correct?

Yes, that’s correct. You can filter out expired events by applying the filters that appear above the list of events.

Also, are there no waiting lists/overflow options in EE4? We have used that a lot on EE3. And might be a bit disastrous if we can’t continue to use them.

That’s also correct, EE4 does not have a waiting list option. Some have embedded a contact form to the event page to capture waitlist requests, but currently EE4 does not have a readymade, automated waitlist solution.


mpurse

June 10, 2015 at 2:43 am

OK, thanks. It’s a bit strange to view events that are long expired (years in our case). Does it not make sense for the default view to be upcoming, but including sold out events too – figured out that they don’t show if you simply select ‘upcoming events’, which is also a bit strange.

Big shame about the waitlist/overflow, that was a great feature on EE3.


Lorenzo Orlando Caum

  • Support Staff

June 10, 2015 at 7:22 am

Hi, members have asked for the event listings page to show with expired events and without. You can add this to your child theme’s functions.php file or via a site specific plugin to remove them:

https://github.com/eventespresso/ee-code-snippet-library/blob/master/templates/de_ee_filter_events_out_with_expired_tickets.php


Lorenzo


mpurse

June 10, 2015 at 8:18 am

Brilliant. Thank you muchly.


Lorenzo Orlando Caum

  • Support Staff

June 10, 2015 at 10:42 am

You are welcome! Enjoy your week.


Lorenzo


mpurse

June 24, 2015 at 2:25 am

Hi Lorenzo,

We’ve installed the script but it doesn’t seem to make the difference. I still see expired events, which is a pain as we have hundreds.

In fact I think generally the filtering on our site isn’t working.

Upcoming events do not show any events that are sold out.
Active events do not show any events at all.

Perhaps you could take a look?

Thanks.


Lorenzo Orlando Caum

  • Support Staff

June 24, 2015 at 10:14 am

Hi, could you confirm that your software is up to date?

http://eventespresso.com/wiki/ee4-changelog/

Next, how was the sample code added? Was this done through your child theme’s functions.php file or a site specific plugin?

Also, this sample code is for the front end. Would you happen to be referring to filtering by status in the Events overview page in your WP dashboard?


Lorenzo


mpurse

June 25, 2015 at 8:35 am

Software is up to date.

Yes, I’m referring to filtering in the dashboard. I thought that was what the code was for?


Lorenzo Orlando Caum

  • Support Staff

June 25, 2015 at 9:48 am

Hi, the code snippet is for removing expired events from the front-end. Could you rephrase what you are trying to do in the events overview screen?

Thanks


Lorenzo


mpurse

June 25, 2015 at 9:51 am

I want the default view in the back-end to show live events in date order. So I have an overview of what is coming up.

Currently, it shows me everything from the beginning since we started (years old).

Filtering ‘coming up’ does not show me any events that are full (can’t imagine why I wouldn’t want to see my full events?).

Filtering ‘active events’ doesn’t return anything at all.

It just feels like the the filtering isn’t working at all how it should


Lorenzo Orlando Caum

  • Support Staff

June 25, 2015 at 10:39 am

Hi, that is how is should work with newer events appearing at the top and older events appearing further down the list.

What happens if you click on the filter dropdown for the status and select Expired and then click on the Filter button?

http://cl.ly/image/0r47101B2E3k


Lorenzo


mpurse

June 25, 2015 at 11:43 am

Then I see a handful of recently expired events only (there should be hundreds), and inactive event. See screen shot: http://awesomescreenshot.com/0ea50kna9e


Lorenzo Orlando Caum

  • Support Staff

June 26, 2015 at 9:08 am

Hi, I did find an issue with the active status dropdown filter which I’ve reported and we’ll get fixed. However, it sounds like there should be far more events appearing. Could you share a temporary login so we can have a look?

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


Lorenzo


mpurse

July 2, 2015 at 6:33 am

Hi Lorenzo, any update on this? We are hoping to migrate completely to EE4 this weekend.

thanks.


Lorenzo Orlando Caum

  • Support Staff

July 2, 2015 at 9:00 am

Hi, the active filter and pagination issue were corrected in the latest maintenance release:

http://eventespresso.com/wiki/ee4-changelog/#4.7.5


Lorenzo


mpurse

July 2, 2015 at 12:09 pm

I see more events, but still don’t see sold out events. Also still seeing all expired events.


Lorenzo Orlando Caum

  • Support Staff

July 2, 2015 at 3:20 pm

Hi, by default the events overview screen will show all events. I mentioned this in the prior email. If you are wanting to filter to a specific status, then please use one of the filter options.

Sold out events would appear under expired.


Lorenzo


mpurse

July 2, 2015 at 3:22 pm

Hi Lorenzo,

Perhaps I am being a bit daft. But I don’t get it. Why do sold out events appear under expired?

I want to view upcoming events so I can manage them. But if the most popular events (i.e. sold out events) don’t show up with this filter, then I am not seeing ALL upcoming events.

Or did I get that wrong?

The support post ‘Nothing shows up after migrating from EE3 to EE4’ 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  mpurse 4 years, 5 months ago ago

Topic Tags

Tagged: ,

Notifications

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