I get this error when creating or updating content:

user warning: Unknown column 'field_seo_keywords_value' in 'field list' query: INSERT INTO content_type_page (vid, nid, field_seo_keywords_value) VALUES (6, 6, 'linux, unix, free, bsd, windows, monopoly, apple, breaking') in /. . . /modules/cck/content.module on line 1277.

Is there a query I can manually update the database with to include this column. I do not get this error on my other Drupal sites and they are all identical in update status

Comments

AlanAtLarge’s picture

AlanAtLarge commented

Same issue - subscribe

TallDavid’s picture

TallDavid commented
Project: Content Construction Kit (CCK) » SEO Compliance Checker
Version: 6.x-3.x-dev » 6.x-1.4
Component: content.module » Keyword Rules (Code)

This problem does not appear to be with the CCK module, but, rather, with the Keyword_Rules module (a part of the SEO Compliance Checker module). See: http://drupal.org/node/854394

miruoss’s picture

miruoss commented
Assigned: Unassigned » miruoss
miruoss’s picture

miruoss commented

This is not an easy Problem to fix. I'm working on it but my capacity is very limited at the moment.
The problem is as follows: The keyword_rules module depends on the CCK module text. If text is already installed when you install keyword_rules, everything works fine. However, if you install both modules at the same time, the cck field cannot be set up correctly.

For now, you should be able to fix the issue using one of the following two approaches:

Remove and re-add the cck field field_seo_keywords

  1. search your content types for cck fields named field_seo_keywords and remove them
  2. add new fields of type text (widget text field) and use field_seo_keywords as field name (not label)

OR:

Reinstall keyword_rules module

  1. disable the keyword_rules module
  2. uninstall (/admin/build/modules/uninstall) the keyword_rules module
  3. Make sure text module is enabled
  4. install the keyword_rules module again.
miruoss’s picture

miruoss commented
Status: Active » Closed (fixed)

The module doesn't create cck fields during install procedure anymore. So this issue should be fixed.

bobburns’s picture

bobburns commented
Version: 6.x-1.4 » 6.x-2.3
Status: Closed (fixed) » Needs work

The keywords field does not appear when editing or creating content. If I create it manually in one content type, I cannot create it in any other content type - I get the error the field already exists - when it does not - but in the one content type where it does. Since this module does not create the field anymore on an uninstall then re-install - how is this now fixed?

miruoss’s picture

miruoss commented
Status: Needs work » Closed (fixed)

What you write has nothing to do with the code of this module. CCK Fields can be reused. Instead of creating the same field twice, reuse the field you created for other content types.