2016-04-01, 01:09
For some reason, all of the new shows I add are displaying duplicates in recently added for TV shows and Movies. I ran a query in Phpmyadmin:
SELECT *, COUNT(*) FROM `files` GROUP BY `strFilename` HAVING COUNT(*) > 1 ORDER BY `strFilename` ASC
I don't see any duplicates listed. Where else would they be? I had a few duplicates at first when I ran the query but I removed the dups. I still see dups listed under recently added but I can't find them under FILES in the table.
SELECT *, COUNT(*) FROM `files` GROUP BY `strFilename` HAVING COUNT(*) > 1 ORDER BY `strFilename` ASC
I don't see any duplicates listed. Where else would they be? I had a few duplicates at first when I ran the query but I removed the dups. I still see dups listed under recently added but I can't find them under FILES in the table.