[support] New CCK field not found in mysql

[sebastian]

Hi William, Domenic,

Would this also apply to reading/setting the possible values in a 
radio-button list of a CCK field [used by then many Nodes]? Wouldn't 
that just be in one single location?

Thanks for your input!

Kindly,

Sebastian.

William Smith wrote:
> Absolutely.  One of the things you'll find to is that where data is 
> stored will shift on you depending on whether the field is isolated to 
> one node type only or if it is shared, etc..  As Domenic said, it really 
> is best to use the regular node api for this sort of thing rather than 
> try to cram it in via direct SQL queries against the DB.
> 
> On Fri, Nov 20, 2009 at 4:41 PM, Domenic Santangelo <domenics at gmail.com 
> <mailto:domenics at gmail.com>> wrote:
> 
>     CCK is black magic... better not to try and decipher the db structure
>     which at times seems kind of arbitrary to me.
> 
>     The better way is to write a fn that loops thru the nodes you want to
>     batch add to, do a node_load() on them, modify the desired fields,
>     then node_save().
> 
>     HTH,
>     -Dom
> 
>     On Nov 20, 2009, at 1:07 PM, Scott wrote:
> 
>      > I found where the data went by exporting the sites database.  Rather
>      > than create a new table named content_field_street_name, as I would
>      > have
>      > expected, it created content_type_[content_type_name].  This
>     table has
>      > fields: vid, nid and field_street_name_value.  I'm about out of time
>      > today but I wonder what would've happened had I added two new fields
>      > to
>      > this CCK type.
>      >
>      >
>      > On Fri, 2009-11-20 at 12:07 -0800, Scott wrote:
>      >> I've created a new field for a CCK type and it works fine in my
>      >> drupal
>      >> site.  My problem is that it does not show up in mysql command line
>      >> interface or with phpmyadmin.  This is confusing to me.  I can
>      >> modify,
>      >> add and delete data using the edit node function when viewing a
>      >> page, so
>      >> I know the data is somewhere, however, I wish to do a batch load of
>      >> this
>      >> field with mysql.
>      >>
>      >
>      > --
>      > [ Drupal support list | http://lists.drupal.org/ ]
> 
>     --
>     [ Drupal support list | http://lists.drupal.org/ ]
> 
>