{"id":1183494,"date":"2016-10-26T17:35:11","date_gmt":"2016-10-27T00:35:11","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/"},"modified":"2016-10-26T17:35:11","modified_gmt":"2016-10-27T00:35:11","slug":"bad-event-bad-sql","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/","title":{"rendered":"Bad Event \/ Bad SQL"},"content":{"rendered":"<p>BI, this is a continuation of an issue that was previously solved by Brook. The solution was to run a sql that deleted our bad events. It worked perfectly, then. But we are having the issue again and the sql statement that he gave us previously is failing now (did the db structure change with the latest version?).<\/p>\n<p>Here is the previous post:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"cqJivvpyTP\"><p><a href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cant-load-may-calendar\/\">Can&#039;t Load May Calendar<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Can&#039;t Load May Calendar&#8221; &#8212; \" src=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cant-load-may-calendar\/embed\/#?secret=Gvl7ZrL2R4#?secret=cqJivvpyTP\" data-secret=\"cqJivvpyTP\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>Can we get an updated sql statement that would successfully erase the bad events in our db?<\/p>\n<p>Thanks!<\/p>\n","protected":false},"template":"","class_list":["post-1183494","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>Bad Event \/ Bad SQL -<\/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\/bad-event-bad-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bad Event \/ Bad SQL -\" \/>\n<meta property=\"og:description\" content=\"BI, this is a continuation of an issue that was previously solved by Brook. The solution was to run a sql that deleted our bad events. It worked perfectly, then. But we are having the issue again and the sql statement that he gave us previously is failing now (did the db structure change with [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/\",\"name\":\"Bad Event \/ Bad SQL -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-10-27T00:35:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/#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\":\"Bad Event \/ Bad SQL\"}]},{\"@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":"Bad Event \/ Bad SQL -","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\/bad-event-bad-sql\/","og_locale":"en_US","og_type":"article","og_title":"Bad Event \/ Bad SQL -","og_description":"BI, this is a continuation of an issue that was previously solved by Brook. The solution was to run a sql that deleted our bad events. It worked perfectly, then. But we are having the issue again and the sql statement that he gave us previously is failing now (did the db structure change with [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/","name":"Bad Event \/ Bad SQL -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-10-27T00:35:11+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bad-event-bad-sql\/#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":"Bad Event \/ Bad SQL"}]},{"@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\/1183494","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":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1183494\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1183494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}