Migrating from existing live site to new dev site, listings don’t display

  • Resolved simco

    (@simco)


    5 years, 9 months ago

    We’re doing a revamp of the live site by utilizing a development site in the interim. I have moved a copy of the plugin AND all the related database tables from the live site to the dev site. But, even though the database shows all the event listings, categories, and tags, they do not display in the plugin area under All Events, Categories, and Tags.

    Am I missing a table? I assumed copying the EM tables to the new dev site would be sufficient.

    em_bookings
    em_bookings_relationships
    em_coupons
    em_email_queue
    em_events ( displays the events via phpmyadmin )
    em_locations
    em_meta
    em_tickets
    em_tickets_bookings
    em_transactions

    Please advise, thank you!

Viewing 7 replies - 1 through 7 (of 7 total)

  • Yes, you are missing all the entries in wp_posts and wp_postmeta. So WP has no idea what to do with the other tables.

    Thread Starter simco

    (@simco)

    Sorry to reopen this, I did migrate all the other info ( meta and posts ) by doing an ‘export’ then ‘import’ into the new site. However, the only issue seems to be that the items in the calendar do not have a permalink or link to the event page. Is there something I have to do to regenerate those?

    Actually, some do and some don’t. Have a look here:

    https://tiny.cc/oket8y

    Is there any training/guide on how to export – import? I am in a similar situation from live to dev site.

    No, there is no documentation, because import/export is not (yet) supported within EM. There are many topics about that on this forum.

    Check your Events > Settings > Pages if the Events Page has been selected. If so, then also flush your permalinks.

    Thread Starter simco

    (@simco)

    It’s set to posts. And, I exported all the Events, Recurring Events, and Locations from the previous install and imported all of those.

    Resetting the permalinks doesn’t fix the problem, unfortunately. It may require that I go into each event and hit Update which seems to make the slug appear.

    What and how did you export? The SQL tables or from within the WP Dashboard? Only cloning the SQL tables will give a rather decent “import”. Any other method leads into wrong ID-connections over the different tables.

    Indeed the only solution then, would be to manually republish each location and event.

    Thread Starter simco

    (@simco)

    Patrick:

    I actually exported that list of tables using PHPMyAdmin that I posted in the initial post. Then, after you mentioned the actual posts, meta, etc. were missing, I exported those from the current live site using the WP export utility since it would let me select the CPT specifically. I’ve already migrated all the other pages and posts.

    They have quite a few events so we hope we don’t have to reenter them individually. Weird, because some work and some don’t. In the calendar at that link I provided you can mouse over and see that some links just point to the home page while others point to the designated event page (like normal). I don’t know if there’s a difference between the type of events that would cause that. Some are recurring, some not, etc.

    FYI, I posted that ‘updating’ them would reset the URL but that’s not the case. I just tried and nothing happened.

    Any help would be great to resolve this. Thanks.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Migrating from existing live site to new dev site, listings don’t display’ is closed to new replies.