Views caching (1 hour / 1 hour) and cron.php

Hi dereine,

Thanks for your answer. From time to time, I will need some other contributors (not admin) to the website to be able to clear the Views cache so that some of the views blocks are updated with the latest node for instance.

I noticed the Views cache can be cleared manually from /admin/build/views/tools. There's a Clear Views' Cache button. However, I'm wondering if there would be a way to just give them a URL similar to /cron.php that would clear the Views' cache so that everything gets updated if needed. If a URL isn't the easiest way, maybe I could use a trigger: "On node creation" >> action: " Clear Views' cache". Not sure how to do this though.

Thanks,

Just found the cache_clear_all(); function. I'm wondering if this would work as part of a page to load for contributors to clear the views' cache after they have posted a new node.
Something like: After they save a node, load: www.domain.com/clear-my-cache -- a page with that function embedded with input php. I'm using syndicated css and js though, and I do not need these to be re-syndicated every time we want to clear the views' cache though.

Describing my steps as I'm trying to figure it out:
here is the api page for the cache_clear_all() function: http://api.drupal.org/api/function/cache_clear_all/6

It doesn't seem like the function is clearing the cache views tables by default, because if the arguments are not specified, it will clear:

  cache_clear_all(NULL, 'cache_block');
  cache_clear_all(NULL, 'cache_page');

Now, I believe I could do:

<?php
  cache_clear_all(NULL, 'cache_views');
?> 

or something similar, but I'm not sure which tables should be cleared.

Thanks for your help, Merlin.

Ok, sorry to be persistent with this, but I created a php file in the root of my website with this:

<?php

include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
views_invalidate_cache();

I have some views cached with random: global to check if the cache is cleared or not.
When I click on the /administer/views/tools >> clear Views' cache button, my views block changes its display, so the cache is cleared.

However, when I load http://www.domain.com/clear-my-views.php -- I'm getting a blank screen just like cron.php, but the views remains the same, which means the cache isn't cleared I believe.
I also tried to insert

<?php views_invalidate_cache(); ?>

in an unpublished node and with input php again without success, the cache isn't cleared.

Thanks for your help,

It worked! Thanks Merlin!

Just a question, if two people were to access the page where I have cache_clear_all('*', 'cache_views_data', true); at the same time, could it create problems with the database?