Title: [Location_List] shortcode issue
Last modified: February 4, 2022

---

# [Location_List] shortcode issue

 *  Resolved [chrishe](https://wordpress.org/support/users/chrishe/)
 * (@chrishe)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/location_list-shortcode-issue/)
 * HI Marcus,
    Events Manager is great! Thanks for all you work. I have found the
   the list of locations on front-side using the [location_list] shortcode shows
   several locations that do NOT show on the dashboard list. I bit of research shows
   that the em_locations table has them all, but the ones I don’t want have a post_ID
   that no longer exists!
 * Is it possible to “remove orphan locations” to clean these away – basically delete
   em_location records that have a post_id pointing to a non-existant record in 
   the Posts table.
 * Many thanks
    Chris

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [chrishe](https://wordpress.org/support/users/chrishe/)
 * (@chrishe)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/location_list-shortcode-issue/#post-15331692)
 * note:
    for my (single) site this query pulls out the location records that point
   to a non-existent wp_posts record `SELECT wp_posts.ID, wp_em_locations.* FROM
   wp_em_locations LEFT JOIN wp_posts ON ID=post_id WHERE ID IS NULL` and finds 
   60 matching records
 * I don’t know whether deleting those em_locations records has any wider implications,
   but if it was possible to add similar to dashboard to clean them up that would
   be great!
 *  Thread Starter [chrishe](https://wordpress.org/support/users/chrishe/)
 * (@chrishe)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/location_list-shortcode-issue/#post-15331836)
 * Further, since the above locations DO appear when creating an event, they may
   actually be used. In which case would need to ADD a new valid post with post_type
   = location to replace the missing post
    Hmmm… P.S. it appears the locations were
   all created appox. 10 years ago when the _original_ site was created. The site
   was since moved so the post guids all point to a non-existing address!
 * Help please!
 *  Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * (@angelo_nwl)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/location_list-shortcode-issue/#post-15394947)
 * Thank you, I’m going to check on this and inform the Devs.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘[Location_List] shortcode issue’ 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

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

 * 3 replies
 * 2 participants
 * Last reply from: [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/location_list-shortcode-issue/#post-15394947)
 * Status: resolved