The db (Maria 10.3.38): is running on a remote server.
On my log this part looks strange:
2023-06-06 20:54:16.945 T:3454 info <general>: MYSQL: Connected to version 10.3.38-MariaDB-0ubuntu0.20.04.1-log
2023-06-06 20:54:16.954 T:3454 info <general>: Attempting to update the database MyVideos121 from version 119 to 121
2023-06-06 20:54:16.965 T:3454 error <general>: SQL: [MyVideos121] Undefined MySQL error: Code (1060)
Query: ALTER TABLE streamdetails ADD strHdrType text
2023-06-06 20:54:16.965 T:3454 error <general>: Exception updating database MyVideos121 from version 119 to 121
2023-06-06 20:54:16.965 T:3454 error <general>: Error updating database MyVideos121 from version 119 to 121
2023-06-06 20:54:16.973 T:3454 error <general>: Unable to open database: MyVideos120 [1049](Unknown database 'MyVideos120')
2023-06-06 20:54:16.982 T:3454 info <general>: Old database found - updating from version 119 to 121
2023-06-06 20:54:16.985 T:3454 error <general>: SQL: Can't create database for copy: 'MyVideos119' (1007)
2023-06-06 20:54:16.985 T:3454 error <general>: Unable to copy old database MyVideos119 to new version MyVideos121
I have the same problem and posted to this location. Perhaps merging the two might help, but I also have an issue with playing a file directly from the video tab (files) as it gives a frown face.
I’m running 10.4.17 on a Win10 PC and didn’t run into the issue during testing on the two machines with the db they were using, nor did I have an issue with the upgrade of a different db that happened with the final release installed on other boxes, so whatever the issue it isn’t universal, and I suspect it it’s server side. Unfortunately, when it comes to the topic of databases I’m very much a noob so I can’t offer much. I did raise the issue with the dev team though.
If you drop the 121 database (if it created it at all) and have Kodi installed on a PC do the db update does it fail there as well?
When you delete 121 it not being there tells Kodi to upgrade from the previously found version (119). This is failing so Kodi just loads up the local (empty) SQLite db instead. What I was asking was if instead of having Kodi running on OSMC to do this update, you instead configure a PC running Kodi with the same advancedsettings.xml so it will do the database update. In this way it would help isolate where the issue is coming from, ie if Kodi on Windows fails the same way then it is probably something to do with the server configuration. You don’t actually need to fully setup all your sources, passwords, etc. on the Win Kodi to do the update as none of them are involved in the process.
Unfortunately the log just shows you telling the file to play and then the log stops so there isn’t any information to go off of. Is that drive your playing it from self powered? If you put the file on a thumb drive does it play from that without crashing?
The drives are self-powered (plugged into a hub). These files played properly prior to the update. Because of this, I thought that this issue had to do with the update since it happened at the same time as the other issue of not being able to access movies/tv shows the regular way (library on the home page). Are you asking me to copy a file to a usb drive and then plug the usb drive directly into the Pi4?
When there exist a possible power delivery issue a quick and dirty is to try playing the same file from something that uses very little power. It’s a bit of a stab in the dark kind of thing lacking a more solid footing for a proper diagnostic.
Hi, I’m sorry but I don’t have windows machine to do this.
If the db setup in advancedsettings.xml is a mysql (or Maria), if you deleted the new version (121) on the next reboot kodi will trig the migration process from the last version (119) to the current one (121).
So, I just create a fresh new database server (this time mysql 8, instead Maria 10.3.38), restored the 119 db* and restarted kodi… all movie/tv show are back!
Kodi developers maybe no longer support too old versions of Maria/mysql? Versions 10.3 or 5.7 are old…
*) I just have a little problem with this error on restore: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
fixed with: sed -i 's/,NO_AUTO_CREATE_USER//g' path/119_db_dump.sql
After another try to access do MariaDB Server Kodi 20.1 a scratched all data
Every time there are a new Kodi major release we have to reinstall all from the scratch (DB, network path, profile, configuration, Audio setup). Everytime a fresh install. I am very disappointed (refered to KODI not OSMC)
Having the same issue Sam. User can create and access databases, it looks like there is something weird going on. Here is a snippet of the logs in question. Updated the mariadb that I’m running in a docker container, and checked the perms of the user kodi is using (it has full access). When I look at the database in dbeaver, you’ll notice that MyVideos119 and MyVideos121 both exist. Even running a quick select all, is showing that the database does have data in it. But when restarting both Vero devices, I still see nothing in Movies or TV. Halp.
2023-06-06 16:02:01.569 T:2959 info <general>: MYSQL: Connected to version 10.11.3-MariaDB-log
2023-06-06 16:02:01.590 T:2959 info <general>: Running database version MyMusic82
2023-06-06 16:02:01.590 T:2959 debug <general>: connect replacing configured host 192.168.1.254 with resolved host 192.168.1.254
2023-06-06 16:02:01.610 T:2959 info <general>: Attempting to update the database MyVideos121 from version 119 to 121
2023-06-06 16:02:01.611 T:2959 debug <general>: Mysql Start transaction
2023-06-06 16:02:01.630 T:2959 error <general>: SQL: Can't determine list of routines to drop.
2023-06-06 16:02:01.630 T:2959 error <general>: Exception droping old analytics from MyVideos121
2023-06-06 16:02:01.632 T:2959 debug <general>: Mysql rollback transaction
2023-06-06 16:02:01.632 T:2959 debug <general>: connect replacing configured host 192.168.1.254 with resolved host 192.168.1.254
2023-06-06 16:02:01.643 T:2959 error <general>: Unable to open database: MyVideos120 [1049](Unknown database 'MyVideos120')
2023-06-06 16:02:01.643 T:2959 debug <general>: connect replacing configured host 192.168.1.254 with resolved host 192.168.1.254
2023-06-06 16:02:01.661 T:2959 info <general>: Old database found - updating from version 119 to 121
2023-06-06 16:02:01.697 T:2959 error <general>: SQL: Can't create database for copy: 'MyVideos119' (1007)
2023-06-06 16:02:01.697 T:2959 error <general>: Unable to copy old database MyVideos119 to new version MyVideos121
Edit: I can provide the full logs if they are needed.
Edit2: Running Maria DB 10.11.3. Dropped the MyVideos121 database. Restarted Vero device, it shows that a database migration is in progress. “Finishes” and then shows me an empty Movies and TV section.