Can't clear video files database

[trisc]

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.

[acematti]

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

[trisc]

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

[trisc]

Anyone?

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

[Thraxius]

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

[totallymaxed]

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 ;-)

[trisc]

Thanks, that bit of SQL worked