Author Topic: [SOLVED (unborked)] Video Database Borked  (Read 922 times)

twodogs

  • Guru
  • ****
  • Posts: 224
    • View Profile
[SOLVED (unborked)] Video Database Borked
« on: September 26, 2011, 01:01:36 am »
Trying to install a larger internal drive for media, but not doing a very good job!
- I let the system detect the new drive and install the LMCE file structure
- I then copied my videos (3 files per video, actually) from the old drive to the new
- Then I deleted the device for the old drive using LMCE admin

Now there are many duplicates of coverart for each movie, and I'm seeing all the installation videos and such.
Fixable, or do I need to reinstall?

Maybe this post might be what I need, but I can't even shut down LMCE from the launch manager (gives "KDE sudo error" popup)

http://forum.linuxmce.org/index.php/topic,6408.msg41219.html#msg41219



« Last Edit: October 01, 2011, 04:42:49 pm by twodogs »
http://greenrenovation.wordpress.com/home-automation/
system:
ASUS P5N7A-VM
integrated GeForce 9300
E5200 processor
Fusion 5 lite HDTV card
2G RAM
SYBA SY-PCI15001 6-port serial card
Denon AVR 3805
LG 42" Plasma
Gyration GYR3101
Cisco SPA3102 analog telephone adapter
Cisco 7971G IP phone/orbiter

ardirtbiker

  • Guru
  • ****
  • Posts: 249
    • View Profile
Re: Video Database Borked
« Reply #1 on: September 26, 2011, 03:47:14 am »
It is fixable...

Ive not been able to find a way to 'rebuild' the attributes for media files without going to each one thru the admin web interface using  Files and Media > Media Files Sync.

Even a re-install will not fix it.. at least Ive not been able to with about 8 to 10 re-installations of 8.10 and 10.04.

If someone else knows a 'trick' I'd sure like to know.

Dennis
« Last Edit: September 26, 2011, 03:48:50 am by ardirtbiker »

twodogs

  • Guru
  • ****
  • Posts: 224
    • View Profile
Re: Video Database Borked
« Reply #2 on: September 26, 2011, 08:22:22 am »
When I looked in /home/mediapics there were more than 11,000 coverart pics!
« Last Edit: September 26, 2011, 02:49:48 pm by twodogs »
http://greenrenovation.wordpress.com/home-automation/
system:
ASUS P5N7A-VM
integrated GeForce 9300
E5200 processor
Fusion 5 lite HDTV card
2G RAM
SYBA SY-PCI15001 6-port serial card
Denon AVR 3805
LG 42" Plasma
Gyration GYR3101
Cisco SPA3102 analog telephone adapter
Cisco 7971G IP phone/orbiter

ardirtbiker

  • Guru
  • ****
  • Posts: 249
    • View Profile
Re: Video Database Borked
« Reply #3 on: September 27, 2011, 12:33:45 am »
Ive got 910 files in there (there should be 2 each for each title --- one pic is smaller than the other)  that leaves 405...   ive got around 300 movies on my core, and maybe 50 cds.   

Something is 'afoot' with yours...

Dennis

twodogs

  • Guru
  • ****
  • Posts: 224
    • View Profile
Re: Video Database Borked
« Reply #4 on: September 29, 2011, 06:12:33 pm »
This is weird. The following code run in a terminal reinstalled an empty media database. I restarted the orbiter and no videos appeared, as expected. I rebooted, and all my videos looked good - one copy of each. Then a few minutes later, all the duplicates reappeared.
So my thread title is wrong. Something is borked, that is borking the database.

Code: [Select]
/usr/pluto/bin/UpdateMediaDaemonControl.sh -disable

mysql -uroot

drop database pluto_media;
quit

cp /usr/pluto/database/media.sqlcvs .

/usr/pluto/bin/sqlCVS -D pluto_media -r media import

/usr/pluto/bin/UpdateMediaDaemonControl.sh -enable
« Last Edit: September 29, 2011, 08:46:15 pm by twodogs »
http://greenrenovation.wordpress.com/home-automation/
system:
ASUS P5N7A-VM
integrated GeForce 9300
E5200 processor
Fusion 5 lite HDTV card
2G RAM
SYBA SY-PCI15001 6-port serial card
Denon AVR 3805
LG 42" Plasma
Gyration GYR3101
Cisco SPA3102 analog telephone adapter
Cisco 7971G IP phone/orbiter

F1forHELP

  • Regular Poster
  • **
  • Posts: 29
    • View Profile
Re: Video Database Borked
« Reply #5 on: October 01, 2011, 10:29:00 am »
It looks like you might have added the root drive in the core and it is recursively detecting your movies via the /home/public => /mnt/device/xx mount point(s).  I had that happen to me once a few installs ago and I fixed it by removing the (Core Root) sda drive through the web admin.

Standard disclaimers apply.

Joseph Hume
F1 for HELP

twodogs

  • Guru
  • ****
  • Posts: 224
    • View Profile
Re: Video Database Borked
« Reply #6 on: October 01, 2011, 04:42:09 pm »
Hot damn, that was it! I went to the devices tree and looked at the two disks showing up. One was the new media drive I had just purchased and installed, the other was the drive that held the core. I thought that was the way it was supposed to be. I deleted the device for core's hard drive, deleted the 3000 files in mediapics, then opened a terminal and reformed the video database as shown above. After restart things were back to normal. I also noticed that the hard drive I deleted was set to "public" instead of "use LMCE file structure". That always seems to cause trouble as well - don't really know why the public option even exists.
Until this point, I had been trying to fix this through media synch.

Thanks F1
« Last Edit: October 01, 2011, 04:45:04 pm by twodogs »
http://greenrenovation.wordpress.com/home-automation/
system:
ASUS P5N7A-VM
integrated GeForce 9300
E5200 processor
Fusion 5 lite HDTV card
2G RAM
SYBA SY-PCI15001 6-port serial card
Denon AVR 3805
LG 42" Plasma
Gyration GYR3101
Cisco SPA3102 analog telephone adapter
Cisco 7971G IP phone/orbiter