Feed import field file on node error : SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'fid' cannot be null [#2077343]

Hello,

I'm trying to import node who contains files. I have set node mapping of the field file and field image. It's working with image but no with file. I obtain a error message after the importation : SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'fid' cannot be null.
Anyone have a idea for this error ?

Thanks

Comment	File	Size	Author
#9	feeds-file-download-sql-error-2077343-9.patch	1015 bytes	wroxbox
#9
#1	feeds-file_save_fid_null-2077343-1.patch	568 bytes	Leksat
#1
#9	feeds-file_save_fid_null-2077343-2.patch	543 bytes	wroxbox
#9

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

Leksat CreditAttribution: Leksat commented 6 September 2013 at 05:41

Status:

Active

» Needs review

File	Size
feeds-file_save_fid_null-2077343-1.patch	568 bytes

I also have this error using the latest dev version. I suppose it's related to #1080386: Add mapping for title and alt fields on images..
In my case the error appears when I import image file and it's alt text, and when file can't be downloaded. So the file field added to an entity in file_feeds_set_target() looks like this:

array(
  'und' => array(
    0 => array(
      'alt' => 'Some text',
    )
  )
)

Attached patch that fixes issue for me.

Comment #2

vitchy CreditAttribution: vitchy commented 9 September 2013 at 20:54

I tried your patch and i haven't any message now but no file was uploaded in drupal file system and database for field file.
It's working for you (not for image field but for a custom file field in node content type) ?

Comment #3

twistor CreditAttribution: twistor commented 20 September 2013 at 16:08

Assigned:	Unassigned	» twistor
Status:	Needs review	» Postponed (maintainer needs more info)

What do the values look like that you are mapping to the uri field?

Comment #4

vitchy CreditAttribution: vitchy commented 20 September 2013 at 21:20

I created a field type "file" with cck in node content type and i mapped the "File: URI" target with feed node processor.
In my CSV file, for my "file" field mapping, i set a url value for the URI. And nothing is uploaded in system file and no value set in database.
But it's working well with image field.

Comment #5

msamavi CreditAttribution: msamavi commented 6 October 2013 at 14:41

The same problem here!

Comment #6

jackhutton CreditAttribution: jackhutton commented 22 October 2013 at 17:57

Getting this error as well: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'fid' cannot be null
log message:

DOException: 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] => 505 [:db_insert_placeholder_4] => 1 ) in file_usage_add() (line 662 of /srv/bindings/0d7aab820bdd44d0931100442a50f17b/code/includes/file.inc).

tried a few different approaches but no success.. does the above patch apply to the october 1st 7.x-2.x-dev version? Didn't apply for me..but, that could be me..
be great to attach images to nodes again.
thanks

Comment #7

mjcarter CreditAttribution: mjcarter commented 31 October 2013 at 03:25

Edit - The issue I was getting originally appears to be related to the media_feeds module. Just upgraded to the dev version of feeds, now I get the same error as everyone else. Applied patch by Leksat - errors disappear and import works, but file fields are empty in the imported users.