[beeswax]

I just tried to update to latest nightly (KodiSetup-20240120-98685178-master-x64.exe on Windows or kodi-20240120-98685178-master-arm64-v8a.apk on Android) but both are failing to update the MySQL db and leaving me with a corrupt database with no media.  I started working my way back through nightlies, dropping the myvideos129 db after each attempt, but after getting back to Jan 7th and still having the same problem, I've given up and rolled back to Beta2.  Can someone take a look at the db upgrade script?

php:
2024-01-21 20:13:50.427 T:15484    info <general>: Attempting to update the database MyVideos129 from version 124 to 129

2024-01-21 20:13:50.427 T:15484   debug <general>: Mysql Start transaction

2024-01-21 20:13:50.850 T:15484   debug <general>: Mysql commit transaction

2024-01-21 20:13:50.854 T:15484   debug <general>: Mysql Start transaction

2024-01-21 20:13:50.854 T:15484   debug <general>: Mysql execute: ALTER TABLE videoversiontype ADD itemType INTEGER

2024-01-21 20:13:50.926 T:15484   debug <general>: Mysql execute: UPDATE videoversiontype SET itemType = 0

2024-01-21 20:13:50.931 T:15484   debug <general>: Mysql execute: ALTER TABLE videoversion RENAME COLUMN mediaType TO media_type

2024-01-21 20:13:50.931 T:15484   error <general>: SQL: [MyVideos129] Undefined MySQL error: Code (1064)

                                                   Query: ALTER TABLE videoversion RENAME COLUMN mediaType TO media_type

                                                   

2024-01-21 20:13:50.931 T:15484   error <general>: Exception updating database MyVideos129 from version 124 to 129

2024-01-21 20:13:50.931 T:15484   error <general>: Error updating database MyVideos129 from version 124 to 129

Here's a full debug log from the 7th Jan version, currently nightly does exactly the same.

edit: if it helps at all, I can see from MySQL that my recent sql db version history is 121 -> 122 -> 124 and now I'm stuck.

[CrystalP]

A fix went in today, the next nightly will complete the database upgrade successfully.

[beeswax]

Nice! That sounds like it was already a known problem before I reported it. Classic me picking the day before a complete db break gets fixed to update!