How to erase watching history?

paradadf · August 3, 2016 at 7:26 PM

Hello everyone!

I'd like to know if there is somehow a way to erase the watching history (take off the checkmarks) in LE.
I don't want to deactivate it, but only "clean" it for the whole system at once.

Thanks in advance!

**Klojum** · August 4, 2016 at 5:20 AM Official Post

There is no such function in Kodi. Apart from deleting the video database and rescraping your video collection, the only way to reset all watch history is by executing a SQL query in the MyVideos database with a (My)SQL database client tool.

Quote

UPDATE MyVideos99.files SET playCount IS NULL, lastPlayed IS NULL;

Depending on your database version, adjust the name of the database.

paradadf · August 4, 2016 at 9:28 AM

Sorry but I have sadly no idea how to execute a SQL query. I'm on a RPi2. Could you please be more specific?

**Klojum** · August 4, 2016 at 11:09 AM Official Post

Hmm, not really. Kodi uses SQLite database files for storing its data in the userdata/Database folder. You need a SQLite database tool to access and/or write data to that file. I know Firefox has an SQLite addon and perhaps other browsers have too.

But you will need some basic knowledge of executing a database query if you want to do all this. 'MySQL for Dummies' is actually a good read for this.

paradadf · August 4, 2016 at 11:41 AM

Thanks again... I'll try to figure it out with your tips