Problem upgrading video database version

You need MariaDB 10.5.2 or later.

Quote from agb

Thanks very much for the info.

My suggestion would be to open a ticket on Kodi's Github or Forum. Not sure if the Kodi developers are aware they created this implicit dependency, it seems unusual to me that they are renaming the column as I thought the way the upgrade typically worked is they created the new schema and then used insert/select statements to migrate the data from the old DB. So I don't quite know why they didn't just create the new schema with the new column name and migrate the data over with an insert/select mapping from old to new column.

I bet this won't be the last time we hear of this. I didn't run into any problems, but I checked and I am using MariaDB 10.6.

Related? https://github.com/xbmc/xbmc/pull/24505

vpeter yep, now it's just down to waiting.

Quote from agb

frakkin64  vpeter Thanks for the update.

Much better solution for me, MariaDB 10.5.2 won' install on my server [W2008R2] so I was a bit stuck.

Sounds like it's getting to the time to upgrade the OS :). I am still waffling myself on moving these things to containers on my Linux server, at least the advantage there is you can run a newer software package on an older OS/kernel, but upgrading Ubuntu has been relatively painless so fortunately it's pretty current.

Quote from agb

not fixed in https://test.libreelec.tv/12.0/RPi/RPi4/…-128f0bf.img.gz

Yeah that pull request is from Kodi, so they have to merge it first (it's still open) and then LE has to bump the Kodi package. So I imagine it will be a while, it's probably best to stay on an older LE12 nightly.