[Phil.M]

Hi All, really needs some help.

I have recently encountered an issue that has stopped me from being able to access TV Shows, my set up is:

Kodi (19.3 (19.3.0) Git:20211024-49a04cd6a7) - Running on various Kodi devices with a central SQL (5.5.68-MariaDB)
database running on my NAS.

On any device, when I select a TV Show to browse seasons/episodes the interface hangs for a while then nothing appears.
It's doing this for any TV Show I select. Looking into the log with some debug turned on I see the following errors:

Code:

CVideoDatabase::RunQuery took 29 ms for 79 items query: select * from episode_view WHERE (episode_view.idShow = 1993) AND (((episode_view.playCount IS NULL OR episode_view.playCount < 1)))
2022-01-14 06:37:08.683 T:31296 DEBUG <general>: DatabaseUtils::GetSortFieldList: unknown field 36

I found the following forum https://forum.kodi.tv/showthread.php?tid=362150 post on a similar issue, but I don't think it
was affecting that user in the same it's impacting me

I've tried trashing the whole database on the NAS and rebuilding from scratch in Kodi, but get the same issue (on any of my devices).

Did try a little experiment of only re-scanning a small portion of my TV Show library and it did work, but after scanning the rest
it stopped working again, tried to work out which show(s) may be the root cause (something in the NFO), but have so many
that its difficult to do. - Note I do use TinyMM to scrape before moving shows to my Kodi library.

I'm at a loss and if I cannot figure/fix this may have to look at switching to Plex or something similar, which I don't want to do.

Link to full Kodi log here: esovofezem.kodi (paste)

Thanks, appreciate any help in fixing this.
P.

[Karellen]

@Phil.M

Line 2834 in your log is the clue.

Solution in the first post here... https://forum.kodi.tv/showthread.php?tid=357217

Let us know if that fixes it.

[Phil.M]

Many thanks for your help @Karellen,

As it turns out it wasn't just the sort buffer size, I also had insufficient space on the NAS for temporary SQL files.
But your prompt response and pointer abled me to track it down :-)

Phil.M