By designcrs on

hi!

I'm updating a cck field on a number of nodes using the following code:

db_query("UPDATE {content_type_video} SET field_archived_value = '1' WHERE field_week_value < $myweek;");

it executes fine and the changes are visible in the database-table. however, the new value of the modified cck field does not appear on the resulting pages.

what's interesting is that the modified value shows up correctly in edit mode at "node/-number-/edit".

any clues?

many thanks in advance!

chris

⋅ Categories: Drupal 5.x

Comments

dipen chaudhary’s picture

dipen chaudhary commented

And when you go to edit and press submit, does it become visible for that particular node?

--------------------------------------------------------
Dipen Chaudhary
www.qed42.com ( Drupal development services specialize in social networks and other user generated content platforms )
www.dipenchaudhary.com

designcrs’s picture

designcrs commented

Yes, when i go to edit and press submit it does become visible for that node.

designcrs’s picture

designcrs commented

i guess it's a caching problem? any ideas?

ymmatt’s picture

ymmatt commented

I recently had the same issue, found that if I visited the content type "manage fields" page all values were refreshed.

Found this little function in the content.admin.inc file:
content_clear_type_cache();

All I did was call this function after I updated the DB and all was well.

azielinsky’s picture

azielinsky commented

I owe you a child for this. Thanks!!!!

ipllc’s picture

ipllc commented

Thanks...just what I needed to know.

carolynz’s picture

carolynz commented

I have the same problem. The changes I'm making in edit mode do not show up on the resulting page. I have cleared my private data and reloaded the page with no success. I'm using Dynamic Block with jquery cycle per the ddblock module. Any suggestions?

Firefox 3.0.13
Dynamic Block module
Drupal 6

chrispeat’s picture

chrispeat commented

This problem is definately a cache issue, you need to call something like...

cache_clear_all('*', 'cache', TRUE);
cache_clear_all('*', 'content', TRUE);
cache_clear_all('*', 'cache_page', TRUE);
cache_clear_all('*', 'cache_menu', TRUE);
cache_clear_all('*', 'cache_filter', TRUE);
cache_clear_all('*', 'cache_view', TRUE);

There is more info here: http://www.maxi-pedia.com/Drupal+cache+clean+up+cache_clear_all+function