v18 -  Updating from RC4 or RC5 changes database schema and fails to update
#1
I just built RC5 and replaced RC4 with it on a setup using a shared video database.  Upon starting, it wants to change the database schema and fails to do so.  The result is a broken shared database.

Excerpt from log:
Code:
...
07:03:19.455 T:139788829062912   ERROR: SQL: [MyVideos115] Undefined MySQL error: Code (1349)
                                            Query: CREATE VIEW tvshow_view AS SELECT   tvshow.*,  path.idParentPath AS idParentPath,  path.strPath AS strPath,  tvshowcounts.dateAdded AS dateAdded,  lastPlayed, totalCount, watchedcount, totalSeasons,   rating.rating AS rating,   rating.votes AS votes,   rating.rating_type AS rating_type,   uniqueid.value AS uniqueid_value,   uniqueid.type AS uniqueid_type FROM tvshow  LEFT JOIN (SELECT idShow, MAX(idPath) as idPath                FROM tvshowlinkpath               GROUP BY tvshowlinkpath.idShow) AS tvshowlinkpath ON     tvshowlinkpath.idShow=tvshow.idShow  LEFT JOIN path ON    path.idPath=tvshowlinkpath.idPath  INNER JOIN tvshowcounts ON    tvshow.idShow = tvshowcounts.idShow   LEFT JOIN rating ON    rating.rating_id=tvshow.c04   LEFT JOIN uniqueid ON    uniqueid.uniqueid_id=tvshow.c12
07:03:19.456 T:139788829062912   ERROR: Exception updating database MyVideos115 from version 113 to 115
07:03:19.456 T:139788829062912   ERROR: Error updating database MyVideos115 from version 113 to 115
07:03:19.456 T:139788829062912   DEBUG: Mysql rollback transaction
07:03:19.457 T:139788829062912   ERROR: Unable to open database: MyVideos114 [1049](Unknown database 'MyVideos114')
07:03:19.459 T:139788829062912  NOTICE: Old database found - updating from version 113 to 115
07:03:19.460 T:139788829062912   ERROR: SQL: Can't create database for copy: 'MyVideos113' (1007)
07:03:19.460 T:139788829062912   ERROR: Unable to copy old database MyVideos113 to new version MyVideos115
...

Link to entire debug log.

1) Is the schema change from RC4-->RC5 expected?
2) In the past schema updates have just worked. Is there something special I need to do with RC5 or is this a bug?
Need help programming a Streamzap remote?
Reply
#2
339268 (thread)
My Signature
Links to : Forum rules (wiki) | Banned_Add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create_Music_Library (wiki) | HOW-TO:Create_Video_Library (wiki) || Artwork (wiki) | Basic_controls (wiki) | Import-export_library (wiki) | Movie_sets (wiki) | NFO_files (wiki) | Quick start guide (wiki)
Reply
#3
(2019-01-12, 14:10)Karellen Wrote: 339268 (thread)
 Thanks for the link.  I never would have thought to look in the windows subsection.  I will flag my post requesting a deletion to minimize noise.
Need help programming a Streamzap remote?
Reply
#4
NP. Lets leave it active for now. I am sure there will be others wondering what is going on. Seems the fix is not quite there yet as there are still issues.
My Signature
Links to : Forum rules (wiki) | Banned_Add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create_Music_Library (wiki) | HOW-TO:Create_Video_Library (wiki) || Artwork (wiki) | Basic_controls (wiki) | Import-export_library (wiki) | Movie_sets (wiki) | NFO_files (wiki) | Quick start guide (wiki)
Reply
#5
same issue for me on Android TV with shared library  on OMV (MariaDB 10.1).
thanks to the the link I see that it should be fixed soon... 
I just stoped upgrading my other Kodi and let them in RC4 witing for the fix (database is still OK on RC4 systems)
Reply
#6
It's already fixed. I just pushed it some minutes ago. Will be in tomorrow's nightly
First decide what functions / features you expect from a system. Then decide for the hardware. Don't waste your money on crap.
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
Updating from RC4 or RC5 changes database schema and fails to update00