Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 545078" data-attributes="member: 18896">jlr2000, you can also go straight to the database source. Open movingpictures.db3 (it's in the database folder of your MediaPortal data folder) in a program such as 'SQLite Database Browser' (I believe it is even included with the main MediaPortal install, can't remember now, but otherwise download it directly from: <a href="http://sqlitebrowser.sourceforge.net/" target="_blank">SQLite Database Browser</a>).Then you click on the &quot;Browse Data&quot; tab, adjust the table to 'local_media' and the 3rd column named 'fullpath' will give you a very easy look as to what movies you had that were on the failing drive.Now it shows all locations, so you want to filter it down to just the failing one, so click the magnifying glass icon, adjust the first drop down box to 'fullpath', change the '=' one to 'contains' and enter the part that uniquely identifies that failing drive, such as 'E:\'.And the result will be a nicely filtered list with all the movies you want to rerip.</blockquote>

[QUOTE="RoChess, post: 545078, member: 18896"] jlr2000, you can also go straight to the database source. Open movingpictures.db3 (it's in the database folder of your MediaPortal data folder) in a program such as 'SQLite Database Browser' (I believe it is even included with the main MediaPortal install, can't remember now, but otherwise download it directly from: [url=http://sqlitebrowser.sourceforge.net/]SQLite Database Browser[/url]). Then you click on the "Browse Data" tab, adjust the table to 'local_media' and the 3rd column named 'fullpath' will give you a very easy look as to what movies you had that were on the failing drive. Now it shows all locations, so you want to filter it down to just the failing one, so click the magnifying glass icon, adjust the first drop down box to 'fullpath', change the '=' one to 'contains' and enter the part that uniquely identifies that failing drive, such as 'E:\'. And the result will be a nicely filtered list with all the movies you want to rerip. [/QUOTE]

Verification