If you like me just pulled drives from your QNAP when expanding instead of going through the “expand, pull one drive, wait for resync, pull another blabla” as the manual states, you can manually expand it by: replace /dev/md0 with your md device from cat /proc/mdstat mdadm –grow /dev/md0 –size=max and then: pvdisplay, grab the…(Continue Reading)
Year: 2017
Kodi: “mark as watched” on tv show not working
Had an issue where “Mark as watched” did not actually mark a show as watched as seen on the “in progress shows” page, probably because I’ve removed/moved files since beginning to watch a show. solution: 1. replace XX with the showId from tvshow table. gist here
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
select episode.idEpisode from tvshow, episode where episode.idShow = tvshow.idShow AND tvshow.idShow = XX into outfile '/tmp/alleps'; select episode.idEpisode from tvshow, episode, files where episode.idShow = tvshow.idShow AND files.idFile = episode.idFile AND tvshow.idShow = XX into outfile '/tmp/watchedeps'; |
diff /tmp/alleps /tmp/watchedeps DELETE FROM episode WHERE episode.idEpisode…(Continue Reading)