Answers.Body: <p>This error usually means .... "Drupal doesn't know the table exists" ... which either means</p>
  
  <p>1/ you have your civicrm tables in a different database and need to update the list of tables that you entered in settings.php so that drupal can connect to it</p>
  
  <p>2/ the fields have been created, but no data has been stored yet (i may be wrong but i think the table for the data is created the first time a record is saved that contains data that needs storing in the table)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-15T16:29:14.187Z
Answers.Text: I actually forgot to update my settings.php file after adding a new custom data set. Everything is running OK now. Thank you all.
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-14T20:34:02.103Z
Answers.LastActivityDate: 2017-05-14T20:34:02.103Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I want to create a View based upon civi_participants, including Participant Custom Fields.</p>
  
  <p>I can Add the custom fields, but I get the following message :</p>
  
  <p><em>SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bapaparoisse_drup_275.dr_civicrm_value_infos_parents_participants_11' doesn't exist</em></p>
  
  <p>... and the displayed view is empty.</p>
  
  <p>(Running Civi 4.7.16 / Drupal 7.54 / Views 3.16)</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-14T11:01:59.157Z
Comments.Text: Have you added the table aliases as described [here](https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration)?
Comments.UserDisplayName: mickadoo
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-14T13:14:09.800Z
Comments.Text: Are you using same database for drupal and civicrm or separate database?
Comments.UserDisplayName: Prem Patel
Tags: <civievent><custom-fields><drupal-views>
Title: Views : SQLSTATE[42S02]: Base table or view not found (concerning a Custom Value Table)
ThreadText: # Views : SQLSTATE[42S02]: Base table or view not found (concerning a Custom Value Table)
  
  (Asked by: username_0 on 2017-05-14)
  
  I want to create a View based upon civi\_participants, including Participant Custom Fields.
  
  I can Add the custom fields, but I get the following message :
  
  *SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bapaparoisse\_drup\_275.dr\_civicrm\_value\_infos\_parents\_participants\_11' doesn't exist*
  
  ... and the displayed view is empty.
  
  (Running Civi 4.7.16 / Drupal 7.54 / Views 3.16)
  
  **Tags:** civievent, custom-fields, drupal-views
  
  > **Comments:**
  > **username_1**: Have you added the table aliases as described [here](https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration)?  
  > **username_2**: Are you using same database for drupal and civicrm or separate database?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2017-05-14. Score: 4 | Accepted answer
  
  This error usually means .... "Drupal doesn't know the table exists" ... which either means
  
  1/ you have your civicrm tables in a different database and need to update the list of tables that you entered in settings.php so that drupal can connect to it
  
  2/ the fields have been created, but no data has been stored yet (i may be wrong but i think the table for the data is created the first time a record is saved that contains data that needs storing in the table)
  
  > **Comments:**
  > **username_0**: I actually forgot to update my settings.php file after adding a new custom data set. Everything is running OK now. Thank you all.  
  
  ---
  
  