2022-03-15, 03:23
(2022-03-13, 18:22)john_es Wrote: I started here:
Create the default tables
If you have already got a Multi-User setup then start here as Kodi will fail to update the database
So I ran the scripts, got that all created. Started Kodi, and the database upgrade failed.
MYSQL: Connected to version 10.0.38-MariaDB-0+deb8u1
2022-03-13 12:08:20.016 T:5904 INFO <general>: Running database version MyMusic82
2022-03-13 12:08:20.127 T:5904 ERROR <general>: Can't update database Kodi_U01_Video_119 from version 0 - it's too old
2022-03-13 12:08:20.142 T:5904 ERROR <general>: Unable to open database: Kodi_U01_Video_118 [1049](Unknown database 'Kodi_U01_Video_118')
2022-03-13 12:08:20.157 T:5904 ERROR <general>: Unable to open database: Kodi_U01_Video_117 [1049](Unknown database 'Kodi_U01_Video_117')
2022-03-13 12:08:20.217 T:5904 INFO <general>: Old database found - updating from version 116 to 119
2022-03-13 12:08:20.317 T:5904 ERROR <general>: SQL: Can't create database for copy: 'Kodi_U01_Video_116' (1007)
2022-03-13 12:08:20.317 T:5904 ERROR <general>: Unable to copy old database Kodi_U01_Video_116 to new version Kodi_U01_Video_119
2022-03-13 12:08:20.319 T:5904 INFO <general>: Running database version TV38
2022-03-13 12:08:20.320 T:5904 INFO <general>: Running database version Epg13
The 1007 error is because the database already exists. So while this guide is good from a new start, I don't see how it possibly lets anyone upgrade from an old database to a new one. Any ideas?
@john_es inside the table Kodi_U01_Video_119.version is there a single row with the value of 119
as if you have created all the tables then it shouldn't try to upgrade, it should just start with a blank setup, as its not easy to upgrade with the changes.
I normal just start again, export your watch status to Trakt or texturecache.py there are other services/scripts too.
Reimport your data (this also will update any text and pictures too unless you have nfo files)