Location doesn’t update on existing Events

[Henny Zijlstra]

Since the last 4 weeks we cannot update Locations on existing events. Selecting a saved location or creating a new location will be gone after saving. We are running the last version of Events Calendar (4.2.6) and Events Calendar Pro (4.2.5).
Creating a new event with a location is not a problem. Here changes in location will be saved.

I tried de-activating all other plugins, but this didn’t help. We use a custom theme (Child theme of Twenty Thirteen, updated version)

All other plugins are running latest versions as well. Our server runs PHP 7.

What can be the matter?

 

[Geoff B.]

Good afternoon Jaco and welcome to the Events Calendar Support forum!

Thank you for reaching out to us.

We are sorry to hear about the fact that you cannot update Location on existing events on your site. Yikes!
I would love to help you with this topic.

At this point, my best guesses are:

1. There is a conflict with your Twenty-thirteen child theme.
2. There might be some type of data corruption on the older events.

Could you please send me a copy of your Child theme in a .zip file link (via Dropbox or Google Drive) so that I can run some tests on my end ?

Additionally, can you tell me if changing any other type of information on the existing events work ?

Finally, could you please send me a screenshot of one of the existing events Edit Event screen ?

Best regards,

Geoff B.

 

[Henny Zijlstra]

Hi Geoff,

Thanks for your response. Here is the link to a zip-file of our theme:
https://www.dropbox.com/s/3j0nebp9ma6ebal/shm.zip?dl=0

Most fields of an event can be changed, except Location and Organisor.

I will upload some screenshots of the edit screen of an event.

[Geoff B.]

Good evening Jaco,

Thank you for the system information and the theme.

Based on what you have sent, there are a couple of additional things I would like to check with you:

1. If you head over to Events -> Settings -> General and scroll all the way down and is there any “Venue” or geolocation based update available ?
2. If you go in one the Edit Venue screen found in one of the events where it’s not possible to edit them and update the Venue (re-save) + do the same for the organizer in that event, does it change anything.

Let me know how that goes.

Best regards,
Geoff B.

[Henny Zijlstra]

Hi Geoff,

Thanks. I tried what you asked:
1) There were 2 updates available, i did these (Merge duplicates end Update Location Data)
2) Making changes in Venue or Organizer have no effect. These are not changed in the Event. –> But adding a new Location does result in a new entry under Locations (outside the Event screen).

Hope this helps.

Henny

[Geoff B.]

Good evening Henny,

Thank you for running those tests.

I am sorry to hear they did not help.

I took a closer look at your install and I am seeing the following warning in the Google Console:

Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user’s experience. For more help, check https://xhr.spec.whatwg.org/.
load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-core,jquery-ui-widget,jquery…:9 JQMIGRATE: Migrate is installed, version 1.4.1

I am not sure where this message is coming from but it would be worth investigating.

The other thing I might recommend testing if you can is to see if using a different version of PHP helps (e.g: 5.6+)

Let me know how that goes.

Best regards,
Geoff B.

[Henny Zijlstra]

Hi Geoff,
No that warning is not the problem. Certain older events en with newly created events the problem doesn’t occur.
What we did notice: It seems to happen with Events that are duplicated multiple times (With Post Duplicater)
Does this ring a bell?

[Geoff B.]

Good evening Henny,

Thank you for writing back and for checking things out.

By the looks of it, there seems to be some database level corruption going on with these older events.
It is possible that this was caused by the post duplicator. Normally custom post duplicators do work however, including this one: https://wordpress.org/plugins/duplicate-tec-event/

After a database backup, the simplest solution would be to either:

1. Update the location manually in the database using phpMyAdmin
2. Recreate these events from scratch (perhaps while using the duplicator plugin) and deleting the “broken” events.

Let me know how that goes.

Best regards,
Geoff B.

 

[Henny Zijlstra]

Hi Geoff, Thanks for the suggestions. We installed the other duplicate plugin. This seems to work well.

Can you give a hint where we can update the locations in the database? I had a look but not sure in which table Events Calendar stores this. Thanks!

>> henny

[Geoff B.]

Good evening Henny,

Thank you for writing back.

To update locations please do the following:

1. Make a complete database backup
2. Access phpMyAdmin
3. Find the wp_posts table
4. Do a search to filter by the “tribe_venue” post type
5. Look for the locations you want to update and write down their post ID
6. Go to the wp_postmeta table and do a search by post ID
7. Update the required data
8. Repeat step 5 to 8 for each location

Let me know how that goes.

Best regards,
Geoff B.

[Henny Zijlstra]

Hi Geoff, Thanks!
This helped. I looked for the events that were problematic at postmeta. There i noticed a double row with EventID. This seemed to cause the problem. The first row had a ‘0’ content. After changing this, the location could be updated and saved agein in wp-admin.
Regards >> henny

[Geoff B.]

Good morning Henny,

I am super stocked that this helped and that you were finally able to fix the problematic venues.
Kudos on that!

You are welcome back on our support forums any time 🙂

For now, I am going to close this thread.

Have a great week!

Geoff B.

[Author]

Posts