{"id":907374,"date":"2014-12-04T01:12:56","date_gmt":"2014-12-04T09:12:56","guid":{"rendered":"https:\/\/tri.be\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/"},"modified":"2014-12-22T08:53:49","modified_gmt":"2014-12-22T16:53:49","slug":"delete-all-records-because-of-duplication-bug","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/","title":{"rendered":"Delete all records because of duplication bug"},"content":{"rendered":"<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&#8217;ve 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 \/>\n     I&#8217;ve 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&#8217;s probably been fixed by now. But I have the problem of not being able to get rid of all the duplicate entries. I&#8217;ve 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&#8217;t 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 \/>\n     I love the plugin,  but unfortunately this has caused a decent waste of time now already between trying to delete things manually, searching FAQ&#8217;s, forums, downloading and trying various plugins, and now writing in for help.<br \/>\nThanks,<br \/>\n-Dave<\/p>\n","protected":false},"template":"","class_list":["post-907374","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 -<\/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\/\" \/>\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 -\" \/>\n<meta property=\"og:description\" content=\"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&#8217;ve updated it every quarter or so and at 1 point, a LOT of events got duplicated, I have [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/\" \/>\n<meta property=\"article:modified_time\" content=\"2014-12-22T16:53:49+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=\"2 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\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/\",\"name\":\"Delete all records because of duplication bug -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2014-12-04T09:12:56+00:00\",\"dateModified\":\"2014-12-22T16:53:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/#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\"}]},{\"@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 -","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\/","og_locale":"en_US","og_type":"article","og_title":"Delete all records because of duplication bug -","og_description":"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&#8217;ve updated it every quarter or so and at 1 point, a LOT of events got duplicated, I have [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/","article_modified_time":"2014-12-22T16:53:49+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/","name":"Delete all records because of duplication bug -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2014-12-04T09:12:56+00:00","dateModified":"2014-12-22T16:53:49+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/delete-all-records-because-of-duplication-bug\/#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"}]},{"@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\/907374","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\/907374\/revisions"}],"predecessor-version":[{"id":923783,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/907374\/revisions\/923783"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=907374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}