How to erase watching history?

1st Official Post

    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!

    • 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.

    • 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.