I'm having a problem with adding an event when this occurs:
- a date field that collects Year, Month, Day, Hour, Minute
- Configure the date field as "Pop-up calendar"
- Enter the date from the calendar, but omit the time
- Submit the form

=>unexpected error

=>The expected result is that validation would catch the missing date components. What actually happens is that the module tries to do a DB INSERT and fails like this:

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_datum_activiteit_1_maand_} (entity_type, entity_id, revision_id, bundle, delta, language, field_datum_activiteit_1_maand__value, field_datum_activiteit_1_maand__value2) 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_0, :db_insert_placeholder_6_1, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 512 [:db_insert_placeholder_2] => 512 [:db_insert_placeholder_3] => evenement [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_7] => [:db_insert_placeholder_6_0] => 21/06/2016 [:db_insert_placeholder_6_1] => ) in field_sql_storage_field_storage_write() (line 514 of modules/field/modules/field_sql_storage/field_sql_storage.module).

any suggestions?

thx
blueblot

Comments

blueblot created an issue.