Moving EM from multisite to single site

  • I’m trying to move my current EM install from a multisite installl to a single site. I exported all my content to an SQL-file, modified it to my new install, altered EM tables holding a blog_id column to NULL. I deleted the custom post types for events and locations from the blogs table, but I still get an empty list of events, but in the column title it keeps giving me the number of events. On the other hand the locations list is doing fine and shows me the locations.
    My guess is that the custom post type and the EM-tables are out of sync. I probably missed something somewhere.
    I also tried to export and import the events with a WXR file, but that gave me the same outcome….

    Any suggestions on how to fix this?

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    maybe you can try this wp tutorial – https://www.wpbeginner.com/wp-tutorials/how-to-move-a-site-from-wordpress-multisite-to-single-install/

    also, you might need to export your tables with prefix _em* and wp_posts/wp_options since EM is using custom post type using your phpmyadmin or any equivalent.

    Thread Starter Sjoerd Blom

    (@vertizio)

    Thanks for your answer @angelo_nwl. I know my way around with WP. I know how to migrate multisite to single site. I have done this on a dozen sites already. That’s not the point. The point is that EM doesn’t behave as expected: the relation between the custom post type ‘event’ in my prefix_posts table and the prefix_em tables is somehow lost. Like I told in the original post: I dumped the tables, pulled them in with vi and altered the tables to match the new install. In the dashboard the number of events do show up, but not the events themselves. However the locations do show up in the dashboard.

    Events Manager events are also linked to wp_posts and wp_postsmeta – did you update those at the same time?

    Thread Starter Sjoerd Blom

    (@vertizio)

    @caimin_nwl I didn’t, but I updated them (set all metavalues for the metakey ‘_blog_id’ to NULL). I was hoping that that was the problem…. unfortunately.

    Would posting a dump of a working row and a not-working one of some tables help?

    Unless the import retains the wp_posts and wp_postmeta data for events, the events list in admin will be missing the event data.

    Thread Starter Sjoerd Blom

    (@vertizio)

    @caimin_nwl what do you mean by that? Do you mean that everything should be imported simultaneously, all in one single import?

    There’s no trouble for me in doing a clean import. The site isn’t live yet.

    Yes, exactly.

    Thread Starter Sjoerd Blom

    (@vertizio)

    This is frustrating @caimin_nwl… still no luck.

    I made an WXR export and imported it on a freshly installed WP, with Events Manager as the only plugin. This is what I got:

    All events
    All events list is empty, but it tells us that there are events…

    Drafts
    The list of drafts is visible. I published one, it got out of the list of drafts but it didn’t show up in the ‘all events’ list…

    Locations do show up however…
    Locations

    • This reply was modified 7 years, 11 months ago by Sjoerd Blom.

    I’m wondering if this has something to do with a difference in user accounts between sites because your first screenshot shows only one event listed as “Mine”.

    Thread Starter Sjoerd Blom

    (@vertizio)

    Well if that was true, then the published events would show up and be visible for non logged in users… The one event showing under ‘mine’ is the one that was made manually after the import.
    Anyway because this was consuming far too much time, I decided to drop this and import the upcoming events manually.

    So this issue hasn’t been resolved, but I think we can stop looking for the solution. The only solution I can think of is having a proper import and export of the events besides the existing WP import/export feature.

    I’d really like to know if you found a solution. I just migrated from multi- to single-site. The events are all there and display on the web site, but Events Manager seems to be broken:

    • There’s no longer an option to see a list of events or locations in wp-admin
    • There’s no longer an option to edit an event in the black admin bar when you are viewing the event
    • Although you can view comments related to events in the comments section, you can’t approve|edit|delete|etc. the comments. The option-link bar no longer appears for comments related to events (it appears for comments related to posts as it should)

    It seems to be fundamentally broken.

    Any ideas what can be done with this? Are there some mysterious rows in wp_options or something that need to be transferred over, which may have been missed since I only imported wp_multi_2_options (not the actual table name, but you know what I mean)?

    The rest of the site is working fine.

    Or is there a simple way to export all the event data, reinstall Events Manager from scratch, and reimport the data? Would that work?

    Thread Starter Sjoerd Blom

    (@vertizio)

    @oceanwind I’ve tried to migrate but after 2 weeks of trying I was still unsuccessful. The events appear to have been migrated, the manager showed the number of events, but not the events themselves. So I decided to stop trying and convert the events manually. Most events were past events, I didn’t migrate them, I only entered the future events (of which there were only a dozen).

    I recommend that you create your own topic as well. And I hope that the developers will create an export and import method after getting several reports from users about this issue.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Moving EM from multisite to single site’ is closed to new replies.