Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
The error you're experiencing is "table already exists", perhaps a previous migration failed and left the new database incomplete? I'd suggest dropping KodiVideo93 and attempting the migration again.
Also, if you're using path substitution of Thumbnails in order to share thumbnails between multiple clients - that's a pretty bad idea, and will cause problems (often subtle, unnoticed, until eventually artwork randomly stops being displayed).
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Posts: 6
Joined: Oct 2012
Reputation:
0
Hi Milhouse,
Thank you. However I did drop KodiVideo93 and attempted the migration again and that is the resulting log.
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
What version of MySQL? Have you used anything like Emby in the past?
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Posts: 6
Joined: Oct 2012
Reputation:
0
Hi,
Problem solved.
This is due to some manual tempering of mine. At some point in the past after a previous upgrade there was an issue with my kodi because it was looking for a "tvshow_view" table which did not exist but I had a "tvshowview" table. So I manually renamed the table and everything was fine.
So now, with the upgrade from 90 to 93 it looks like kodi copy all tables from KodiVideo90 to KodiVideo93 and then do some upgrade. tvshow_view was already existing and hence the error.
Renamed tvshow_view to tvshow_view_bk in KodiVideo90. Dropped KodiVideo93, re-perform upgrade and problem solved.