Extra file pointers in database - how to remove?

[wortmanb]

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]

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]

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