2015-01-14, 06:42
After my raspberry pi system was automatically (ugh) upgraded to Kodi 14.0, a subsequent update library revealed a problem. Some of my media is stored in rars. Each and every one of these, and no others, were duplicated during the scan:
Both items are playable. Cleaning the library doesn't remove either. I assume I will need to remove the old version, otherwise the next update will simply re-add the duplicate. Manually removing all of the duplicates would likely take a few hours. Alternatively, I could probably fix them all programmatically in mysql, but I'd rather not if I can avoid it.
Has anyone else had to deal with this problem?
Code:
mysql> select * from files where strFilename like '%Avatar%';
+--------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------+---------------------+
| idFile | idPath | strFilename | playCount | lastPlayed | dateAdded |
+--------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------+---------------------+
| 3492 | 1535 | rar://%2fmedia%2fdisk%2fxbmc%2fmovies%2fAvatar.2009.EXTENDED.1080p.BluRay.x264-BestHD%2fbesthd-avatar.extended-1080p.rar/besthd-avatar.extended-1080p.mkv | NULL | 2015-01-10 03:04:33 | 2014-02-16 20:37:13 |
| 3602 | 1535 | besthd-avatar.extended-1080p.rar | NULL | NULL | 2014-02-16 20:37:13 |
+--------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------+---------------------+
2 rows in set (0.16 sec)
Both items are playable. Cleaning the library doesn't remove either. I assume I will need to remove the old version, otherwise the next update will simply re-add the duplicate. Manually removing all of the duplicates would likely take a few hours. Alternatively, I could probably fix them all programmatically in mysql, but I'd rather not if I can avoid it.
Has anyone else had to deal with this problem?