Reset (clean up) database

  • Resolved TheMann00

    (@themann00)


    4 years, 2 months ago

    We are kind of hitting reset on Events Manager. Covid provided the opportunity to really clean it out. All events have been deleted. However, when you go into the Events dashboard, it shows over 10,000 events as a count, even though there are none actually listed.

    This likely dates back to an attempt many many years ago to bulk-delete some events via a sql command. This removed the events, but not properly. So I know what caused the issue. Now I’m just trying to fix it.

    The best method, by far, would be to uninstall and delete all tables, and then re-install. The only problem with that solution is we would lose 1,341 locations. We do NOT want to lose those. Just all the events.

    I’m looking for the best way to clean up the false records counting, or export the locations, do a fresh install of the plugin, and then import the locations back in. A lot of these locations are full content articles, with paragraphs and paragraphs of content, as well as multiple images. I don’t want to have to fix/reformat any of that.

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

  • You probably have ‘orphaned events’.

    Go to the Events Manager Settings, General, Admin Tools (Advanced).
    There you’ll find a button “Remove Orphaned Events”, which should take care of this issue.

    Always make a backup before you run some tool like this!

    Thread Starter TheMann00

    (@themann00)

    So- this is getting close. It shows
    All (10,482) | Published (10,478) | Pending (4) | Orphaned content (10478)

    But remove orphaned events only clears up 91.

    Any other ideas? Are these SUPER Orphans?

    Thread Starter TheMann00

    (@themann00)

    (by the way- When I click on the orphaned content tab- it just shows “no events found”)

    Plugin Support angelo_nwl

    (@angelo_nwl)

    you can backup your database first and then try Events > Settings > General > Admin Tools > Uninstall/Reset > Reset Then manually you can add your previous events and locations. You might need to include wp_posts and wp_postmeta where post_id is equivalent to wp_em_events post_id

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Reset (clean up) database’ is closed to new replies.