Bug Ahh! All my movies just got marked wached
#1
No idea how it happened... just went in and all my movies are marked watched. Not TV shows, just movies.. Looked in the database - sure enough, every single movie has at least a 1 on the playcount..

Unfortunately, no idea how it happened... I have a recent database backup, so I'll figure out how to write a SQL query to reset the playcount based on that tomorrow, so I didn't lose much... good thing I have a backup!

Apparently it happened a few starts of XBMC ago, nothing about it in the log. :/
Kodi: Kodi 17.4, with Transparency!
50 TB Unraid Server: Docker Apps: SABnzbd, Sickrage, mariaDB
HTPC: Win10 (cause Steam), i7, GTX 1080
Watching on: Panasonic TC65-PS64 with lowend Sony 5.1 HTIB
Other devices: rMBP 15", MBA 13", nvidia shield
Reply
#2
This is not a bug. you probably hit a button on your movie source location that marked them as watched.
Don't blame the software
Read/follow the forum rules.
For troubleshooting and bug reporting, read this first
Interested in seeing some YouTube videos about Kodi? Go here and subscribe
Reply
#3
You can easily change the play count back with some SQL like "UPDATE table SET playcount = playcount - 1;".
Reply
#4
or just hit "W" to mark them unwatched
Read/follow the forum rules.
For troubleshooting and bug reporting, read this first
Interested in seeing some YouTube videos about Kodi? Go here and subscribe
Reply
#5
(2013-07-22, 09:56)Martijn Wrote: or just hit "W" to mark them unwatched

But that would unwatch hundreds of movies I had watched!

(2013-07-22, 09:53)negge Wrote: You can easily change the play count back with some SQL like "UPDATE table SET playcount = playcount - 1;".

Ended up doing
Code:
UPDATE files SET playcount = playcount - 1 WHERE lastPlayed BETWEEN "2013-07-20 00:26:26" AND "2013-07-20 00:26:40";
- apparently it happened late on the 20th, and I just hadn't notice... that seems to have fixed it.
Kodi: Kodi 17.4, with Transparency!
50 TB Unraid Server: Docker Apps: SABnzbd, Sickrage, mariaDB
HTPC: Win10 (cause Steam), i7, GTX 1080
Watching on: Panasonic TC65-PS64 with lowend Sony 5.1 HTIB
Other devices: rMBP 15", MBA 13", nvidia shield
Reply
#6
It would be neat to have some kind of "undo" action for stuff like that. Of course this wouldn't be trivial to add.
Reply

Logout Mark Read Team Forum Stats Members Help
Ahh! All my movies just got marked wached0