Author Topic: Easy way to isolate missing media and delete?  (Read 3040 times)

colinjones

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 3003
    • View Profile
Easy way to isolate missing media and delete?
« on: November 09, 2008, 03:21:46 am »
I have a lot of media in my database that is "missing" because I have renamed the files to get rid of bad characters. But they are spread out all over the share. Is there a sql query I can use to safely select them all and delete them? Also, is the flag to mark "missing from disk" the same as that used to flag files on devices that are offline?