[jstarks]

Ok so I am running v12 with a mysql database. I have gone in and updated column c14 of the Movie UP in the movie table to show Adventure / Animation / Comedy / Family / Disney, when I go to the movie in xbmc it shows as a genre. I then updated The genre table to have an entry of Disney.

I can not get it to show under genre in XBMC. What am i missing? do i need to update genrelinkmovie table with something to? The note in the database structure is that its also stored in c14 of the movie table so I am at a loss.

I would welcome any help!

Thanks

[jmarshall]

" do i need to update genrelinkmovie table with something to"

Yes. The genre information in c14 is just a shortcut (denormalized value) to save concatenating them all from the genre table.

[jstarks]

Thank you So much that did it!!!!

[jstarks]

I'm working on a shell script to add it. If anyone wants its?