Author Topic: Can't clear video files database  (Read 3969 times)

trisc

  • Regular Poster
  • **
  • Posts: 22
    • View Profile
Can't clear video files database
« 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.
Asus P5PL2-E ATX
Gigabit Ethernet port
Pentium Dual Core2 1.8GHz
1GB Kingston DDR RAM
Asus EN6200 PCI-E Graphics card
Philips DVD-RW
10/100 NIC WinTV Nova-T500

acematti

  • Veteran
  • ***
  • Posts: 50
    • View Profile
Re: Can't clear video files database
« Reply #1 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

trisc

  • Regular Poster
  • **
  • Posts: 22
    • View Profile
Re: Can't clear video files database
« Reply #2 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.
Asus P5PL2-E ATX
Gigabit Ethernet port
Pentium Dual Core2 1.8GHz
1GB Kingston DDR RAM
Asus EN6200 PCI-E Graphics card
Philips DVD-RW
10/100 NIC WinTV Nova-T500

trisc

  • Regular Poster
  • **
  • Posts: 22
    • View Profile
Re: Can't clear video files database
« Reply #3 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?
Asus P5PL2-E ATX
Gigabit Ethernet port
Pentium Dual Core2 1.8GHz
1GB Kingston DDR RAM
Asus EN6200 PCI-E Graphics card
Philips DVD-RW
10/100 NIC WinTV Nova-T500

Thraxius

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: Can't clear video files database
« Reply #4 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

totallymaxed

  • LinuxMCE God
  • ****
  • Posts: 4660
  • Smart Home Consulting
    • View Profile
    • Dianemo - at home with technology
Re: Can't clear video files database
« Reply #5 on: December 01, 2007, 12:05:06 pm »
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 ;-)
Andy Herron,
CHT Ltd

For Dianemo/LinuxMCE consulting advice;
@herron on Twitter, totallymaxed+inquiries@gmail.com via email or PM me here.

Get Dianemo-Rpi2 ARM Licenses http://forum.linuxmce.org/index.php?topic=14026.0

Get RaspSqueeze-CEC or Raspbmc-CEC for Dianemo/LinuxMCE: http://wp.me/P4KgIc-5P

Facebook: https://www.facebook.com/pages/Dianemo-Home-Automation/226019387454465

http://www.dianemo.co.uk

trisc

  • Regular Poster
  • **
  • Posts: 22
    • View Profile
Re: Can't clear video files database
« Reply #6 on: December 01, 2007, 01:53:30 pm »
Thanks, that bit of SQL worked  :)
Asus P5PL2-E ATX
Gigabit Ethernet port
Pentium Dual Core2 1.8GHz
1GB Kingston DDR RAM
Asus EN6200 PCI-E Graphics card
Philips DVD-RW
10/100 NIC WinTV Nova-T500