HOW-TO:Share libraries using MySQL: Wiki Edition
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.
Reply


Messages In This Thread
RE: HOW-TO:Share libraries using MySQL: Wiki Edition - by misterhek - 2015-10-29, 07:35
Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2