Error message upon submission of new content in 4.7 beta 5 [#52191]

I just installed 4.7 beta 5. I added a new content type using CCK and created some fields for the content using "add fields" tab. When I click on submit I get the following error message:

Warning: Unknown column 'nid' in 'field list' query: INSERT INTO node_field_date_data (nid, vid, field_name, field_date) VALUES (5, 5, 'field_date_submitted', '3-2-2006') in /home/fhcroger/public_html/drupal-4.7.0-beta-5/includes/database.mysql.inc on line 120

Warning: Unknown column 'nid' in 'field list' query: INSERT INTO node_field_shorttext_data (nid, vid, field_name, field_shorttext, format) VALUES (5, 5, 'field_status', 'pending', 0) in /home/fhcroger/public_html/drupal-4.7.0-beta-5/includes/database.mysql.inc on line 120

Warning: Cannot modify header information - headers already sent by (output started at /home/fhcroger/public_html/drupal-4.7.0-beta-5/includes/database.mysql.inc:120) in /home/fhcroger/public_html/drupal-4.7.0-beta-5/includes/common.inc on line 233

The node subsequently created only contains the title and the author of the content. None of the other content that was entered when creating the content displays. Also, the date and time the content was authored doesn't show up either. I'm not sure if this is a bug or a something I did wrong when setting up CCK, but I've double checked the install information and I think I did it correctly.

Comment	File	Size	Author
#5	cck-4.7b5.tar.gz	15.12 KB	RayZ

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

RayZ CreditAttribution: RayZ commented 3 March 2006 at 12:52

Are you using the latest CVS version of CCK, and have you run the update.php script to update the CCK tables since updating to the latest?

Sounds like the database tables are not up-to-date with the version of the CCK code you are running.

Comment #2

KSA213755 CreditAttribution: KSA213755 commented 3 March 2006 at 13:31

This was my first time using CCK, so I obtained the module using the "Download latest release (cvs)" link on the CCK project page. I had previously checked the database and it appeared that the CCK tables were created when I installed the module.

I had not previously run update.php, but now I've run that script. Update.php ran successfully and no errors were logged. However, when I try to create new content, I am still getting the same error messages and the same result on the submitted page, i.e. a page that only has the title and submitted by info, but no other content.

Comment #3

RayZ CreditAttribution: RayZ commented 3 March 2006 at 13:49

I'm not sure about this, but you may need to recreate the content type if you haven't done that since the update.

Comment #4

KSA213755 CreditAttribution: KSA213755 commented 3 March 2006 at 14:03

Since running update.php, I've attempted to create a new content type. When adding a new content type I received the following error message when I saved the content type:

Warning: Cannot modify header information - headers already sent by (output started at /home/fhcroger/public_html/drupal-4.7.0-beta-5/themes/bluemarine/template.php:17) in /home/fhcroger/public_html/drupal-4.7.0-beta-5/includes/common.inc on line 233

The new content type was created. When I go back into administer > content types to add fields to the newly created content type, I get the same error message whether I add fields that were previously created, or create new fields.

When I try to create new content using this newly created content type, I get the same error messages quoted above in my original post. BTW, during content creation, except for one field, the content I enter shows up when I click "preview," but it's not on the page that's created after clicking "submit."

Comment #5

RayZ CreditAttribution: RayZ commented 3 March 2006 at 14:58

File	Size
cck-4.7b5.tar.gz	15.12 KB

I just did a quick check and it appears that the file at http://drupal.org/files/projects/cck-cvs.tar.gz is not a consistent snapshot of the CCK cvs [1]. I've attached a current CVS snapshot (identical to CCK HEAD when Drupal 4.7b5 was released). Try installing this, running update again and recreating your content types and let us know if this fixes it.

[1] IIRC this is due to a known bug in the current project module on drupal.org, to be fixed when drupal.org moves to 4.7.

Comment #6

KSA213755 CreditAttribution: KSA213755 commented 3 March 2006 at 23:03

Well, I've tried using the tar file you supplied and that seemed to make matters worse for the moment. Later tonight I'll just scrap the whole beta 5 install and start over from scracth with it. I'll let you know how that turns out. Thanks for helping me.

Comment #7

KSA213755 CreditAttribution: KSA213755 commented 4 March 2006 at 05:56

RayZ, I reinstalled 4.7 beta 5 and then installed CCK using the tar file you supplied. CCK is working now, so it must have been a problem with the version of CCK I obtained through the projects CVS link. Thanks again for the assistance.

Roger