Is there a Mantis bug reporting the failure to set the DVD's media type? Because though your workaround is useful, the underlying bug really should be fixed.
I think not setting FK_FileFormat is probably a bug as the ripper should know the source media. To set FK_MediaSubType which describes content (TV Shows, Movies, Home Videos,...) will take user intervention, probably a change to the UI to prompt the user. So I'll file two bugs.
you can do some experimenting, but I believe if the media type is set to DVD, then the DVD menu options will be avaiable when that media is played.
That makes sense. Thank you. I'll investigate this and if a DVD has a menu but the EK_MediaType is being set to LinuxMCE video file, then I'll open a bug for it.
FYI here's some commands from this investigation:
Find missing FK_FileFormat or missing FK_MediaSubType:
mysql> select Path,Filename,FK_FileFormat,FK_MediaSubType from File where IsDirectory = '0' and Path like '/home/public/data/videos%' and (FK_FileFormat is null or FK_MediaSubType is null);
Set missing FK_FileFormat to DVD (DVD == 2):
mysql> update File set FK_FileFormat = '2' where IsDirectory = '0' and Path like '/home/public/data/videos%' and FK_FileFormat is null;
Set missing FK_MediaSubType to Movies (Movies == 2):
mysql> update File set FK_MediaSubType = '2' where IsDirectory = '0' and Path like '/home/public/data/videos%' and FK_MediaSubType is null;