Need to Delete Hundreds of Duplicate Events

Home Forums Ticket Products Event Tickets Plus Need to Delete Hundreds of Duplicate Events

Viewing 6 posts - 16 through 21 (of 21 total)
  • Author
    Posts
  • #1081125
    Nico
    Member

    This reply is private.

    #1081543
    lishal
    Participant

    Yes, I’ll be happy with the SQL dump. Thank you all so much for helping me with this.

    #1082083
    Nico
    Member

    Thanks for confirming! I’ll give you a heads up on this when ready…

    #1084347
    George
    Participant

    Hi Lishal,

    Thank you for your patience with us on these issues! There are some odd tangles in the code we have been ironing out to figure out the best course of action here.

    There are a few courses of action, each with their own positives and negatives, so I will describe each of the courses of action in a simple way here for you to choose what to do.

    Before doing ANY of the methods here, please make a fresh and complete backup of your site and database. This is just for security and backup, and your data should be fine with any of the following methods. But a good, thorough, new backup is just a smart thing to do. We do NOT recommend proceeding without a backup, as you could lose data. If you proceed without a backup it is against our recommendation.


    Method 1: Downgrade to 4.0 and Run the “Cleanup” Plugin from Before

    This may be the simplest option here. Essentially, what you would do is delete the existing plugin files off of your site for The Events Calendar, Events Calendar Pro, and any other Tribe plugins.

    This will not delete event data.

    Once the existing versions are deleted, replace them with 4.0.0 versions of each piece of software. You can get 4.0.0 files from http://theeventscalendar.com/my-account/downloads.

    Install the 4.0.0 versions and activate them. Then, install the cleanup plugin (https://cloudup.com/cPv3ZMX8Zd0) and do the steps that Nico shared above (https://theeventscalendar.com/support/forums/topic/need-to-delete-hundreds-of-duplicate-events/#post-1071002)

    Once the cleanup is done, delete the 4.0.0 versions and install the most up-to-date versions in their stead.


    Method 2: Delete Events then Replace

    With this second method, you would not have to delete/reinstall any software.

    What you would do, however, is delete all of your existing events that have duplication problems.

    Once deleted, you would then use the WordPress Importer (not The Events Calendar’s own importer tool—the WP importer at your wp-admin’s Tools > Importer menu item!) to import this file which has all of the duplicates removed: https://cloudup.com/cqZ1zWxWpaG

    That link is to a .zip, so you would need to unzip that first of course. It’s an XML file with all of the cleaned events.

    Method 3: DB Dump

    The database dump is NOT RECOMMENDED unless you are SKILLED with database management and know exactly what you are doing here. Doing this DB Dump incorrectly could mess up your DB tables and such.

    This method is basically the same as Method 2, but instead of deleting existing events in your wp-admin, you would delete the existing Database equivalents…and then replace with the DB dump available as a .zip here → https://cloudup.com/cp_JWt9QjRc


    I personally would recommend Method 1 or 2. And remember, do not proceed with a complete fresh backup of your site and database.

    I hope this helps!

    — George

    #1087850
    lishal
    Participant

    OK, that did it. I ended up going with the DB Dump because the downgrade didn’t help, but everything is normal now. Thank you so much!

    #1087854
    George
    Participant

    Glad to hear it! Thanks for your patience, @lishal!

    🙂

Viewing 6 posts - 16 through 21 (of 21 total)
  • The topic ‘Need to Delete Hundreds of Duplicate Events’ is closed to new replies.