Video uploads just fine and everything else seems to work. But when I try to submit the article all I get is this error. Also the module doesn't remove indications to the uploaded videos from files_managed table causing it to give duplicate file errors while trying to upload the same file again.

PDOException: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1: INSERT INTO {field_data_field_video} (entity_type, entity_id, revision_id, bundle, delta, language, field_video_fid, field_video_thumbanail, field_video_dimensions, field_video_data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9_dimensions, :db_insert_placeholder_9_player_dimensions, :db_insert_placeholder_9_bypass_autoconversion, :db_insert_placeholder_9_convert_video_on_save, :db_insert_placeholder_9_use_default_video_thumb); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 14 [:db_insert_placeholder_2] => 14 [:db_insert_placeholder_3] => videoartikkeli [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => fi [:db_insert_placeholder_6] => 19 [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => [:db_insert_placeholder_9_dimensions] => 320x200 [:db_insert_placeholder_9_player_dimensions] => 320x200 [:db_insert_placeholder_9_bypass_autoconversion] => 0 [:db_insert_placeholder_9_convert_video_on_save] => 0 [:db_insert_placeholder_9_use_default_video_thumb] => 0 ) function field_sql_storage_field_storage_write() (row 425 in file drupal7\modules\field\modules\field_sql_storage\field_sql_storage.module).

Comments

obarillet’s picture

obarillet commented

The same error occured on my fresh D7 installation, just installed the wysiwyg and video modules.

PDOException: SQLSTATE[21S01]: 
Insert value list does not match column list: 1136 Column count doesn't match value count at row 1: 

INSERT INTO
 {field_data_field_video} (
 entity_type
 entity_id
 revision_id
 bundle
 delta
 language
 field_video_fid
 field_video_thumbanail
 field_video_dimensions
 field_video_data
) 
VALUES (
 :db_insert_placeholder_0
 :db_insert_placeholder_1
 :db_insert_placeholder_2
 :db_insert_placeholder_3
 :db_insert_placeholder_4
 :db_insert_placeholder_5
 :db_insert_placeholder_6
 :db_insert_placeholder_7
 :db_insert_placeholder_8
 :db_insert_placeholder_9_dimensions
 :db_insert_placeholder_9_player_dimensions
 :db_insert_placeholder_9_bypass_autoconversion
 :db_insert_placeholder_9_convert_video_on_save
 :db_insert_placeholder_9_use_default_video_thumb
); 
Array ( 
	[:db_insert_placeholder_0] => node 
	[:db_insert_placeholder_1] => 1 
	[:db_insert_placeholder_2] => 1 
	[:db_insert_placeholder_3] => post 
	[:db_insert_placeholder_4] => 0 
	[:db_insert_placeholder_5] => und 
	[:db_insert_placeholder_6] => 3 
	[:db_insert_placeholder_7] => 
	[:db_insert_placeholder_8] => 
	[:db_insert_placeholder_9_dimensions] => 640x350 
	[:db_insert_placeholder_9_player_dimensions] => 640x350 
	[:db_insert_placeholder_9_bypass_autoconversion] => 1 
	[:db_insert_placeholder_9_convert_video_on_save] => 1 
	[:db_insert_placeholder_9_use_default_video_thumb] => 1 
)

in field_sql_storage_field_storage_write() 
(line 425 of /var/drupal-7.0/modules/field/modules/field_sql_storage/field_sql_storage.module).
hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented
Status: Active » Fixed

Fixed in dev

ktp’s picture

ktp commented

I get the same error, and don't understand the "Fixed in dev".

What shall I do to get it to work properly?

ktp’s picture

ktp commented

When I check for updates I get a report that says I got the newest updates, and it still won't work.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

We have fixed this is dev, please do a fresh installation

zandros’s picture

zandros commented

I tried the 30th of January version and I got this:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_video_use_default_video_thumb' in 'field list': INSERT INTO {field_data_field_video} (entity_type, entity_id, revision_id, bundle, delta, language, field_video_fid, field_video_thumbanail, field_video_use_default_video_thumb, field_video_player_dimensions) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => article [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => el [:db_insert_placeholder_6] => 6 [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 364x200 ) in field_sql_storage_field_storage_write() (line 425 του /home/site_name/www/www/modules/field/modules/field_sql_storage/field_sql_storage.module).

obarillet’s picture

obarillet commented

Make sure you have those two fields in your database:
* field_video_use_default_video_thumb (unsigned int)
* field_video_player_dimensions (varchar(32))

In the following two tables :
* field_data_field_video
* field_revision_field_video

Check the file video.install for the fields creation details.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

a.ilyin’s picture

a.ilyin commented

Hi, everyone.
I'm still having this issue. I ran update php and all updates were sucessful, but I do not see fields mentioned by obarillet. Even in video.install file.
I use the latest version of a module(7.x-2.13) and the latest drupal version(7.59)

Here's an error output

PDOException: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1: INSERT INTO {field_data_field_video} (entity_type, entity_id, revision_id, bundle, delta, language, field_video_fid, field_video_thumbnail) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7_0, :db_insert_placeholder_7_1, :db_insert_placeholder_7_2, :db_insert_placeholder_7_3); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 460666 [:db_insert_placeholder_2] => 460667 [:db_insert_placeholder_3] => paragraph [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => 66423 [:db_insert_placeholder_7_0] => Upload [:db_insert_placeholder_7_1] => Remove [:db_insert_placeholder_7_2] => 0 [:db_insert_placeholder_7_3] => ) in field_sql_storage_field_storage_write() (line 514 of /var/www/discuto/modules/field/modules/field_sql_storage/field_sql_storage.module).

a.ilyin’s picture

a.ilyin commented

UPDATE

Selecting option no transcoder in module settings helped me and now everuthing works fine.