TO DEVELOPERS, see my final note at the bottom...
I had a problem with our many FLV files (flash video) resources after upgrading from 1.9 to 2.0+. The problem seems to have been that most of our flv resources were setup as popups, which seems to be no longer supported. Automatic is supported.
Finding which files are a problem involved tying together several tables (mdl_resource, mdl_context, mdl_files, mdl_course_resource) to find out which resources were tied to files with .flv extensions. At this point, I ran the following script to fix the tables supporting the resource: (PS: this code is included just to show how stuff ties together. Do not use at another site without review, testing, backups, etc)
UPDATE mdl_resource r
JOIN mdl_course_modules c
ON r.id = c.instance
JOIN mdl_context x
ON x.instanceid = c.id
AND x.contextlevel = 70
JOIN mdl_files f
ON x.id = f.contextid
AND f.mimetype = 'video/x-flv'
SET r.intro = CONCAT('<p>',r.name,'</p>'), # intro required
r.display = 0, # change popup to automatic
r.displayoptions = 'a:2:{s:12:"printheading";i:0;s:10:"printintro";i:1;}',
f.sortorder = 1
WHERE f.mimetype = 'video/x-flv';
This was not a total fix, however, since the mdl_course table has a field (modinfo) that contains a pseudo table made up of all the resources used on the page. The modinfo field is rewritten when someone edits a resource in a course, so even though the underlying tables can be fixed behind the scenes with SQL, the course owner still has to edit/save any flv resources that had been popups to get the modinfo right. (This is an argument for holding more closely to a true data-driven model in software design, i.e. a cleaner, more discrete set of tables is easer to maintain/repair)
I was able, with great effort, to fix the modinfo field, but I don't particularly recommend this unless you have a lot of programming experience and some time.
I suggest the moodle developers catch the popup resources and fix them during the upgrade if the popup method is no longer supported.
Otherwise, the flv resource works great Version 2.1 seems to be running well at our sites and the upgrade process ran quite smoothly.
