Update #7208 Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation [#1844174]

Updating from unstable6 to unstable7 yields:

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'type' cannot be null: INSERT INTO {file_type} (type, label, description) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => ) in file_type_save() (line 541 of /var/www/[site]/sites/all/modules/file_entity/file_entity.file_api.inc).

Comments

Comment #1

bensnyder CreditAttribution: bensnyder commented 18 November 2012 at 20:47

Originally I updated both file_entity and media at the same time. After reverting the backup, I:

disabled media_browser_plus
kept media-unstable6, but ran update.php with file_entity-unstable7 (completed, no errors)
ran update.php w/ media-unstable7 (completed, no errors)

I didn't do any good testing here. In fact, I'm not sure why I got the initial PDOException. Could be a number of things. But the second time I tried, following the steps above... I got through without a hitch.

Comment #2

bensnyder CreditAttribution: bensnyder commented 18 November 2012 at 20:48

Status:

Active

» Closed (fixed)

Comment #3

bensnyder CreditAttribution: bensnyder commented 18 November 2012 at 21:18

FYI - Just found: http://drupal.org/node/1832294#comment-6740458

Comment #4

jide CreditAttribution: jide commented 30 January 2013 at 15:39

Status:

Closed (fixed)

» Active

I'm experiencing the same issue, and did the same procedure, but git the error on second update.php...

Comment #5

arthurf CreditAttribution: arthurf commented 30 January 2013 at 18:50

I think this maybe related to the upgrade sequence. I saw this when I was doing testing on #1846518: Document file types are undefined after module update - could you try going from unstable6 -> dev and see if that fixes the issue for you?

Comment #6

jide CreditAttribution: jide commented 30 January 2013 at 18:56

I simply deleted the media_types table, after having tried on a fresh install and seen that file_types table was empty anyway, but I'm not sure about what would be migrated otherwise.

I may give it a try following your advice to see where it goes.

Thanks !