Facebook Events is not importing the Addresses of the Event Location

[veruska]

When I import the Event, the tool is only mentioning part of the address. Sometimes only the name of the place.
Here is an example: https://www.facebook.com/events/240920126109254/
My website just shows Carol’s as you can see here:
http://brasileirinho.com/pt/event/festival-sabores-de-pernambuco-em-miami-dias-9-e-10-de-maio/
However, Facebook Event shows the full address, which is: Carol’s Cucina & Vino no 247 S.E. 1 st Street, Miami, FL.
And because of that, it is not bringing up the Google Map either!
This is a new issue as my previous events did not present this problem before.
Please respond at your earliest convenience.

[Barry]

Hi! Just a note first of all that I moved this across from the WooCommerce Tickets forum to the Facebook Events forum – however the thread URL should remain the same and you should stay subscribed to updates (if you chose to subscribe).

You’re absolutely right and there is a bug here (actually due to something in the inner workings of The Events Calendar itself rather than Facebook Events). However, this has been addressed in our working code and so relief is in sight! We’re getting close to the end of the current maintenance cycle and so if you can hold on a little longer until the next release arrives this problem should be quashed 🙂

[veruska]

No problem. I’m glad you guys are on it already. However, I didn’t realize it until after importing a bunch of Events. Urgh! I wonder if there would be some type of log where I could retrieve these URL Event numbers from, to make it easy to repost it. Otherwise it will take forever to research Facebook to find the ones I already imported, after you fix the bug.

[Barry]

The Facebook IDs are recorded, but they aren’t exposed in the user interface since – for most users – they aren’t something that they really care about.

If you are happy working with a tool like phpMyAdmin I could probably give you a query to help you retrieve the Facebook IDs of all imported events (let me know if that might help) – otherwise it might be easiest if, unfortunately, a bit of a chore, to do this work manually.

[veruska]

Please go ahead and send me the query. I’ll try to locate it on my server.
It is not the best option but it is better than having to start from scratch…

[Barry]

SELECT ID, post_name, meta_value AS facebook_id
FROM wp_posts 
JOIN wp_postmeta ON post_id = ID 
WHERE meta_key LIKE '_FacebookID';

That should give you a list of events and their corresponding Facebook IDs: do note you may need to change the wp_ prefix for wp_posts and wp_postmeta (if you notice all the other database tables start with something other than that).

I hope that helps: sorry once again for the inconvenience and I hope this at least gives you a means of managing things.

[veruska]

Thank you! I was able to retrieve ALL Event ID’s.
I can’t work with them yet, as I need to wait until you fix the bug, but thank you. Hopefully it won’t take too long. I just realized that the bug is messing up not only the addresses but also Venues, etc.

[Barry]

That’s right, unfortunately (re the problem impacting in a couple of areas) – but I’m glad the snippet works for you and the set of fixes in question ought to be going out in the very next maintenance release (though I or another team member will aim to drop back in here to confirm).

Thanks again for your support and patience.

[veruska]

Is that fix coming up soon? I’m beginning to feel very anxious about it. It caught me right when I was ready to launch my website and now I am stuck and forced to postpone the launching day. Please give me better news …

[Barry]

I’m really sorry but we just can’t offer a commitment to specific dates in relation to our release schedule.

With that said, I do feel pretty confident in saying the next maintenance release will arrive within the next week or so – as it’s just in the final stages of preparation at this point – however please don’t bank on it, simply as it’s not impossible some unknown factor might cause a delay.

[veruska]

Fair enough.

[Barry]

No problem – and thanks for your patience 🙂

[Author]

Posts