2023-03-09, 11:33
(2023-03-09, 04:22)HeresJohnny Wrote: I've tested it on a portable installation of Nexus and a nightly of Omega. On Nexus it connects to the databases and returns counts of objects, on Omega I get error messages of "Database not found". Also, the add-on installs to plugin.program.kcsleaner which I'm guessing should be plugin.program.kscleaner :-)
Thanks for confirming it works on Nexus and catching my typo in the addon name. I have fixed it for the next test release. I haven't added support for Omega yet. I haven't setup a test environment for it and the database numbers aren't posted yet on the Kodi Wiki. If you can tell me the database names for the video and music databases (i.e. myvideos122 and mymusic83 etc..) I can add support for Omega. I've made more progress and have the movies and TV Shows browser working with MySQL, as well as the CSV export utility. The analyzer module is going to take some time due to the sheer number of SQL queries involved and I don't plan to make the database backup work with MySQL. If someone is running MySQL, they will need to have enough DBA skills to handle their own backups. I'll likely posted an update early next week which should have feature parity between SQLite and MySQL for everything except the analyzer module and database backups.
I am already seeing something interesting where the Kodi scrapers are adding a season -1 and 0 to all TV Shows. I am not sure why this is but am sure there is a purpose. When I sync Kodi data from Mezzmo I don't add these seasons to the Kodi database (except when there is an episode with a season 0). I'll need to account for this in the TV Show portion of the analyzer because it will toss out a mismatch where there is a season entry in the seasons table with no associated episodes. This will likely be a Team Kodi question as to the purpose of seasons -1 and 0..
Thanks,
Jeff