Location Venue Duplication

[Kris]

I am hoping you can help me solve this issue. When adding a Venue location to a new event, after I hit update or publish…the venue gets duplicated and does not appear. See attachment.

I have disabled all plugins, used wordpress theme Twenty Fifteen and can reproduce the issue. Is this a known bug???

[Andras]

Hello Kris,

Thanks for getting in touch!

I’m sorry you are experiencing this issue, this is unusual. It is surely not a feature. 🙂 Let me try to help you get to the bottom of this.

Thanks for the conflict testing. So if I understand correctly, when you have only The Events Calendar active you are still experiencing this issue.

Could you please test something else as well?

Open the developer tools in your browser (usually Ctrl + Shift + I) and open the console tab.

Now start creating an event and add a venue.

Check if the console gives you any message when updating / publishing the event (and the glitch happens).

Thanks,
Andras

[Kris]

went ahead and ran the test like you asked and there were no errors shown. please see screen cap

[Andras]

Hi Kris,

Thanks for checking this.

So far I haven’t been able to reproduce the issue on my test site with everything updated and having only the calendar plugins active with a default theme.

There are 2 things we can check next.

1. Delete and reinstall the calendar plugins (at least TEC and ECPRO,after a full site and database backup) and see if that solves it. Something might have gone south during an update.

2. Set up a new test site possible on the same server (so we have the same environment) with only the calendar plugins and a default theme and check if the issue can be reproduced. If not, then you can start adding your theme and then the plugins one-by-one checking the issue at every step.

Let me know the results, will be waiting.

Cheers,
Andras

[Kris]

Hello…

I set up a new test site on the same server with only the calendar plugins and the default theme. I created a new event and the adding a location worked fine. I then imported the events that are currently on our website and can reproduce the problem with the imported events. So it is directly related to importing them. We do not want to have to create every single event again…so is there a way to perhaps fix this???

[Andras]

Hey Kris,

I’m happy to further help you with this issue.

Thank you for testing it with the new site! It shows that likely there is no issue with the plugin, but there might be something off with one of the events.

If you can share with me the file / set that you imported, then I could run some tests locally to try to narrow it down to the event in questions and the issue.

Please also let me know the details of how you ran the import procedure. If you are not comfortable sharing it publicly, then you can set it as a private reply, then it will be visible only to our support team.

Cheers,
Andras

[Kris]

Hello…thank you for your reply. I am attaching the events xml file that I imported using the wordpress importer function. If there is a better way to do this…I would be happy to do that if you point me in the right direction. Thank you!

[Andras]

Hello Kris,

Thanks for sharing that. After importing I’m getting the same issue.

At the moment I can think of this:

The Event had a venue assigned to it previously. Then the venue hasn’t been removed from the event, and the venue was deleted. So the event is trying to load the original venue (but cannot) and since it thinks it is there it creates a new one as well.

Is this something that could have happened?

A.

[Kris]

i do not believe so. what would be the best way to fix this as we have events coming up that really require locations.

[Andras]

Hi Kris,

I was digging a bit into the database to see what could cause this.

It looks like that those events that produce this have a venue ID assigned to them that doesn’t exist, or it is not a venue.

One way this can happen is if you import events and venues into a site that already has some of those and the venue ID that is being imported is already taken. There can be other possibilities as well.

Currently the way to fix this would be going into the database and removing the venue IDs assigned to the events. Then edit the events and re-add the venues. In order to do this this is what you would need to do:

• get the ID of the event(s) that have the issue with the venue. You can find this out from the address bar or your browser when you edit an event. The URL looks something like this:
  “https://domain.com/wp-admin/post.php?post=74659&action=edit”
  and the number after “post=” is the ID of the event.
  Another, faster way is when looking at your event list in the back-end, then hover over the “Edit” link below the event title and check the URL.
• go to your database and execute the following SQL query:

DELETE FROM 'wp_postmeta' where meta_key='_EventVenueID' AND (post_id='postid-1' OR post_id='postid-2' OR ...);

… where the ‘postid-1’ etc. are the ids of the faulty events.

If you want to remove the venue from all of the events – might be faster is most of the events are corrupted – then you should run this query:

DELETE FROM 'wp_postmeta' WHERE meta_key='_EventVenueID';

Of course doing a full database backup before doing any of this is highly recommended.

At the moment this is the solution that comes to my mind. Unfortunately I cannot think of any point-and-click on the back-end type of solution, since the missing venues are not showing up.

I hope this helps and let me know if you have any more questions.

Cheers,
Andras

[Kris]

This worked GREAT! Thank you so much for working with me till this was resolved. Really appreciate your time and effort.

[Andras]

Kris, you’re welcome, I’m super happy to hear that helped you solve the issue!

Since this is marked resolved I am going to close this ticket, but if you need anything else related to this topic or another please post a new one in the forum and we will be happy to help you out.

Good luck with your project!

Cheers,
Andras

PS: If you like our plugins, and you didn’t yet do so 🙂 we would be happy to receive a review in the wordpress.org repository. Thanks!
https://wordpress.org/support/plugin/the-events-calendar/reviews/
https://wordpress.org/support/plugin/event-tickets/reviews/

PS2: We’d be also grateful if you would give us feedback on your satisfaction with support. Just click on one of the classy looking emojis below. 🙂 If you can spare a few words, that’s even better. Doublethanks!

 

 

[Author]

Posts