Strange Behaviour with mappe NAS (1 Viewer)

[Paglioni]

Hi
i have a mapped nas drive (y at home, and full database of movingpicture (movp from now) working on an xp machine with all movies info.

then i've done that:

I've installed mp in another computer
Copied the nas contents on another nas server
mapped the new nas (y on the new computer
copied all MP databases, including movp one
started movp config
what i've got then is movp scaning and adding again all movies, without removing old ones (marking them in RED)
i've noticed that the old entry and the new one has a MEDIA info with different name (the share name, not the letter, that was Volume_2 in the old nas, and Volume_1 in the new)
then i renamed Volume_1 in the new nas in Volume_2 (as the old nas)
recopied original movp database
reopened the config of movp
got the scan and double entry again... this time with the same MEDIA info in each movie.

why?

 

[armandp]

The label is not the unique identifier for the disk.. it's the volume serial and that's different for every partition..
We already have an issue for it in our tracker.

Issue 346: Update Import Path

There's a (simple, one time) workaround but it involves a SQLite editor, are you up for that?

 

[Paglioni]

oh yeah.. but how?

 

[armandp]

Ok, you asked for it

Before trying this, BACKUP your database!!

1. Close down mediaportal / moving pictures completely
2. Start your favorite SQLite editor
3. Open the "movingpictures.db3" database.

location differs depending on your OS
Example: C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\database

4. Open to the import_path table
5. Write down the IDs for import paths that were moved to a different disk
6. Open up the query editor and write the following query:

UPDATE local_media
SET volume_serial = NULL
WHERE importpath IN (?,?, etc... )

replace ? with the ID's you wrote down in step 5)

Example for multiple import paths (ID 2, 6 and 7):

UPDATE local_media
SET volume_serial = NULL
WHERE importpath IN (2,6,7)

Example for one import path (ID = 5):

UPDATE local_media
SET volume_serial = NULL
WHERE importpath = 5

7. Execute the query, it should report that it affected # number of objects
8. Close down the SQLite editor
9. Start MediaPortal Configuration -> Plugins -> Moving Pictures -> CONFIG
10. Moving Pictures will now update the database and restore the new volume_serials.

 

[Paglioni]

I did that the same day you wrote here, and it worked.
Today i redid the import (i've added movies since that day) and the importer again found all the movies as new. I did some matching, and now i have many movies with double entries, one correct (the old one) and one with "|MYmovies" appended at the and of the movie name under the movie manager.

Often, the doubled entry, has the correct italian name, when the old entry (in red) had the english movie name.

I think that this means the italian scraper found the movie today when it wasn't able to find it in the past and used imdb name.

This is fine, but i really can't stand the "|MYmovies" right of the movie name...

another strange thing is that the old entry has the "date added" set to 13/02/2009 , the new one is dated back in 2005 year (with different day/month).

Sorry for my english

Marco

 

[armandp]

I think you are experiencing several issues:

A) The "|mymovies", i think is caused by the italian data provider, perhaps the scripts needs to be updated.
B) There are some issues with the date added import, this will addressed in 0.8
C) The duplicate entries are probably caused by the same error as before, you know the workaround - a fix has been committed for 0.8 that will do this automatically in the future (untill then, please hang in there )

 

[Paglioni]

I think you are experiencing several issues:

A) The "|mymovies", i think is caused by the italian data provider, perhaps the scripts needs to be updated.
B) There are some issues with the date added import, this will addressed in 0.8
C) The duplicate entries are probably caused by the same error as before, you know the workaround - a fix has been committed for 0.8 that will do this automatically in the future (untill then, please hang in there )

A) it can be
b) ok
c) i haven't changed anything in the NAS/map/hd since last import.. i didn't do a backup this time, so i think i'll do the reimport from scratch again... how i can remove the red entries from the db?


by the way, is there a way to have a svn build without setting up a compiler on my machine?

 

[Paglioni]

Update:

A) i've update the mymovies.it script and now only few entries display the "|MYmovie"
C) i've deleted new entries in the db, did the deletion of the volume_serial, and then did a new scan, this time all worked fine. Dunno why the serial of the disk changed (the nas has a 4 disk RAID 5, but i don't think that it gives different serial numbers)

thanks for the help

 

[armandp]

I think it was a glitch in the plugin and that it did not get a proper serial when it was launched. Anyway for 0.8 this will be automatically corrected.
However if it was to happen again with your current version it could be very helpfull if you would save the debug log of when the movies were duplicated.
This way we can track the cause

 

[thomas_fogh]

...
Example for one import path (ID = 5):

UPDATE local_media
SET volume_serial = NULL
WHERE importpath = 5

...

I had the same problems and did the above. The double entries are no longer red, but I do still have double entries...
Thanks for a otherwise excellent plugin!
BR, Thomas Fogh