This error was something I stumbled upon while editing content. It seems that during submission, any cck fields with a value do not get submitted. This error is what shows up in the log:

Column 'field_url_url' cannot be null query: INSERT INTO content_type_(vid, nid, field_date_value, field_url_url, field_url_title, field_url_attributes, field_quarter_value, field_emailconfirm_email) VALUES (3655, 3655, NULL, NULL, NULL, NULL, NULL, 'email@example.com') in /var/www/html/modules/cck/content.module on line 1207.

After some testing, disabling/enabling modules, etc I found that link was the problem.

If this is a duplicate issue, my apologies.

Comments

jcfiala’s picture

Status: Active » Closed (duplicate)

It is a duplicate issue - this is a problem encountered when you've upgraded link from drupal 5. You should try the 6.x-2.6beta1 version, which has an upgrade that should fix this.

#318277: Null value error when creating a new node with an empty link URL