Recently my pi’s all updated to the latest and greatest and my media libraries seem to be missing lots of media items. TV Shows Movies. Watched status is gone. Entire seasons missing from the library etc.
I have used a shared mysql library for the best part f 10 years.
Is there a way of getting my database/library back. Watching items on the new version does not update watched state.
Did your mysql user had the respective rights to create a new database? Did you verified that the new databases have been created correctly?
As you use a mysql setup I assume you have multiple systems running Kodi. Did you ensure just to update one device first to trigger database migration?
As for the missing items in your database you could try deleting the database that v18 built and the next time you open Kodi it will rebuild from your v17 info again. It is possible that there were errors during the initial conversion.
Many thanks to all who replied. I powered off all pi’s dropped the new (corrupted DB) and restarted one Pi. It migrated the last DB fine. I waited until fully finished then ran a Library update to add in the items that had been added since the update.