Answers.Body: <p>0.9.14 is still the beta version.  Go into the Venti_EventManageService file and delete the two lines with this string <code>craft()-&gt;templateCache-&gt;deleteCachesByElement($element);</code>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-19T21:38:46.020Z
Answers.Text: I've followed your instructions, commenting out those 2 instances of `craft()->templateCache->deleteCachesByElement($element);`, and I have cancelled all failed tasks, followed by clearing the caches. Let's see how it pans out tomorrow. Thanks for your swift response.
Answers.UserDisplayName: Adam Menczykowski
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-20T12:51:51.583Z
Answers.Text: That seems to have fixed it. No failed tasks since doing what you said. Thanks so much!
Answers.UserDisplayName: Adam Menczykowski
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-19T21:17:15.357Z
Answers.LastActivityDate: 2016-01-19T21:17:15.357Z
Answers.UserDisplayName: a-am
Body: <p>As you can see from the craft.log, venti is causing an issue with template refresh:</p>
  
  <pre><code>2016/01/19 10:59:27 [info] [application] [Forced] Starting step 242 of 828 total steps.
  
  2016/01/19 10:59:27 [info] [application] [Forced] Starting step 243 of 828 total steps.
  
  2016/01/19 10:59:27 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'venti.startDate' in 'order clause'. The SQL statement executed was: SELECT `elements`.`id`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`
  
  FROM `craft_elements` `elements`
  
  JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
  
  JOIN `craft_content` `content` ON content.elementId = elements.id
  
  JOIN `craft_entries` `entries` ON entries.id = elements.id
  
  JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
  
  LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
  
  WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements_i18n.enabled = 1)
  
  GROUP BY `elements`.`id`
  
  ORDER BY `venti`.`startDate` ASC LIMIT 5.
  
  2016/01/19 10:59:27 [error] [application] Encountered an error running task 5 (DeleteStaleTemplateCaches), step 243 of 828: An exception was thrown: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'venti.startDate' in 'order clause'
  </code></pre>
  
  <p>Has anybody else had this issue? Frustrating as it means my cache isn't working properly, causing 'Failed Task' to show up in the Admin for the client and I'm not sure but may be affecting other areas of the site.</p>
  
  <p>Thanks in advance.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-19T18:28:36.703Z
Comments.Text: I'm guessing that will end up being a bug... have you tried contacting the [developer](https://venti.helpdocs.com/)?
Comments.UserDisplayName: Brad Bell
Tags: <plugins>
Title: Venti Events causing failed DeleteStaleTemplateCaches task
ThreadText: # Venti Events causing failed DeleteStaleTemplateCaches task
  
  (Asked by: username_0 on 2016-01-19)
  
  As you can see from the craft.log, venti is causing an issue with template refresh:
  
  ```
  2016/01/19 10:59:27 [info] [application] [Forced] Starting step 242 of 828 total steps.
  
  2016/01/19 10:59:27 [info] [application] [Forced] Starting step 243 of 828 total steps.
  
  2016/01/19 10:59:27 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'venti.startDate' in 'order clause'. The SQL statement executed was: SELECT `elements`.`id`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`
  
  FROM `craft_elements` `elements`
  
  JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
  
  JOIN `craft_content` `content` ON content.elementId = elements.id
  
  JOIN `craft_entries` `entries` ON entries.id = elements.id
  
  JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
  
  LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
  
  WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements_i18n.enabled = 1)
  
  GROUP BY `elements`.`id`
  
  ORDER BY `venti`.`startDate` ASC LIMIT 5.
  
  2016/01/19 10:59:27 [error] [application] Encountered an error running task 5 (DeleteStaleTemplateCaches), step 243 of 828: An exception was thrown: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'venti.startDate' in 'order clause'
  
  ```
  
  Has anybody else had this issue? Frustrating as it means my cache isn't working properly, causing 'Failed Task' to show up in the Admin for the client and I'm not sure but may be affecting other areas of the site.
  
  Thanks in advance.
  
  **Tags:** plugins
  
  > **Comments:**
  > **username_1**: I'm guessing that will end up being a bug... have you tried contacting the [developer](https://venti.helpdocs.com/)?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-01-19. Score: 1 | Accepted answer
  
  0.9.14 is still the beta version. Go into the Venti\_EventManageService file and delete the two lines with this string `craft()->templateCache->deleteCachesByElement($element);`.
  
  > **Comments:**
  > **username_0**: I've followed your instructions, commenting out those 2 instances of `craft()->templateCache->deleteCachesByElement($element);`, and I have cancelled all failed tasks, followed by clearing the caches. Let's see how it pans out tomorrow. Thanks for your swift response.  
  > **username_0**: That seems to have fixed it. No failed tasks since doing what you said. Thanks so much!  
  
  ---
  
  