user warning: Unknown column 'field_video_url_version' in 'field list' query: UPDATE db_content_type_video SET vid = 36, nid = 31, field_video_url_embed = 'http://www.youtube.com/watch?v=blaaaaaaa', field_video_url_value = 'blaaaaaaa', field_video_url_provider = 'youtube', field_video_url_data = 'a:6:{s:20:\"emvideo_data_version\";i:3;s:23:\"emvideo_youtube_version\";i:3;s:3:\"raw\";a:8:{s:16:\"_emfield_arghash\";s:25:\"youtube:videoblaaaaaaa:\";s:27:\"http://www.w3.org/2005/Atom\";a:9:{s:2:\"ID\";a:2:{i:0;s:53:\"http://gdata.youtube.com/feeds/api/videos/blaaaaaaa\";i:1;N;}s:9:\"PUBLISHED\";a:2:{i:0;s:24:\"2008-09-25T17:02:02.000Z\";i:1;N;}s:7:\"UPDATED\";a:2:{i:0;s:24:\"2009-10-06T07:28:30.000Z\";i:1;N;}s:8:\"CATEGORY\";a:168:{i:0;N;i:1;a:2:{s:6:\"SCHEME\";s:37:\"http://schemas.google.com/g/2005#kind\";s:4:\"TERM\";s:43:\"http://gdata.youtube.com/schemas/2007#video\";}i:2;N;i:3;a:3:{s:6:\"SCHEME\";s:52:\"http://gdata.youtube.com/schemas/2007/categories.cat\";s:4:\"TERM\";s:5:\"Autos\";s:5:\"LABEL\";s:16:\"Autos & Vehicles\";}i:4;N;i:5;a:2:{s:6:\"SCHEME\";s:50:\"http://gdata.youtube.com/schemas/2007/keywords.cat\";s:4:\"TERM\";s:2:\"la\";}i:6;N;i:7;a:2:{s:6:\"SCHEME\";s:50:\"http://gdata.youtube.com/schemas/2007/keywords.cat\";s:4:\"TERM\";s:3:\"der\";}i:8;N;i:9;a:2:{s:6:\"SCHEME\";s:50:\"http://gdata.youtube.com/schemas/2007/keywords.cat\";s:4:\"TERM\";s:3:\"the\";}i:10;N;i:11;a:2:{s:6:\"SCHEME\";s:50:\"http://gdata.youtube.com/schemas/2007/keywords.cat\";s:4:\"TERM\";s:3:\"new\";}i:12;N;i:13;a:2:{s:6:\"SCHEME\";s:50:\"http://gdata.youtube.com/schemas/2007/keywords.cat\";s:4:\"TERM\";s:4:\"neue.....
.....
.....
.....\";a:3:{s:3:\"url\";s:32:\"http://youtube.com/v/blaaaaaaa\";s:4:\"size\";s:4:\"1023\";s:4:\"mime\";s:29:\"application/x-shockwave-flash\";}}', field_video_url_version = 3, field_video_url_duration = 100, field_eigenes_video_fid = 118, field_eigenes_video_list = 1, field_eigenes_video_data = 'a:0:{}' WHERE vid = 36 in .../all/modules/cck/content.module on line 1213.

just update to 6.x-1.11
update.php
node edit and save my content type
brings me this error

Comments

kappaluppa’s picture

kappaluppa commented

I get the same error when editing a node that uses embed video cck field. I tried my content type without embed video, no error. http://kappaluppa.com/efe/ss1.jpg
Refreshing page makes error go away
I remove embed video, edit node, no error.

had upgraded to cck-6.x-2.5. So tried cck-6.x-2.2. Still get the error.

aaron’s picture

aaron commented
Status: Active » Fixed

This should be fixed now in the dev version (and will be released soon as DRUPAL-6--1-16). Please re-open if you still see this error.

Thanks

oscarelloo’s picture

oscarelloo commented

Just updated Drupal to 6.16, CCK and Embedded Media Field to the latest DEV versions and I'm getting the same error message. Only happens when I have the Embedded Media module activated.

Error message when the module is active, but no link to video is inserted:

"user warning: Unknown column 'field_video_embedded_1_version' in 'field list' query: UPDATE d_content_type_horse SET vid = 198, nid = 133, field_video_embedded_1_embed = NULL, field_video_embedded_1_value = NULL, field_video_embedded_1_provider = NULL, field_video_embedded_1_data = 'N;', field_video_embedded_1_version = NULL, field_video_embedded_1_duration = NULL, field_video_embedded_2_embed = NULL, field_video_embedded_2_value = NULL, field_video_embedded_2_provider = NULL, field_video_embedded_2_data = 'N;', field_video_embedded_2_version = NULL, field_video_embedded_2_duration = NULL, field_video_embedded_3_embed = NULL, field_video_embedded_3_value = NULL, field_video_embedded_3_provider = NULL, field_video_embedded_3_data = 'N;', field_video_embedded_3_version = NULL, field_video_embedded_3_duration = NULL, field_video_link_1_url = NULL, field_video_link_1_title = NULL, field_video_link_1_attributes = NULL, field_horse_sold_value = NULL, field_price_range_value = NULL, field_testamonial_value = NULL WHERE vid = 198 in /customers/*/httpd.www/sites/all/modules/cck/content.module on line 1213.

oscarelloo’s picture

oscarelloo commented
Status: Fixed » Active

Tried to reinstall the module (latest DEV-version), but I still have the same problem. Any ideas?

Thanks,
Oscar

nicolash’s picture

nicolash commented

I have the same problem after an upgrade from D5 to D6. Under D5 (Emfield 5.x-1.8), the columns added to the database are:

[FIELD]_embed
[FIELD]_value
[FIELD]_provider
[FIELD]_data

Under D6 (Emfield 6.x-1.19), 2 additional columns seem to be expected:

[FIELD]_version
[FIELD]_duration

However, the upgrade process from D5 to D6 doesn't seem to add them for existing fields. What am I missing?

Also, [FIELD]_value and [FIELD]_provider allow NULL values under D6, but not D5.

konforti’s picture

konforti commented

Try this solution http://drupal.org/node/592898#comment-2670828.