[support] New CCK field not found in mysql

[Domenic Santangelo]

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/ ]