Re-initialising/clearing the media database...

[tschak909]

Yes. I will post some details on it later. Point being, it's persisted.

-Thom

[davegravy]

be sure to go to launch manager, and shut down core and media station.

then from a console:

Code:

mysql -uroot

drop database pluto_media;
quit

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

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

That will re-flash your media database with a fresh copy from the release.

-Thom

Does this work in 810? How do you stop the Core and MD in 810?

[speeder13]

I accidentally sync the whole "home" into my media database..Now it has bunch of weird videos (including those wizard video) in my media under "title". How can i remove them without messing up my system? 

I saw some solutions in this thread.. Will it be safe if i use the ways? Because it included everything in the "home" i am afraid i might break the whole system if i do any deletion.

Thx in advance....

[tschak909]

lesson learned, don't fuck with things manually. this is what you get.

you'll need to drop the database and recreate it.

Seriously guys, all of you cause so many ^(@#^(@# problems because you tweak with stuff, you don't let the automatic stuff do its thing...

hmm.

-Thom

[Lexje]

With respect;-
I  realize this question must have been raised more than a couple of times, but I can't seem to find a 'clean' answer.
Over time my media database has grown, and at several occasions I found to have double or triple items in it.
I come to realize now that this is most probably due to e.g. having

Code:

/moviedir
/moviedir/moviesubdir
/moviedir/moviesubdir/movie.iso

or whatnot as being present 3 time in this example in the media database.

I also realize there's a button "delete file" in Pluto Admin > Files & Media > Edit Media file but this will remove the file BOTH from database AND disk.
I'm looking for a way to remove ONLY from database?

Thanks for any pointer,

Erwin

[colinjones]

I'm not sure what you mean.... a folder or subfolder will not appear as a media file unless you do something to make it happen manually.

I have many hundreds of folders, none of which appear as media files except in Filename sort mode in which case they are appearing as folders with files underneath them, exactly as they are supposed to do (if they didn't it would render Filename sort mode pointless)

When sorted by an attribute such as album, if you manually assign an Album attribute to a folder (rather than a file) then yes, they will appear... but that is OK too, because that is exactly what you just told it to do! If you don't want these folders to appear in those sort modes, don't assign attributes to them... there is no other reason to do so.

[Lexje]

Hi Colin, thanks for replying;

I guess it's well possible that in the course of time, and certainly with a lack of knowledge and comprehension (this greatly improved viewing Thom's screencast on using media) that I erroneously created this situation.
I'm not stating this is an error of LMCE whatsoever.
Only problem is say I have 'a' particular movie, let's call it "Desperate Housewives", that appears say 3 times, and only plays when choosing the correct one (normally bottommost in filestructure order).

I have this situation more than once, and I would like to resolve this situation.
In a best case scenario, any media displayed should either be playable or invisible.

In my case, see screenshot, Disc 3 appears two times, when choosing item 2 on the search list (search on title), the video won't play..

So how can I remedy this situation (manually) if need be?

Thanks for helping out!

Erwin

[davegravy]

Look to see if disc three has 2 title attributes, and if it does, delete the one you don't want.

[Lexje]

Hi Dave,

Thanks for jumping in;
There are no 2 'Title' attributes... I do remember to have edited the title to reflect the disc number (as it is a 5 disc collection) otherwise there's no way to distinguish between disc 1 / disc 5...

When I do Pluto Admin > Files & Media > Media Browser
check title checkbox and enter desperate housewives I get the same 3 "titles", clicking on detail shows one empty...

[colinjones]

Oh you are talking about when you use the search function. Not when you are using the normal media browser.

Yes, that does happen, your experience is normal... if a little irritating! The search finds all entries in the database that match the search criteria which naturally includes the parent folders not just the file. Indeed, try doing the analogous search on a Windows machine.... you will find it does exactly the same thing.... it will find the media file Desparate Housewives as well as its parent folder Desparate Housewives because both match the search criteria.

The confusing and annoying thing in LMCE is that 1) it isn't obvious which is a file and which a folder, and 2) if you select a folder, LMCE will attempt to "play" it rather than enter it and display its contents

[Viking]

be sure to go to launch manager, and shut down core and media station.

then from a console:

Code:

mysql -uroot

drop database pluto_media;
quit

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

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

That will re-flash your media database with a fresh copy from the release.

-Thom

Does this work in 810? How do you stop the Core and MD in 810?

This question for 0810 was never answered ...

Do I start the core in single user mode and then do it ?
How can one do it in 0810 ?

Greetings
Viking

[the anxious]

thanks to tschak909

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

[bulek]

be sure to go to launch manager, and shut down core and media station.

then from a console:

...

That will re-flash your media database with a fresh copy from the release.

-Thom

How can I go to Launch Manager ? I only see launch manager when something is wrong or crashes...

Thanks,

Regards,

Bulek.

[twodogs]

I just performed the procedure in post 26 and it worked great. No need to go to the launch manager, the first line of code stops the media daemon. I just went to KDE desktop and brought up a terminal. The only minor problem is that the "-disable" and "-enable" commands need to have short dashes, not long dashes. The following should work if you want to copy/paste into the terminal.

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

[bulek]

Hi,

I have followed procedure on 7.10 and got only partial success. I've managed to shutdown core services, dropped database, imported fresh one. Enabled daemon, but the problem is that after 3 days, if I press Filename option in Video or Audio menus I get empty screen - seems like no media file is present...

Through web-admin I can find files that have Location filled - for instance "/home/public/data/videos/Media [41]/Funny/name_movie.mp4" but they don't appear on Orbiters...

What is wrong - maybe I'm missing something obvious ?

Thanks in advance,

regards,

Bulek.