• chrishe

    (@chrishe)


    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

    (@chrishe)

    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

    (@chrishe)

    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

    (@angelo_nwl)

    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.