user warning: Unknown column

I see that there is only fields with VALUE.... field_xxx_value, field_yyy_value,field_zzz_value,

Important information:

I created new content type and I used function: Add existing filed (from another content type).
Interesting is that after export I see information from another content type where is the field too.
----------------------------------------------------------------------------------------------
I install clean D6 with official version of CCK.
After that I install dev. version.
After that I updated from previous dev version of CCK to rc7.
With CCK I updated views module.
----------------------------------------------------------------------------------------------

I export code for you and I can see this:

* user warning: Unknown column 'field_distance_info_value' in 'field list' query: INSERT INTO content_field_distance_info (vid, nid, field_distance_info_value) SELECT vid, nid, field_distance_info_value FROM content_type_testaaa in /home/xxx/sites/all/modules/cck/includes/content.admin.inc on line 1436.
* user warning: Can't DROP 'field_distance_info_value'; check that column/key exists query: ALTER TABLE content_type_testaaa DROP field_distance_info_value in /home/xxx/includes/database.mysql-common.inc on line 322.
----------------------------------------------------------------------------------------------

Code is:

$content[type] = array (
'name' => 'Test',
'type' => 'property',
'description' => 'Add new info.',
'title_label' => 'Title',
'body_label' => '',
'min_word_count' => '0',
'help' => '',
'node_options' =>
array (
'status' => true,
'promote' => true,
'sticky' => false,
'revision' => false,
),
'language_content_type' => '0',
'nodewords' => 1,
'old_type' => 'property',
'orig_type' => '',
'module' => 'node',
'custom' => '1',
'modified' => '1',
'locked' => '0',
'comment' => '2',
'comment_default_mode' => '4',
'comment_default_order' => '1',
'comment_default_per_page' => '50',
'comment_controls' => '3',
'comment_anonymous' => 0,
'comment_subject_field' => '1',
'comment_preview' => '1',
'comment_form_location' => '0',
);
$content[fields] = array (
0 =>
array (
'label' => 'Distance info',
'field_name' => 'field_distance_info',
'type' => 'text',
'widget_type' => 'text_textarea',
'change' => 'Change basic information',
'weight' => '19',
'rows' => '5',
'size' => 60,
'description' => '',
'default_value' =>
array (
),
'default_value_php' => '',
'default_value_widget' => NULL,
'group' => 'group_distances',
'required' => 0,
'multiple' => '0',
'text_processing' => '0',
'max_length' => '',
'allowed_values' => '',
'allowed_values_php' => '',
'op' => 'Save field settings',
'module' => 'text',
'widget_module' => 'text',
'columns' =>
array (
'value' =>
array (
'type' => 'text',
'size' => 'big',
'not null' => false,
'sortable' => true,
),
),
'display_settings' =>
array (
'label' =>
array (
'format' => 'above',
),
'teaser' =>
array (
'format' => 'default',
),
'full' =>
array (
'format' => 'default',
),
4 =>
array (
'format' => 'default',
),
),
),
);

@yched: Yes, I did it.

I will try to delete problematic content and I will create new one. I will let you know. Thanks for answer.

I did it but seems that problem is still there. After fill out content , some fields are mandatory, I fill out all mandatory fields, and occurs message described over AND AFTER THAT I HAVE STILL some mandatory fields as is not filled.
I don't understand it.

I sent it to you via personal contact.
If you need some additional information let me know.
THKS for help.

I solved problem. I hope that this step by step process helps to others.
I am using two content types:
”Content type A” and ”content type B”.
I have in both content types part of the same cck fields.

In ”Content type A” I deleted obviously problematic field_country_info.
After that I wanted create the same field but !!! drupal gives me the message that filed already exist !!! This was wrong message because I deleted it in one step before.

NOTE: Do you know anybody How I can check CCK field consistency or find similar problematic fields?
If it was not possible to create field with standard function “Create New Field” - drupal gives me message that filed already exist.
I used function “Add existing field” (I took the field_country_info from content type B”.) And that’s works.
Data from field_country_info were lost , of course, but will try to export them from backup database, and import them to current.
If somebody know how can I do it quickly , let me know .

Thank you.

OK, thanks for confirmation. It is working as you wrote. So we can close this part about sharing fields.
After deleting one field I cant reproduce the problem "Unknown column" but give me some time I will test deeply.
I remember Step by step procedure because the problem was in each content:
I created several contents without problems.
I updated CCK version to rc7 (from previous official).
I open some content.
Program gives me message that two fieds meeds fill in because they are requierd.
Point1: I hat these fields filled in.
So I filled first field again, after that second field too.
And after that I tried to save content.
And appears message "Unknown column......" and content was updated.
I can see filled out two fields but If I press "edit" button, and I try to saved it without any changes, message appears again two field are mandatory.

After update module, I cant reproduce problem too.