Title: Orphaned locations
Last modified: December 26, 2023

---

# Orphaned locations

 *  Resolved [markburton52](https://wordpress.org/support/users/markburton52/)
 * (@markburton52)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/orphaned-locations/)
 * I have some phantom locations in the WP database, I think as a result of a failed
   data upload.
 * Using the shortcode [locations_list pagination=”1″] (in a draft post), we get
   a list of locations. Some locations have multiple entries.
 * e.g. for ‘location name’,
 * [https://chorltonartsfestival.org/locations/location_name](https://chorltonartsfestival.org/locations/location_name)
 * [https://chorltonartsfestival.org/?p=6930&preview=true](https://chorltonartsfestival.org/?p=6930&preview=true)
 * [https://chorltonartsfestival.org/?p=6930&preview=true](https://chorltonartsfestival.org/?p=6930&preview=true)
 * The second two are invalid URLs but they render on the locations list page as
   having ‘location_name’ . The URL takes you back to the page you are on.
 * In the EM admin screens (General>Admin Tools (Advanced) there is a tool, ‘Database
   Cleanup’. That worked for a similar problem with phantom (i.e. orphaned) events.
   However, there is no such function for locations.
   Could that be added, or, is
   there a straightforward workaround? I can edit the database for the locations
   manually, deleting the rogue locations, but that takes considerable time, working
   through each one and checking which should be genuine. N.B. It isn’t a simple
   matter of the status flag: both the phantom locations and the real ones have 
   a flag of 1.

The topic ‘Orphaned locations’ is closed to new replies.

 * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=3550347)
 * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 0 replies
 * 1 participant
 * Last reply from: [markburton52](https://wordpress.org/support/users/markburton52/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/orphaned-locations/)
 * Status: resolved