Kodi Community Forum
TV Show Info / Cleaning - Printable Version

+- 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: TV Show Info / Cleaning (/showthread.php?tid=164859)



TV Show Info / Cleaning - john_es - 2013-05-14

I store my database on a NAS. Yesterday I noticed that even though I have my shows in separate folders, one of the shows is intermingled in another one. So I set the content to none, and it was still showing the cover art for one show. I removed it from the databse via right click, but it still stayed there.

I cleaned the database, and it still appeared.

I queried the tvshow table and saw five entries like this:
Code:
|    198 | NULL | NULL                                                                                                                                                                                                                                                                                                                               | NULL | NULL | NULL     | NULL       | NULL | NULL | NULL  | NULL | NULL | NULL | NULL  | NULL  | NULL | NULL | NULL                                           | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+------+----------+------------+------+------+-------+------+------+------+-------+-------+------+------+------------------------------------------------+------+------+------+------+------+------+------+
4 rows in set (0.00 sec)

What can I do to clean this up? My guess is that it's not as simple as simply removing these 5 NULL records. Is that the source of the problem?

What can I do?

Thanks,
John