Need to Make Global Change to Event Venue

[Peppermint Soda]

Something happened to the Event database and now most of my events have a venue listing of “General Membership Meeting”. . . which is a name of an event- NOT a Venue. Can I do a global change to fix this? … Perhaps with the Search and Replace plugin? If so, how do you target this specific VENUE field?

[Barry]

Hi!

That’s unfortunate, I wonder how it happened … ?

The relationship between events and venues (at database level) is basically in the form of an entry in the post meta table named _EventVenueID. The value of this is the venue post itself, so you could theoretically delete this or change the value in order to ‘point’ it to a different venue. There may very well be a plugin or other WordPress oriented tool to help with this, but none that I have personally used and can recommend unfortunately.

The general form of an SQL query to automate this operation if for instance you want to remove all of these entries would be:

DELETE FROM wp_postmeta WHERE meta_key = '_EventVenueID' AND meta_value = 'x';

Where x would be the ID of the venue post itself and wp_postmeta would be the name of the post meta table (quite often the prefix will be something other than wp_). Naturally you backup before doing this and should only follow this sort of approach if you feel comfortable doing so. Hope that helps!

[Barry]

Did you figure things out here Peppermint Soda Mason?

[Barry]

I’m going to close this as it’s been quite a while without any activity. Of course if you need further help with this or anything else please don’t hesitate to create a new thread or threads as necessary. Thanks!

[Author]

Posts