I was trying to create a membership directory view in Drupal 7 but came across this error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'egyptia2_ess.droe_civicrm_membership' doesn't exist
I created the view and selected Show CiviCRM Memberships for the Content, and then after clicked continue and edit, it gave me the above error.
Double checking, I don't see that table in my MySQL database and am curious if there something I have to activate first prior to creating a view such as this one...
I'd appreciate any help - Matt