You should be able to remove those duplicates by deleting them directly from the table and leaving one behind (post_id should match the post id of your location in your admin area).
However, are you able to reproduce this problem? If so, can you desribe what you’re doing to create duplicate locations?
I simply insert a new event and also creating a new location from the same mask.
In the table on mysql database, one of two records stored of the duplicate location doesn’t have coordinates, address and town values.
Thanks
What do you mean when you say, “from the same mask”?
The ‘Where’ section in ‘Add Event’
For information,
if I add a new location, without create an event, I don’t have problems.
hmm, I tried this one but I wasn’t able to replicate this. maybe you can provide us a step by step guide on how to replicate this?
I hope to be clear.
Reinstalled wordpress on my web server;
wp default theme (twenty thirteen);
no plugin activated,
Event Menager installed and activated,
I leave the default settings of EM;
I create the first event and in the WHERE section insert: location name, address, city, state.
the event is properly created and displayed in the events page.
On locations page I find two locations with the same name.
in the table wp-locations of my mysql database i have two records:
the first has the fields location-id, post-id, location-slug, location-id with the correct values and other fields 0 or NULL;
the second record has all fields complete.
This is the link to my website (it is in italian): http://www.liguria-eventi.it
Do you see duplicate events under Events > Locations in WP admin?
On your site your have Palazzo Comunale listed twice, but they both have the same slug, palazzo-comunale. Usually if a location, event, or post is added twice to the database the duplicate entry would get a slug with a -2 on the end. That doesn’t seem to be happening here.
try going into admin, events-locations, open the locations in question then click update.
I have a similar issue and that solves it, obviously some bug as it should not be like that.
see here
http://wordpress.org/support/topic/slug-issue-1?replies=1
look in events-settings-general-user capabilities-subscriber-publish_locations
http://www.berkshireeventsguide.co.uk/null.jpg
both are /house-2/
if i tick that i get what you describe
This is what I see in my database: wp-locations.
@caimin-nwl: under Ecents>Location in WP admin page I see only one location.
@mrppp: i get the problema but
events-settings-general-user capabilities-subscriber-publish_locations
is untick.
I don’t think this is related to the slug issue, unless @gnardell are you submitting these events as a subscriber or an admin?
Does this happen to you every time you try this? If so, can you try deactivating your plugins and/or reverting to a default WP theme and try submitting another event to see if it still happens?
