{"id":56356,"date":"2013-07-22T11:02:57","date_gmt":"2013-07-22T18:02:57","guid":{"rendered":"http:\/\/tri.be\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/"},"modified":"2015-07-07T06:29:27","modified_gmt":"2015-07-07T13:29:27","slug":"instances-of-recurring-event-disappearing-after-edit-2","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/","title":{"rendered":"Instances of recurring event disappearing after edit"},"content":{"rendered":"<p>When ECP saves a recurring event the saveEvents function saves a _EventStartDate row in wp_postmeta for each date that the event recurs. The function saves these rows in date order, starting with the earliest date. But, when a program retrieves these values with get_post_meta(), the database query doesn&#8217;t always return them in the same order. (There is no ORDER BY clause in the query that get_post_meta runs.)<\/p>\n<p>This causes three problems in Events Calendar Pro:<br \/>\n1. The instance with the first-retrieved _EventStartDate (not always the earliest instance) is the only instance that appears in List view (or list widget) if the &#8220;Recurring event instances&#8211;Show only the first instance of each recurring event&#8221; setting is checked.<\/p>\n<p>2. The instance with the first-retrieved _EventStartDate is the instance displayed if a visitor&#8217;s requests the URL of the event without specifying a date. For example, &#8220;\/event\/buzzards-bay\/&#8221; instead of &#8220;\/event\/buzzards-bay\/2013-08-05\/&#8221;.<\/p>\n<p>3. If the first-retrieved _EventStartDate is not the earliest instance of the event, and the earliest instance of the event is edited and saved (choosing &#8220;All events&#8221; from the &#8220;Saving Recurring Events&#8221; dialog), then the first-retrieved _EventStartDate will disappear from wp_postmeta and the event will no longer appear on that date in the various calendar views. The recurrence rule will not change, and ECP will still treat all the remaining instances as part of one recurring event.<\/p>\n<p>I understand that you may have difficulty reproducing this problem, because it depends on the behavior of your database, which you cannot control directly. If I edit\/update the event a few times, it always appears for me eventually, usually within 2-3 tries; it&#8217;s easiest to see by watching the database table in phpMyAdmin after each update.<\/p>\n","protected":false},"template":"","class_list":["post-56356","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>Instances of recurring event disappearing after edit -<\/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\/instances-of-recurring-event-disappearing-after-edit-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Instances of recurring event disappearing after edit -\" \/>\n<meta property=\"og:description\" content=\"When ECP saves a recurring event the saveEvents function saves a _EventStartDate row in wp_postmeta for each date that the event recurs. The function saves these rows in date order, starting with the earliest date. But, when a program retrieves these values with get_post_meta(), the database query doesn&#8217;t always return them in the same order. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/\" \/>\n<meta property=\"article:modified_time\" content=\"2015-07-07T13:29:27+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/\",\"name\":\"Instances of recurring event disappearing after edit -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2013-07-22T18:02:57+00:00\",\"dateModified\":\"2015-07-07T13:29:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-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\":\"Instances of recurring event disappearing after edit\"}]},{\"@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":"Instances of recurring event disappearing after edit -","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\/instances-of-recurring-event-disappearing-after-edit-2\/","og_locale":"en_US","og_type":"article","og_title":"Instances of recurring event disappearing after edit -","og_description":"When ECP saves a recurring event the saveEvents function saves a _EventStartDate row in wp_postmeta for each date that the event recurs. The function saves these rows in date order, starting with the earliest date. But, when a program retrieves these values with get_post_meta(), the database query doesn&#8217;t always return them in the same order. [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/","article_modified_time":"2015-07-07T13:29:27+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/","name":"Instances of recurring event disappearing after edit -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2013-07-22T18:02:57+00:00","dateModified":"2015-07-07T13:29:27+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/instances-of-recurring-event-disappearing-after-edit-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":"Instances of recurring event disappearing after edit"}]},{"@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\/56356","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\/56356\/revisions"}],"predecessor-version":[{"id":981828,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/56356\/revisions\/981828"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=56356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}