Closed (fixed)
Project:
D7 Media
Version:
7.x-2.0-unstable7
Component:
Code
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Nov 2012 at 20:25 UTC
Updated:
4 Mar 2013 at 15:09 UTC
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 commentedOriginally I updated both file_entity and media at the same time. After reverting the backup, I:
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 commentedComment #3
bensnyder commentedFYI - Just found: http://drupal.org/node/1832294#comment-6740458
Comment #4
jide commentedI'm experiencing the same issue, and did the same procedure, but git the error on second update.php...
Comment #5
arthurf commentedI 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 commentedI 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 !
Comment #7
jide commented@arthurf: I updated my old media unstable3 to unstable6, and then to dev, and had no error. Youtubes mimetypes were not recognized though.
Comment #8
jide commented...but updating to media_youtube dev solved the issue, hooray !
Comment #9
gmclelland commentedClosing based on #8