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
#1
BTW: I use YouTube services in this field.
#2
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
#3
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.
#4
Hi I fixed this.
Basically, as he said, go to phpMyAdmin
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!
#5
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.