+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Bug "Duplicate" movie genres with space at start of name (/showthread.php?tid=146925)
"Duplicate" movie genres with space at start of name - jacksleight - 2012-12-02
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.
RE: "Duplicate" movie genres with space at start of name - jmarshall - 2012-12-02
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!
RE: "Duplicate" movie genres with space at start of name - jacksleight - 2012-12-03
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.
RE: "Duplicate" movie genres with space at start of name - jmarshall - 2012-12-03
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.
RE: "Duplicate" movie genres with space at start of name - jacksleight - 2012-12-03
Will that not still give me duplicates? As there will still be two records in the DB called "Comedy" etc.
RE: "Duplicate" movie genres with space at start of name - jmarshall - 2012-12-03
It will if there's two records, yes. That's a bit harder to figure out the sql...