CiviCRM Community Forums (archive)

Is the Views integration code missing in 3.3.5? (I'm talking about the code that needs to be added in settings.php - this used to appear on the CMS Integration page - it doesn't in 3.3.5.)

Perhaps it's done automatically now; in any event, I'm getting the error below when I try to set up a CiviEvent calendar, which seems like it may be related.

This is a fresh install; if the modification to settings.php is, indeed, necessary in 3.3.5, people who are doing an upgrade wouldn't see this insofar as settings.php would already have the required code.

I can try pasting and modifying existing code from a 3.3.3 installation, but I'd just as soon not until I know what's going on.

Input here much appreciated - thanks!

UPDATE: Yup - looks like it's missing on the CMS Integration page, but it is required. I modified and pasted the code from the sandbox site and it looks to be working. No biggie, but it may as well be noted somewhere. Otherwise, looking good!

* user warning: Table 'scdc.civicrm_event' doesn't exist query: SELECT COUNT(*) FROM (SELECT civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title, civicrm_event.id AS id FROM civicrm_event civicrm_event WHERE (civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) AND (civicrm_event.is_template = 0) ) count_alias in [site]/sites/all/modules/views/plugins/views_plugin_pager.inc on line 142.
    * user warning: Table 'scdc.civicrm_event' doesn't exist query: SELECT civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title, civicrm_event.id AS id FROM civicrm_event civicrm_event WHERE (civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) AND (civicrm_event.is_template = 0) ORDER BY civicrm_event_start_date ASC LIMIT 0, 10 in /[site]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1144.

3.3.5 - As I mentioned, I ended up modifying and pasting the code from the Civi sandbox, where it does, indeed, appear. (The sandbox looks like it has an "internal" revision number, as opposed to being an official release.)

It's a clean install and I checked in Garland, so it's not a theme issue on my end - it just looks like it might be an oversight in the release version. Just making a note of it.

This is interesting.

This is a website I'm doing for an institution that has an acronym; let's call it SCDC. When I created the Drupal database, I created it as SCDC (all caps) out of habit; when I created the Civi database, I created it as scdc_civi (all lowercase).

In settings.php, the generated values for CIVICRM_UF_DSN and CIVICRM_DSN are the same: the Civi database. (This should not be.) I presume that if had I entered the information incorrectly upon Civi installation - which I suppose is possible though unlikely - I would have seen other problems.

As a side note, in PHPMyAdmin, whereas similarly-named databases are grouped together, these two appear as totally separate.

I did a new test install (with all lowercase-named databases) and everything works as expected. And changing the CIVICRM_UF_DSN value to the proper database seems to work fine for the site in question - and the Views code, indeed, appears.

I suppose this is an odd use case, but it's good to know that Civi checks these conditions - perhaps this will be helpful for somebody else who runs into the same issue - upper and lower case matter! Thank you for the quick and informative response and for all the excellent work you're doing!

hey stoob:

might be easier to discuss, debug and figure this out on IRC

lobo

I happened to run into this thread while restoring drupal views 2 integration to a site. I was helping to recover from a server failure with a forced migration/upgrade from 3.1 -> 3.3.5 due to a new server with php5.3. These few things may be of help if something isn't working properly. (In my case, the views module code from civicrm hadn't been put into place, and settings.php was missing the necessary entries.) This install has durpal and civicrm in separate databases.

-Make sure the contents of the folder /civicrm/drupal/modules/views from the decompressed civicrm download tarball is copied to /sites/all/modules/views.
-Make sure the output from http://your.domain.tld/civicrm/admin/setting/uf?reset=1 has been added to the drupal settings.php file. thanks @hershel
-For me, those two steps brought back the existing views 2 integration for civicrm, (and they were the last things after the recovery not working).
-If you are still having difficulties, check that civicrm.settings.php is configured properly, and check database access for the users of the databases (and what they should be based on your install type, separate, vs. combined db) though you will likely have many more problems than this if db user privileges or settings in civicrm.settings.php are mucked up.
to check privileges:
Using mysql at the command line as the root user or someone with mysql GRANT privileges (probably the user used to create the databases in the first place) may help:
SHOW GRANTS FOR `drupalorciviusername`@'localhost';
-hth