I'm trying to migrate cck field from d6 to d7, the only one I stille get problem is FIELD: field_date, FIELD TYPE: datetime. Any help is realy appreaciated. I get same error with 7.x-2.5 version

PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'field_date_value' at row 1: INSERT INTO {field_data_field_date} (entity_type, bundle, entity_id, revision_id, language, delta, field_date_value, field_date_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, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 2136 [:db_insert_placeholder_3] => 2627 [:db_insert_placeholder_4] => und [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 0000-00-00 00:00:00 [:db_insert_placeholder_7] => 0000-00-00 00:00:00 ) in drupal_write_record() (line 7013 of /includes/common.inc).

After that I receive also:
EntityMalformedException: Missing bundle property on entity of type file. in entity_extract_ids() (line 7539 of /includes/common.inc).

Comments

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (works as designed)

after further investigation I had 3 value set 0000-00-00 00:00:00 instead NULL

Anonymous’s picture

Anonymous (not verified) commented
Issue summary: View changes

.

alfthecat’s picture

alfthecat commented
Issue summary: View changes

@gio rez

Having the same issue. What do you mean by

I had 3 value set 0000-00-00 00:00:00 instead NULL

Would like to know how you fixed this. Thanks in advance

Anonymous’s picture

Anonymous (not verified) commented

as far as I can remember I replaced the 0000-00-00 00:00:00 with NULL trough a sql query.

alfthecat’s picture

alfthecat commented

Thanks, I'll give that a try!