[support] New CCK field not found in mysql

Paul Kim pkim at reachlocal.com
Fri Nov 20 21:45:32 UTC 2009


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



More information about the support mailing list