Answers.Body: <p>To see the SQL query when in edit mode of the view, select the ‘Show the SQL query’ option here - /admin/structure/views/settings</p>
  
  <p>This may assist –</p>
  
  <ol>
  <li><p>Clear views’ cache - /admin/structure/views/settings/advanced</p></li>
  <li><p>If that doesn’t fix it then update your settings.php file if you have separate databases - <a href="https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/#drupal-7" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/#drupal-7</a></p></li>
  </ol>
  
  <p>Clear CiviCRM/Drupal caches. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-25T20:47:31.733Z
Answers.Text: I forgot to clear views' cache...
Answers.UserDisplayName: Felix
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-25T17:17:48.223Z
Answers.LastActivityDate: 2019-02-25T17:17:48.223Z
Answers.UserDisplayName: Anil
Body: <p>After recent update (I think to 5.10.2) events don't show up. Interestingly, I can see the pager (1 2 next last) but not the events themselves. I <em>can</em> see the events in the Event Dashboard.</p>
  
  <p>When I try to <code>Edit View</code> in Drupal, I see the following error</p>
  
  <blockquote>
    <p><code>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM civicrm.civicrm_event civicrm_event LIMIT 20 OFFSET 0' at line 1</code></p>
  </blockquote>
  
  <p>and all fields show <code>Broken/missing handler</code></p>
  
  <p>I am pretty sure it could be a clue - but how can I see the actual SQL that is throwing the error? There is nothing in the log file</p>
  
  <p>I update both Drupal and Civi to the latest versions (7.64 and 5.10.4) but no impact</p>
  
Tags: <civievent><drupal><drupal-views>
Title: Can't see events
ThreadText: # Can't see events
  
  (Asked by: username_0 on 2019-02-25)
  
  After recent update (I think to 5.10.2) events don't show up. Interestingly, I can see the pager (1 2 next last) but not the events themselves. I *can* see the events in the Event Dashboard.
  
  When I try to `Edit View` in Drupal, I see the following error
  
  > `SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM civicrm.civicrm_event civicrm_event LIMIT 20 OFFSET 0' at line 1`
  
  and all fields show `Broken/missing handler`
  
  I am pretty sure it could be a clue - but how can I see the actual SQL that is throwing the error? There is nothing in the log file
  
  I update both Drupal and Civi to the latest versions (7.64 and 5.10.4) but no impact
  
  **Tags:** civievent, drupal, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-02-25. Score: 2 | Accepted answer
  
  To see the SQL query when in edit mode of the view, select the ‘Show the SQL query’ option here - /admin/structure/views/settings
  
  This may assist –
  
  1. Clear views’ cache - /admin/structure/views/settings/advanced
  2. If that doesn’t fix it then update your settings.php file if you have separate databases - <https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/#drupal-7>
  
  Clear CiviCRM/Drupal caches.
  
  > **Comments:**
  > **username_0**: I forgot to clear views' cache...  
  
  ---
  
  