Hello team,

I have created a new content type for submitting articles with video adding emfiled video.
Now, I'm able to create a new node without filling the video url just fine.
But when I update the node i get the following message:

user warning: Column 'field_vide_version' cannot be null query: UPDATE content_type_video SET vid = 161, nid = 161, field_vide_embed = NULL, field_vide_value = NULL, field_vide_provider = NULL, field_vide_data = 'a:1:{s:7:\"emthumb\";N;}', field_vide_version = NULL, field_vide_duration = NULL WHERE vid = 161 in C:\xampp\htdocs\what\sites\all\modules\cck\content.module on line 1213

Notes:
If I submit a node with the url all is fine...
If you need more info let me know.

Any help is appreciated :)
Thanks,
Udi Zisser

CommentFileSizeAuthor
#2 modules.jpg135.24 KBzisser

Comments

aaron’s picture

aaron commented
Status: Active » Postponed (maintainer needs more info)

i am unable to reproduce that error. have you run the latest updates?

zisser’s picture

zisser commented
StatusFileSize
new modules.jpg135.24 KB

Thank for the prompt response.
I do have all the updates.
I get the warning constantly and able to reproduce.
What information can I provide to help with resolving this?
I have attached screenshot of installed modules dir.

The website will be available online around Nov 1st. I don't mind adding you as privileged member so you can experience first hand.

Thanks,
Udi.

evancarroll’s picture

evancarroll commented
Status: Postponed (maintainer needs more info) » Active

I am experiencing this exact issue. What information can I provide to help?

alison’s picture

alison
she/her
commented

zisser, evancarroll -- are you both using version 1.12 still, or have you upgraded? and/or do you still have the problem?

peter feddo’s picture

peter feddo commented

I experienced this same problem and solved it by opening the content_type_[whatevernameoftypeiscausingproblem] table in my favorite mysql database manager [navicat]. I edited the database structure to "ALLOW NULL" in the offending fields that were throwing an error message.

Problem solved, errors go away and my content item now saves properly.

alex ua’s picture

alex ua commented
Version: 6.x-1.12 » 6.x-2.x-dev
Status: Active » Closed (cannot reproduce)

#5 doesn't seem necessary any more. If you're still having the problem with 6.x-2.x-dev, please reopen.

JaDrupal’s picture

JaDrupal commented

I had the same issue and was able to resolve it by doing what Peter Feddo suggested. I had to set embedvideo_version and embedvideo_duration fields to allow null.