[SOLVED (unborked)] Video Database Borked

[twodogs]

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

[ardirtbiker]

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

[twodogs]

When I looked in /home/mediapics there were more than 11,000 coverart pics!

[ardirtbiker]

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]

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:

/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

[F1forHELP]

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]

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