How to delete a movie title from list?

[gdrider77]

So here is my issue, i have a movie (The lord of the Rings: Return of the King) showing up in my list view in mymovies. I do not have this movie? It is not listed in my collection manager so there is no way to delete it. If i click on the movie in mymovies interface (inside sagetv) it says that the movie is stored offline, with no options except cancel. I have tried rebuilding the database inside of sagetv with the mymovies plugin, i have also tried to optimize the database inside of collection management, and also reset numbers in collection management, but nothing works.

Where is it getting this title from? Is there an XML file or something that i can manually change myself? How can i fix this?

Thanks.

[PLUCKYHD]

Originally Posted by gdrider77

So here is my issue, i have a movie (The lord of the Rings: Return of the King) showing up in my list view in mymovies. I do not have this movie? It is not listed in my collection manager so there is no way to delete it. If i click on the movie in mymovies interface (inside sagetv) it says that the movie is stored offline, with no options except cancel. I have tried rebuilding the database inside of sagetv with the mymovies plugin, i have also tried to optimize the database inside of collection management, and also reset numbers in collection management, but nothing works.

Where is it getting this title from? Is there an XML file or something that i can manually change myself? How can i fix this?

Thanks.

It has to be in your collection manager somewhere for it to show. Try filtering the collection manager by offline titles.

[gdrider77]

I would have assumed that too, but its not. I have filtered offline titles only and its not there (although there are about 50 titles in there, that are not offline, not even sure why they are listed that way. I believe its because i put only the movies, but some movies have other discs that i do not rip to my server? So it shows the other discs as offline.)

I have looked through the entire list and it does not exist. If it were, i would have deleted it. It just somehow keeps showing up in the list.

This information has to be stored somewhere? One thing i noticed, if i sort by collection number in the sageui, it is listed as number #1. Is there a way to rebuild the database or something?

[PLUCKYHD]

Originally Posted by gdrider77

I would have assumed that too, but its not. I have filtered offline titles only and its not there (although there are about 50 titles in there, that are not offline, not even sure why they are listed that way. I believe its because i put only the movies, but some movies have other discs that i do not rip to my server? So it shows the other discs as offline.)

I have looked through the entire list and it does not exist. If it were, i would have deleted it. It just somehow keeps showing up in the list.

This information has to be stored somewhere? One thing i noticed, if i sort by collection number in the sageui, it is listed as number #1. Is there a way to rebuild the database or something?

Yes read the wiki to rebuild. Did you check title #1? check te info sometimes the title on the right of collection manager isn't right.

[gdrider77]

Thanks for all the help, i really do appreciate it. When i said rebuild, i kind of meant a forced way. I have already tried to rebuild using the option in the sageui, under the mymovies configure option. Although it says "rebuilt database" implying that i am loading a previously built database, i am assuming that you are referring to this option, and that this does indeed rebuild the database. In my colleciton manager, movie#1 is correct and works fine, an points to the right file, named correctly, etc..

I have tried using the "rebuilt database" function numerous times, and had no luck.

Basically, it seems i have a corrupt database. Does your plugin and mymovies use different databases? It seems like the mymovies database is correct, but that the sageui/mymvies plugin database is wrong. As i see no mention of this movie in my movies collection manager, only in sageui/mymovies list.

[PLUCKYHD]

When you rebuild the datafile it is deleted and completely rebuilt from mymovies. Knowing the code there is no way for a movie to show up that is not in the collection manager somewhere or at least in the mm database. As I read direct from there.

[gdrider77]

yes, i would have assumed that the rebuild database would do that, but it does not. Is it somehow being cached?

I am thinking maybe uninstall, then reinstall and that might fix it. I just need to delete the database file that your plugin is creating, as that is what seems to be corrupt, and rebuilding database does not fix it.

[gdrider77]

I found this post...http://forums.sagetv.com/forums/show...t=51399&page=2

Followed all those steps, no luck, that movie still shows up in the list???