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)

  • Have you added the table aliases as described here?
    – mickadoo
    May 14, 2017 at 11:01
  • Are you using same database for drupal and civicrm or separate database?
    – Prem Patel
    May 14, 2017 at 13:14

1 Answer 1


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)

  • 1
    I actually forgot to update my settings.php file after adding a new custom data set. Everything is running OK now. Thank you all. May 15, 2017 at 16:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.