Duplicate entries in calendar after import

[Nicolas]

Hi,

I needed to import all my venues and events to a new WP website.
I used the WordPress “export” and “Import” feature available in tools, and followed the steps described here: https://theeventscalendar.com/knowledgebase/using-wordpress-export-tools-to-migrate-events-content/

I started by exporting all venues from my old site (.xml file), and then imported the .xml file on my new website. It worked like a charm. All 54 venues were perfectly imported, with their geolocation data. Worked like a charm.

Then I followed the exact same steps, and exported all events from my old site (.xml file), and then imported the .xml file on my new website. I have 472 events created on my old website. I expected to get 472 events imported onto my new website. But I got 944 events! So twice as many events. I checked, and for each event imported, it created a duplicate.

For instance Url appear as /event/my-special-event/all/ and /event/my-special-event-2/all/
or /event/dinner-in-paris/2016-04-22/ and /event/dinner-in-paris-2/2016-04-22/

Is this a bug that has affected other users? FYI, I noticed that if I selected a different user in “assign posts to an existing user”, it created four times as many duplicates of the same event (two for the original author of the post, and two for the “new user”). Maybe this is something worth looking into.

Any advice to get this solved would be very much appreciated. Alternatively, a trick to get rid off the duplicates via phpmyadmin/mysql would be very helpful.

Thanks

[Nicolas]

I found a way around to remove duplicates via phpmyadmin. I noticed that all duplicates were created AFTER all events had been created in mysql. Ex: All original events have IDs 2001 – 2472 and all duplicates have IDs 2473 – 2945.
Therefore, /event/dinner-in-paris/ has ID 2001, while /event/dinner-in-paris-2/ has ID 2473 (I thought duplicate would be an immediate consecutive number).

So this means that during the import phase there was a bug that triggered (maybe) a re-initialisation of the upload process, therefore created duplicate entries (program rather creates a duplicate that delete an identical entry). I did not have that many events to upload (only 472). I understand that upload bug can happen with thousands of entries. But with only a few hundreds?

It would be nonetheless interesting to investigate this issue more in details.

[Brian]

Hi Again,

So I think this is related to the Venue and Organizer Bug.

You are the first to report it, but when I was fixing the Venue Bug I noticed there might be an issue with events and added the same fix there.

If you replace the contents of this file:

the-events-calendar/src/Tribe/Importer/File_Importer_Events.php

With this:

https://raw.githubusercontent.com/moderntribe/the-events-calendar/release/4.1.3/src/Tribe/Importer/File_Importer_Events.php

That should resolve the issue.

Let me know if that works out.

Thanks

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts