1/8/2015 12:37:36 AM

After a recent Drupal update, I received an error related to a missing table: media_filter_usage. This caused a lot of unnecessary pain and frustration. Fortunately, I was able to find a script to recreate this table. Hope it helps someone else.

CREATE TABLE `media_filter_usage` ( `fid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The media file_managed.fid.', `timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'The timestamp the fid was last recorded by media_filter()', PRIMARY KEY (`fid`), KEY `timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores fids that have been included in the media tag in...';