Manually enter cck field data into database

Question

I have 1 content type and one cck text field. if i create node and enter title and text field data and click to save save button its create node and enter data into node and content_field_table perfectly, but if i update cck field data manually into database its not shows update node data.

Answer 1

I can't say I'd advise manually inserting data into the database (there are a lot of API functions for CCK that will help you to do this), but that's for another question.

To make sure the node is reloaded from the database after you've inserted your record(s) just run this code:

$node = node_load($node->nid, NULL, TRUE);

The third argument to the function is $reset, which if TRUE will force the node to be built again from the database, not from the static cache.

Answer 2

Have you tried clearing the cache? A lot of things in drupal are being cached, so editing/removing them from their database table might give a conflict with what's in the cache.

Answer 3

I needed to do the same thing in Drupal 6, but ran into issues with the CCK Cache not clearing. I dug into the CCK Module code, and found the method they used:

cache_clear_all('content:'. $node->nid .':'. $node->vid, content_cache_tablename());

You can find details on cache_clear_all() here.

If you use this method, then your manual update code should look like this:

db_query("UPDATE `content_type_$type` SET field_$type_$fieldname_value='%s' WHERE nid=%d AND vid=%d",$node->fieldname[0]['value'], $node->nid, $node->vid);
cache_clear_all('content:'. $node->nid .':'. $node->vid, content_cache_tablename());