emfield does not work well after updating from drupal 5 to 6

dsp1 - November 2, 2009 - 23:11
Project:Embedded Media Field
Version:6.x-1.15
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

here is the error shown after clicking Save.

user warning: Column 'field_video_value' cannot be null query: INSERT INTO content_type_blog (vid, nid, field_video_embed, field_video_value, field_video_provider, field_video_data, field_video_version, field_video_duration) VALUES (131, 131, NULL, NULL, NULL, 'N;', 0, 0) in /Users/xx/Sites/drupal/sites/all/modules/cck/content.module on line 1213.

I updated from drupal 5 to 6 and ran all updates.

any ideas how to fix this?

Thanks.

#1

dsp1 - November 3, 2009 - 00:30
Title:Error when posting node with no video attached» emfield does not work well after updating from drupal 5 to 6

ok, did some more testing and I was able to fix using phpmyadmin.

WORK AROUND FIX
looking at table content_type_blog structure (or whatever content_type you have the video field added to)
2 fields not set correctly.
field_video_value NULL set to NO
field_video_provider NULL set to NO

i changed from NOT NULL to NULL to fix it.

seems several things are not getting updated when switching from drupal 5.x to 6.x
after updating and still having the errors i ran update and forced emfield and emvideo and some ran and some failed, but did not fix these errors.

so I am changing the title.

 
 

Drupal is a registered trademark of Dries Buytaert.