Import fails with "Integrity constraint violation: 1048 Column 'vid' cannot be null" [#1843926]

I'm trying to use Node Export to solve my problem at http://drupal.stackexchange.com/questions/48048/merge-content-e-g-a-foru... . To do this, I used Node Export with Views Bulk Operations which gave node export code. I then followed the instructions: 'Copy this code and then on the site you want to import to, go to the Node export: import link under Add content, and paste it in there'. However doing so yielded the following error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'vid' cannot be null: INSERT INTO {node} (vid, type, language, title, uid, status, created, changed, comment, promote, sticky, tnid, translate, uuid) 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, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => article [:db_insert_placeholder_2] => und [:db_insert_placeholder_3] => jquery test - 1 - copy for initial heev3 try [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 1353234281 [:db_insert_placeholder_7] => 1353234281 [:db_insert_placeholder_8] => 2 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => e7209588-3092-a7e4-4138-c1a15f4877a0 ) in drupal_write_record() (line 7036 of /Volumes/WD Blue/home/Sites/drupal7/includes/common.inc).

This was on a completely fresh install of D7 created for this purpose. Any pointers?

Comments

Comment #1

kclarkson CreditAttribution: kclarkson commented 16 December 2012 at 19:41

Here is the error I am receiving:

Notice: Undefined property: stdClass::$uri in _node_export_file_field_import_file() (line 1123 of /Users/kclarks2/sites/all/modules/contrib/node_export/node_export.module).
Unknown error occurred attempting to import file:
Warning: array_flip(): Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->load() (line 178 of includes/entity.inc).
Notice: Trying to get property of non-object in file_field_presave() (line 220 of modules/file/file.field.inc).
Warning: Creating default object from empty value in file_field_presave() (line 221 of modules/file/file.field.inc).
Notice: Undefined property: stdClass::$uri in file_save() (line 575 of /includes/file.inc).
Notice: Undefined property: stdClass::$uri in file_entity_file_presave() (line 14 sites/all/modules/contrib/file_entity/file_entity.file.inc).
Warning: array_flip(): Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->load() (line 178 /includes/entity.inc).
Notice: Trying to get property of non-object in image_field_presave() (line 236 of modules/image/image.field.inc).
Notice: Undefined property: stdClass::$fid in file_usage_add() (line 659 of includes/file.inc).
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'fid' cannot be null: INSERT INTO {file_usage} (fid, module, type, id, count) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => file [:db_insert_placeholder_2] => node [:db_insert_placeholder_3] => 6 [:db_insert_placeholder_4] => 1 ) in file_usage_add() (line 666 of /Users/kclarks2/Dropbox/sites-test/drupal/includes/file.inc).