CiviCRM Community Forums (archive)

Hi all,

I haven't been able to find an answer to this while searching, but perhaps someone can point me in the right direction if it's already been asked.

I have CiviCRM and Views 2 integration working fine on my Drupal site, but every day or so the custom data fields become unavailable to views and therefore Views filters relying on these custom fields no longer work.  Clearing the views cache fixes the problem and brings back the custom fields and my Civi data displays correctly.

Anyone got any suggestions on how to fix this so I don't have to keep manually clearing the views cache?

Cheers,
Erica.

A possible solution would be to make a small Drupal module which simply clears the Views cache when cron runs. That should solve your problem I would think.

Hello!

I'm new to the forums; and working with CiviCRM for the first time.  I know this thread is over a year old, but I'm bumping it rather than creating a new topic because this thread is the most closely related to my problem that I can find to date, and was left unresolved.  Other threads mention specific broken Views handlers, but those issues seem to revolve around version specific bugs.  What I'm experiencing is more general, just like the original post in this thread:

• I build, for instance, a CiviCRM Contacts view and select a combination of CiviCRM core contact fields and custom fields that I've created for the relevant contact types (Views 2.16)
• Everything looks great and the view performs flawlessly for an indeterminate amount of time (~1 day)
• Suddenly all CiviCRM custom fields are broken/missing handlers, but the core fields still work fine.  (see attached screenshot)

FWIW - I'm running CiviCRM 3.4.6 in Drupal 6.22 on the Aegir Hosting System, using provision_civicrm to handle install and config file generation, etc.  However, I don't suspect any of that is the source of my problem.  Everything otherwise is working perfectly, and the issue definitely also happens within intervals where no activity or work on the site has occurred.

Furthermore, if I take the query that Views preview generates, paste it in a new page, run it on page load, and print the resulting array structure to the screen; I see the values of my custom data fields, and that page will continue to work even *after* the source view itself becomes degraded again!  So I'm feeling confident that it's not an issue with custom data db table names (the table joins still work on the static test page I just mentioned), or a problem with the CiviCRM config files, or any issues with Aegir tasks, etc.

I tried Hershel's suggestion of creating a cron hook to automate a fix, but surprisingly, calling even cache_clear_all() in a cron hook every hour does not "fix" the problem.  And yet, clearing the views cache on /admin/build/views/tools or running "drush cc all" etc will all fix it temporarily.  It's possible I messed this up somehow, but I am at least confirming the cron hook runs via watchdog entries.

I'm getting pretty confused with this one, and it's becoming a blocking issue.  It's pretty clear that I've hit some corner case (likely non-version-specific) that hardly anyone else has encountered, or there would be more information/discussion at this point.  If anyone has any ideas or could point me in a new direction, I'd be grateful, because this has been difficult to debug.  The Views integration with CiviCRM is awesome; I would really hate to have to abandon it for now if I can't get this figured out.

Thanks in advance to anyone reading this who can take a moment to help!

Hi Eileen -

Thanks for your reply.  I have 3 Organization sub-types defined: Nonprofit, Business, Consultant.  I have 4 Custom Field Sets defined: Organization Details (Type: Any), Nonprofit Details (Type: Nonprofit), Business Details (Type: Business), Consultant Details (Type: Consultant).  There are several custom fields in each set, none are multi-value sets.

In my earlier screenshot, the  selected custom fields from the Any Organization set as well as the Nonprofit Organization set.  All fields from both are broken.  Can you provide any further detail about the code you mentioned (files/line #s, etc)?  Thanks!

I never got to the bottom of this.  I had started on version 3.4.5, and upgrading to 3.4.6 did not resolve the issue for me.  Since I posted, I upgraded to 3.4.8 and thankfully, the issue appears to have gone away!  It's been a few days now and the Views cache has not broken my custom field handlers.