Problem with Certification Filter/Problem mit Altersfreigabefilter (1 Viewer)

[mcl]

Hi there,

today i wanted to add the german age certifications to my movie database. before i only had a few american ones (like pg´, r, nc-17). those have always been shown in my menu.
so i used the sqllitebrowser and began to fill in the missing certifications (like 6, 12, 16, 18). after the first 20 entries i wanted ti check if everything had worked so far.

the first thing that happend was a crash of the configuration tool. then i could re-open the config. when i clicked the "define movie categories" button i got an error: "System.NullReferenceException: Object reference not set to an instance of an object".
the "funny" thing is that i got the menu item Altersfreigaben (=Certifications) and it shows me all the possibilites like 16, 18 and the old PG-13, R etc. and there is also the +-symbol. but when i hit the "plus" which should show me the movies i get this error again.

all other filters work (like year, video resolution, genre etc.). reinstall of movingpictures didnt change anything. i also deleted the movingpictures.dll and reinstalled. i deleted all certifications and tried to enter them again. nothing helps.

the only thing i haven' deleted is the database itself. and i also won't do that. it was too much work

what else can i do?

thanks for any help and sorry for my bad english


btw the whole error text says:
System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
bei Cornerstone.Database.Tables.DBCriteria`1.isIncluded(Object value)
bei Cornerstone.Database.Tables.DBCriteria`1.Filter(ICollection`1 input)
bei Cornerstone.Database.Tables.DBFilter`1.Filter(ICollection`1 input)
bei Cornerstone.Database.Tables.DBNode`1.GetFilteredItems()
bei Cornerstone.GUI.Filtering.GenericMenuTreePanel`1.updateFilteredItems(TreeNode treeNode, Boolean forcePopulation)
bei Cornerstone.GUI.Filtering.GenericMenuTreePanel`1.treeView_BeforeExpand(Object sender, TreeViewCancelEventArgs e)
bei System.Windows.Forms.TreeView.OnBeforeExpand(TreeViewCancelEventArgs e)
bei System.Windows.Forms.TreeView.TvnExpanding(NMTREEVIEW* nmtv)
bei System.Windows.Forms.TreeView.WmNotify(Message& m)
bei System.Windows.Forms.TreeView.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

[fforde]

You probably shouldn't have started editing your database with SQLiteBrowser. If you need to change the certification value of your actual movies you should be using the Movie Manager in the configuration screen. And if you want to modify the Categories (or Filters) menu, you can get started by clicking the button on the GUI Settings section of the configuration screen. Even this should not be necessary though, the Certifications menu item is dynamic and will be automatically populated with whatever values are stored for your movies.

So I would recommend reverting to an older backup before you started messing with the actual database, then use the configuration screen to make your changes. I hope you made a backup.

 

[mcl]

AW: Problem with Certification Filter/Problem mit Altersfreigabefilter

so, i finally got a solution!
i don't think using sqllitebrowser is a problem. at least it hasn't been any so far. i just set a new value for certification for all movies (UPDATE movie_info SET certification = 18) because i thought it could be that there is a cell with an invalid entry. well, what can i say: it seems i was right. now everything works again

 

[fforde]

Glad you got things working! And no, using sqlitebrowser normally should not be a problem, it is just very easy to break things when using it. If you edit things in the Movie Manager in the configuration screen, it will prevent situations like this.

Anyway, happy movie watching.