[support] New CCK field not found in mysql

[Michael Prasuhn]

..unless it's multiple values.

It really is best to avoid direct queries of CCK fields. Sometimes  
fields on the same type will be in content_type_FOO tables or in  
content_field_FIELD_FOO.

If you are importing alot of data, I can't say enough good things  
about the Tablewizard and Migrate modules.

http://drupal.org/project/tw
http://drupal.org/project/migrate

BTW, the technic that Domenic described is what Migrate module does  
under the hood.

-Mikey P
__________________
Michael Prasuhn
503.512.0822 office
503.539.3864 cell
503.661.7574 home
mike at mikeyp.net
http://mikeyp.net

On Nov 20, 2009, at 1:45 PM, Paul Kim wrote:

> CCK only creates content_field_xxxx when that field is shared  
> between two or
> more content types. Otherwise, it just adds a column to  
> content_type_yyyy.
>
> -----Original Message-----
> From: support-bounces at drupal.org [mailto:support-bounces at drupal.org]  
> On
> Behalf Of Scott
> Sent: Friday, November 20, 2009 1:07 PM
> To: support at drupal.org
> Subject: Re: [support] New CCK field not found in mysql
>
> 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/ ]