Author Topic: Extra file pointers in database - how to remove?  (Read 817 times)

wortmanb

  • Regular Poster
  • **
  • Posts: 18
    • View Profile
Extra file pointers in database - how to remove?
« on: February 07, 2008, 02:13:24 am »
I tried to force some updating in my database by manually running the UpdateMedia script, but I passed it a directory string beginning with a dot ("."), and now these (and other) files are lingering in my database and I can't delete them through the usual Orbiter menu mechanisms.

Any thoughts on how to remove these?  Thanks!


Bret

colinjones

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 3003
    • View Profile
Re: Extra file pointers in database - how to remove?
« Reply #1 on: February 07, 2008, 05:24:21 am »
Try navigating to the folders you don't want in the admin site and use the Delete File option there - then let me know if it deleted all your actual media as well as the database entries.... I did the same thing, and want to know the answer :)

Just kidding of course ;)

wortmanb

  • Regular Poster
  • **
  • Posts: 18
    • View Profile
Re: Extra file pointers in database - how to remove?
« Reply #2 on: February 08, 2008, 03:41:30 am »
I can't navigate to them that way (believe me, I tried), I think because the paths are like "./movies/file.avi" and I haven't figured out how to get them to show up in the media files sync pages.  I expect this is going to take some SQL code and I just don't want to do things halfway and completely bollocks the database....


Bret