Home » Download » Modules » Embedded Media Field » Issues

Error if video field is empty

design.er - October 9, 2009 - 18:34
Project:Embedded Media Field
Version:6.x-1.11
Component:Embedded Video Field
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

Hello,

I receive the following error for "emfield video field" when I save a node:

user warning: Column 'field_video_embed_version' cannot be null query: UPDATE content_field_video_embed SET vid = 7, nid = 7, field_video_embed_embed = NULL, field_video_embed_value = NULL, field_video_embed_provider = NULL, field_video_embed_data = 'N;', field_video_embed_version = NULL, field_video_embed_duration = NULL WHERE vid = 7 in D:\DEVELOPMENT\xampp\www\mysite\sites\all\modules\cck\content.module on line 1213.

As the error describes this message only to appears if the video field is empty.
I use a fresh Drupal 6.14 installation with CCK 2.5. I didn't hack the database or anything else.

Help is much appreciated.
Please let me know if you need more information.

Kind regards,
Stefan

» Login or register to post comments

#1

design.er - October 9, 2009 - 18:36

BTW: I use YouTube services in this field.

Login or register to post comments

#2

Ashford - October 11, 2009 - 18:01

Use phpMyAdmin to edit the fields. Click to check mark the box labeled "NULL". Do not change the default values.

Database Table & fields
content_field_video -- field_video_version, field_video_duration
content_field_audio -- field_audio_version

Login or register to post comments

#3

design.er - October 12, 2009 - 11:02

Hi Ashford, thank you for your quick response.
Sorry but I'm afraid I don't understand what you mean. Please can you describe what to do with the fields in phpMyAdmin?
Sorry for the circumstances.

Login or register to post comments

#4

TrevorG - October 13, 2009 - 23:13
Category:support request» bug report

Hi I fixed this.

Basically, as he said, go to phpMyAdmin

  1. Go to the table that has your drupal install on it.
  2. Go to the table that has the content type that you are experiencing issues with the emfield with.
  3. Go to the rows with the emfield... there should be a total of six variations of the emfield ending in _embed, _value, _provider, _data, _ version, and _duration.
  4. Change _version and _duration 's NULL column to null. Don't change the value (which should be 0).
  5. That should fix it. You'll probably have to repeat for each content type, but I only use it for one so far.

I changed this to a bug because I don't know how it can't be. I had a clean install of emfield, tried the dev even and it wasn't fixed. Don't know how more users aren't having issues with this. By the way, great module otherwise, thank you!

Login or register to post comments

#5

design.er - November 9, 2009 - 17:41

Sorry for the ultra delayed answer.
Attached is a screenshot if my phpMyAdmin. Please can you tell me if my phpMyAdmin is correct - I neither see a "NULL" checkbox (from comment #2) nor a field where I could replace "NULL" with "null" - only an integer field with the 0 - for the fields _version and _duration.
Maybe you could also post a screenshot with your values.

And, should I replace this values for every node extra?

Thanks a lot for your help.

AttachmentSize
phpMyAdmin.png 21.5 KB
Login or register to post comments

#6

shilpawaidya - January 20, 2010 - 18:50

Thanks a lot TrevorG.. I had the same issue and you instructions helped me solve it.

Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.