Posts: 7
Joined: Dec 2012
Reputation:
0
Running XBMC 12.0 BETA1 on a Raspberry Pi (raspbmc) using The Movie Database scraper.
I have an issue where XBMC is listing some movie genres twice, with different films in each. I checked the SQLite db and it appears that the duplicates have a space at the beginning of the name ie. I have "Comedy" and " Comedy". Is there an easy way to fix this?
Thanks.
Posts: 26,215
Joined: Oct 2003
Reputation:
187
If you have an example film that you can reproduce this with, please post a ticket on trac so we can look into it.
Thanks!
Posts: 7
Joined: Dec 2012
Reputation:
0
I've realised this is not an bug in XBMC, at least it's not the TMDB add-on that's the issue.
All of my movie folders have .nfo files in, and these were created from an old XBMC install that used the IMDB add-on for metadata. These files have genres with spaces at the beginning*, so XBMC is obviously pulling in these genres, as well as the ones it gets from TMDB. As the IMDB plugin is currently broken I can't use that instead.
I guess the best option would be to remove the IMDB genres from the database, and then re-export the .nfo files? Or should I just delete all the nfo files and re-import all the movies, so it only uses the data from TMDB?
* Of course, there could be a bug in the IMDB add-on, but as this was an old install it may well be fixed by now (and I can't test anyway). If this information is useful to anyone: every genre and actor name, except the first, has a space at the start of the name.
Posts: 26,215
Joined: Oct 2003
Reputation:
187
You should be able to fix it in the database pretty easily:
select strGenre from genre where strGenre like ' %';
should return the rows with a space at the beginning, then:
update genre set strGenre=substr(strGenre,2) where strGenre like ' %';
should do the trick to update 'em all.
Then re-export to update your .nfo files.
Posts: 7
Joined: Dec 2012
Reputation:
0
Will that not still give me duplicates? As there will still be two records in the DB called "Comedy" etc.
Posts: 26,215
Joined: Oct 2003
Reputation:
187
It will if there's two records, yes. That's a bit harder to figure out the sql...