[killbilly]

Thank you, this post fixed my problem. My symptoms were similar: Kodi appeared to scrap the data correctly, but when I tried to enter a lsting of seasons of any of my TVshow, kodi would try to query the database and error out. However, I could play the show by selecting the episode from the main TV Episodes screen in the skin or select it from the Videos menu. However, selecting the TV Episodes heading would show the list of TV series, but would not allow me to dig any deeper. Searching the errors I saw in the log led me to the post. I discovered my db user did not have grant permissions. After enabling that and rebuilding the database, it works fine. I had recentlly recreated the db user and missed that permission this time. I dont think it is relevant, but My Buffalo LinkStation Duo NAS has mySQL 5.0.70 and also will not let me upgrade.