{"id":1116269,"date":"2016-05-19T01:05:32","date_gmt":"2016-05-19T08:05:32","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/"},"modified":"2016-05-31T07:46:48","modified_gmt":"2016-05-31T14:46:48","slug":"sql-error-syntax-triggered-by-monthly-view","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/","title":{"rendered":"SQL error syntax triggered by Monthly view"},"content":{"rendered":"<p>Display of the page which is displaying monthly view calendar is triggering an SQL error syntax in log file.<\/p>\n<p>This error is added in log file at every call of this monthly view calendar;<br \/>\napparently on field name is unknown or badly spelt &#8230;<\/p>\n<p>[Thu May 19 01:44:52.114080 2016] [:error] [pid 19931] [client 192.168.0.216:48663]<br \/>\nErreur de la base de donn\\xc3\\xa9es WordPress<br \/>\nUnknown column &#8216;home_postmeta.meta_value&#8217; in &#8216;field list&#8217; pour la requ\\xc3\\xaate<\/p>\n<p>SELECT  DISTINCT home_posts.*, MIN(home_postmeta.meta_value) as EventStartDate, MIN(tribe<br \/>\n_event_end_date.meta_value) as EventEndDate<br \/>\nFROM home_posts<br \/>\nINNER JOIN home_term_relationships ON (home_posts.ID = home_term_relationships.object_id)<br \/>\n LEFT JOIN home_postmeta as tribe_event_end_date ON ( home_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = &#8216;_EventEndDate&#8217; )<br \/>\nWHERE 1=1  AND ( \\n  home_term_relationships.term_taxonomy_id IN (67)\\n) AND home_posts.post_type = &#8216;tribe_events&#8217; AND (home_posts.post_status = &#8216;<br \/>\npublish&#8217; OR home_posts.post_status = &#8216;complete&#8217; OR home_posts.post_status = &#8216;paid&#8217; OR home_posts.post_status = &#8216;confirmed&#8217; OR home_posts.post_status =<br \/>\n &#8216;unpaid&#8217; OR home_posts.post_status = &#8216;pending-confirmation&#8217; OR home_posts.post_status = &#8216;cancelled&#8217;)<br \/>\nGROUP BY home_posts.ID ORDER BY EventStartDate DESC, home_posts.post_date DESC LIMIT 0, 1<br \/>\nfaite par require(&#8216;wp-blog-header.php&#8217;), wp, WP-&gt;main, WP-&gt;query_posts, WP_Query-&gt;query, WP_Query-&gt;get_posts<\/p>\n","protected":false},"template":"","class_list":["post-1116269","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>SQL error syntax triggered by Monthly view -<\/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\/sql-error-syntax-triggered-by-monthly-view\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL error syntax triggered by Monthly view -\" \/>\n<meta property=\"og:description\" content=\"Display of the page which is displaying monthly view calendar is triggering an SQL error syntax in log file. This error is added in log file at every call of this monthly view calendar; apparently on field name is unknown or badly spelt &#8230; [Thu May 19 01:44:52.114080 2016] [:error] [pid 19931] [client 192.168.0.216:48663] Erreur [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-05-31T14:46:48+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\/sql-error-syntax-triggered-by-monthly-view\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/\",\"name\":\"SQL error syntax triggered by Monthly view -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-05-19T08:05:32+00:00\",\"dateModified\":\"2016-05-31T14:46:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/#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\":\"SQL error syntax triggered by Monthly view\"}]},{\"@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":"SQL error syntax triggered by Monthly view -","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\/sql-error-syntax-triggered-by-monthly-view\/","og_locale":"en_US","og_type":"article","og_title":"SQL error syntax triggered by Monthly view -","og_description":"Display of the page which is displaying monthly view calendar is triggering an SQL error syntax in log file. This error is added in log file at every call of this monthly view calendar; apparently on field name is unknown or badly spelt &#8230; [Thu May 19 01:44:52.114080 2016] [:error] [pid 19931] [client 192.168.0.216:48663] Erreur [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/","article_modified_time":"2016-05-31T14:46:48+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\/sql-error-syntax-triggered-by-monthly-view\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/","name":"SQL error syntax triggered by Monthly view -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-05-19T08:05:32+00:00","dateModified":"2016-05-31T14:46:48+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/sql-error-syntax-triggered-by-monthly-view\/#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":"SQL error syntax triggered by Monthly view"}]},{"@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\/1116269","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":2,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1116269\/revisions"}],"predecessor-version":[{"id":1120624,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1116269\/revisions\/1120624"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1116269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}