{"id":929640,"date":"2015-01-06T19:23:02","date_gmt":"2015-01-07T03:23:02","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/"},"modified":"2015-05-13T23:42:22","modified_gmt":"2015-05-14T06:42:22","slug":"delete-all-records-because-of-duplication-bug-pt-2","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/","title":{"rendered":"Delete all records because of duplication bug, pt 2"},"content":{"rendered":"<p>You guys closed the original thread without even asking if it was resolved. I hadn&#8217;t responded for 2 weeks because it was christmas time&#8230; Here is the problem description again:<\/p>\n<p>Hey guys, love the event calendar plugin, but I have a huge problem now. About a year or two ago I upgraded to the Pro version and helped the client create some recurring events. Since then I\u2019ve updated it every quarter or so and at 1 point, a LOT of events got duplicated, I have over 120,000 events instead of about 400. I need to erase everything and start fresh.<br \/>\nI\u2019ve searched through the forums here and found many many many people posting the same problem, with no luck on a verified solution. I know the issue was only for an older version (3.5-ish?), and now I have the newest version of 3.8.1 so it\u2019s probably been fixed by now. But I have the problem of not being able to get rid of all the duplicate entries. I\u2019ve read into, and tried the solutions offered of pressing the button in the plugin settings screen to consolidate duplicates, downloading and running the hotfix plugin to consolidate them, and even the Event Rocket plugin for deleting all event data to start fresh. The last option is the only one that kind of works, but the problem is that it only deletes about 120 events at a time, then hangs at about 1 minute. I tried letting it go for 2 hours, but it didn\u2019t do anything after that initial minute with the 120. It varies between 80-150 each time. the problem is that with 119,204 events left, it would take me 993 more times of doing that to get it to zero, and each time takes about 2 minutes because loading is so bogged down. I need to completely erase all events or the database or whatever it takes to start fresh, how can I do that?<br \/>\nI love the plugin, but unfortunately this has caused a decent waste of time now already between trying to delete things manually, searching FAQ\u2019s, forums, downloading and trying various plugins, and now writing in for help.<br \/>\nThanks,<br \/>\n-Dave<\/p>\n<p>The issue is still not resolved, and as I painstakingly delete the duplicate entries; they are being deleted, but also at the same time editing themselves and putting themselves into this months calendar after I just deleted the ones from this month so the client could use the calendar still. I&#8217;ve spent weeks upon weeks trying to fix this problem, with no solution in sight. I searched the forums prior to opening my thread and tried those solutions already. I clearly stated this, and was given the advice to try them again. That obviously didn&#8217;t work just like the first time I tried them. I have lost all faith in your company and will not be renewing any of my several accounts when up for renewal, and will be telling all of my fellow web designers to stay far away from Tribe if you guys can&#8217;t come up with a fix for this.<\/p>\n<p>Here&#8217;s the link to my thread from last month: https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/?source=tri.be#post-911626<\/p>\n<p>How is it so hard to wipe my events database and start fresh? Barry did give me one possible option of crafting some SQL and running it directly into my database. This was the only helpful advice, but a little out of my realm. I&#8217;d do it if there is no other option as a last-ditch effort since it could affect my entire wordpress database, but I&#8217;ll need a little more specific instructions. Can this get escalated to someone who can help solve my issue?? I&#8217;ve been deleting events for over a month now, starting with over 120,000 duplicate events and I&#8217;m only down to 70,000. I&#8217;ve lost hundreds of dollars in productivity because of this and can&#8217;t keep this up any longer. Also, the website becomes unreachable while using your Duplicate Cleanup Plugin, which is the only thing that kind of works. My clients website has been down for over 50 hours already, and still needs 65 more hours of downtime to clean the rest of them up. So far this has involved me to initiate the cleanup plugin in the middle of the night when traffic is at it&#8217;s least. The cleanup plugin deletes the duplicate records at about 1,275 per hour. The website becomes unreachable during this time, and for a few hours after the operation stops. Bottom line: Your plugin duplicated it&#8217;s own events over a hundred thousand times, and the possible fixes provided so far have not been able to fix the issue. Please help me clear out all events so I can start again from zero events. Also support threads shouldn&#8217;t just be closed without asking if they&#8217;ve been resolved. There are many many threads just like mine that were closed without a fix, also. <\/p>\n","protected":false},"template":"","class_list":["post-929640","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Delete all records because of duplication bug, pt 2 -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delete all records because of duplication bug, pt 2 -\" \/>\n<meta property=\"og:description\" content=\"You guys closed the original thread without even asking if it was resolved. I hadn&#8217;t responded for 2 weeks because it was christmas time&#8230; Here is the problem description again: Hey guys, love the event calendar plugin, but I have a huge problem now. About a year or two ago I upgraded to the Pro [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/\" \/>\n<meta property=\"article:modified_time\" content=\"2015-05-14T06:42:22+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/\",\"name\":\"Delete all records because of duplication bug, pt 2 -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2015-01-07T03:23:02+00:00\",\"dateModified\":\"2015-05-14T06:42:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Delete all records because of duplication bug, pt 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Delete all records because of duplication bug, pt 2 -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/","og_locale":"en_US","og_type":"article","og_title":"Delete all records because of duplication bug, pt 2 -","og_description":"You guys closed the original thread without even asking if it was resolved. I hadn&#8217;t responded for 2 weeks because it was christmas time&#8230; Here is the problem description again: Hey guys, love the event calendar plugin, but I have a huge problem now. About a year or two ago I upgraded to the Pro [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/","article_modified_time":"2015-05-14T06:42:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/","name":"Delete all records because of duplication bug, pt 2 -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2015-01-07T03:23:02+00:00","dateModified":"2015-05-14T06:42:22+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug-pt-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"Delete all records because of duplication bug, pt 2"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/929640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/929640\/revisions"}],"predecessor-version":[{"id":930137,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/929640\/revisions\/930137"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=929640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}