2015-10-29, 07:35
Just a heads up for anyone using mariadb 10.1.8, there seems to be an issue with the way totalCount is calculated in the tvshowcounts table of the mysql database. For some reason, when using 10.1.8, the count is always doubled-1. So if you have 50 episodes of a show, the totalCount will erroneously be 99 (50*2 -1).
This only happens with mariadb 10.1.8. Downgrading to 10.0.21 solves the problem. Not sure if this should be reported as a kodi bug or mariadb bug, but I'll be sticking to 10.0.21 until it's ironed out. Unfortunately, arch doesn't have 10.0.22 in their repositories since that version fixes the crash from 10.0.21 when playing songs with Kodi through a mysql database.
This only happens with mariadb 10.1.8. Downgrading to 10.0.21 solves the problem. Not sure if this should be reported as a kodi bug or mariadb bug, but I'll be sticking to 10.0.21 until it's ironed out. Unfortunately, arch doesn't have 10.0.22 in their repositories since that version fixes the crash from 10.0.21 when playing songs with Kodi through a mysql database.