LinuxMCE Forums

General => Users => Topic started by: trisc on November 05, 2007, 06:50:43 pm

Title: Can't clear video files database
Post by: trisc on November 05, 2007, 06:50:43 pm

Hi all

Using Myth TV in LinuxMCE seems to generate lots of video file entries that get left behind even though the actual media has expired from the system.

I cannot delete any of these files in LMCE and I was wondering if anyone else has this problem and whether it can be fixed.

Title: Re: Can't clear video files database
Post by: acematti on November 06, 2007, 06:05:09 pm

I think mine is also doing this too. Im not 100% as I had a lot of videos all in the same name I will double check tonight. ALthough im pretty sure i have seen something on the forums previously about this.

Matt

Title: Re: Can't clear video files database
Post by: trisc on November 06, 2007, 06:07:00 pm

Lots of videos with the same name is the same symptom. None of these can either be played or deleted.

Title: Re: Can't clear video files database
Post by: trisc on November 30, 2007, 07:31:53 pm

Anyone?

Is it possible to see these entries in the admin website and delete them from there?

Title: Re: Can't clear video files database
Post by: Thraxius on December 01, 2007, 02:10:24 am

Yeah this is a bug. I hope you found the solution on the forums if not here it is.

mysql pluto_media -uroot
DELETE FROM File WHERE Path LIKE '%upnp%';
quit

Title: Re: Can't clear video files database
Post by: totallymaxed on December 01, 2007, 12:05:06 pm

Quote from: Thraxius on December 01, 2007, 02:10:24 am

Yeah this is a bug. I hope you found the solution on the forums if not here it is.

mysql pluto_media -uroot
DELETE FROM File WHERE Path LIKE '%upnp%';
quit

If its a bug... and its not been reported before report it here http://mantis.linuxmce.org/my_view_page.php ;-)

Title: Re: Can't clear video files database
Post by: trisc on December 01, 2007, 01:53:30 pm

Thanks, that bit of SQL worked  :)