CiviCRM Community Forums (archive)

Could I please ask for a bit more help with this?  I'm getting the same error messages.

a) My host only gives me one database, so I can't do the separate database solution. I have my tables prefixed with drupal_ and civicrm_ respectively.

b) I don't really care about a calendar view, but I do want to display civicrm events listings in drupal.  I followed the instructions for integrating drupal's calendar module and civievents (was this overkill?), and the 'upcoming events' block and individual events listings are displaying just fine. I do get that Table 'xxx.drupal_civicrm_event' doesn't exist message on the view admin page though - isn't that a bit odd, since the block works?  Anyway, I want to create an events list page with more detail for all listings, but I get those errors and the page doesn't work. 

I found the above discussion a bit hard to follow, so not sure whether I should be able to make this work or should be giving up.
I tried Herschel's trick going to civicrm/admin/setting/uf?reset=1 but that only allows me to specify the drupal user table.  Is there something more fundamental I need to set for views integration?

I'd appreciate a steer to the relevant docs or some tips please, as I'm struggling to help myself.

Thanks,
Julie

Sorry Herschel, I did read carefully what you wrote, and didn't mean to cause offence.  I suspect my config is different somehow.  When I go to that url I get the page

Home › CiviCRM › Administer CiviCRM › Global Settings ›
Settings - Drupal Integration

...which gives me a form to set the drupal version and user table only.  I don't see any instructions or code or anything that sounds like it relates to views.  Could you perhaps describe the page or its title so I know what to look for, rather than giving me a url?

Thanks for helping.
Julie

Thanks, I found this page http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module which gave me the code to add to settings.php - that seems to have solved the problem.

BUT, while trying to delete a particular page out of the civicrm_events view, I accidentally managed to delete the whole view (blush). Can I get an import file somewhere to recreate it?

Thanks lobo.  Could I trouble you for a little more info on what to do with this?  I tried going to the import tab and pasting the content of the .inc file into it, but I wasn't sure whether to include or exclude the <?php tag, or even whether that was the right thing to do.  It clearly wasn't, since I kept getting "Unable to interpret view code", although... that might be fckeditor getting in the way..?

Thanks herschel, that looks like it would have worked if I still had the calendar module installed, so I think I know what to do now :-)

In the Edit View screen, did you create a Page and assign the path 'events'? IIRC that step is necessary.