[7h3ju57]

So Just upgraded to Kodi 16 and seems that mysql is a bit broken.

So here is the scenario. I'll add a tvshow to the library and that works just fine. got to newly added show, open context menu and click on mark as watched. go to "left menu" and click on hide watched, still says that some episode are unwatched but if you enter the directory its empty.

http://pastebin.com/sijfw5fZ

theres the debug log of when i set the watched status for one show.

let me know if more info is needed or any one else is experiencing this issue.

Server is Jessie Debian 4.3.5-1 (2016-02-06) x86_64
mysql Ver 15.1 Distrib 10.1.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

I've been reading how mariadb might be broken for kodi can anyone confirm?

[Milhouse]

MariaDB isn't broken for Kodi, however some versions of MariaDB are just broken full stop.

[fritsch]

MariaDB is broken ... see their bugtracker, full of toothing problems. If you want a DB for data integrity - just don't use it ...

[7h3ju57]

your absolutely right, after fighting with mysql 5.6 to get it to install (probably something mariadb leftover) it now works great.

Hack for those interested:

http://forum.kodi.tv/showthread.php?tid=262029