2019-01-12, 14:07
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:
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?
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?