[a_user]

Hello,
since a couple of days the current git version of XBMC seems to be broken regarding the MyVideo database. I see the following error in the logs:

13:16:50 T:140381907089280 DEBUG: Mysql execute: UPDATE path SET idParentPath=19 WHERE idPath=827
13:16:50 T:140381907089280 DEBUG: Mysql execute: UPDATE path SET idParentPath=19 WHERE idPath=980
13:16:50 T:140381907089280 DEBUG: Mysql execute: UPDATE tvshow SET c16=NULL,c17=NULL
13:16:50 T:140381907089280 DEBUG: Mysql execute: DELETE FROM seasons WHERE idSeason NOT IN (SELECT min(idSeason) FROM seasons GROUP BY idShow,season)
13:16:50 T:140381907089280 ERROR: SQL: Undefined MySQL error: Code (1093)
Query: DELETE FROM seasons WHERE idSeason NOT IN (SELECT min(idSeason) FROM seasons GROUP BY idShow,season)
13:16:50 T:140381907089280 ERROR: Exception updating database MyVideos85 from version 79 to 85
13:16:50 T:140381907089280 ERROR: Error updating database MyVideos85 from version 79 to 85
13:16:50 T:140381907089280 DEBUG: Mysql rollback transaction

Seems to be a broken sql query.

[popcornmix]

Try this: https://github.com/xbmc/xbmc/pull/4985

[a_user]

what exactly? the links seems related to my observed issue but i didn't found a patch or solution for this problem. or did i missed something?

anyhow, good to know that it's already being worked on.

[un1versal]

popcornmix probably meant, compile xbmc with that patch and try see if that fixes the issue you describe.

[a_user]

well, that did the trick. But i see that i have another problem with the music database.

00:35:55 T:139637753341824 ERROR: Unable to open database: MyMusic48 [1049](Unknown database 'MyMusic48')
00:35:55 T:139637753341824 ERROR: Unable to open database: MyMusic47 [1049](Unknown database 'MyMusic47')
00:35:55 T:139637753341824 NOTICE: Old database found - updating from version 46 to 48
00:35:56 T:139637753341824 NOTICE: Attempting to update the database MyMusic48 from version 37 to 48
00:35:56 T:139637753341824 DEBUG: Mysql Start transaction
00:35:56 T:139637753341824 DEBUG: Mysql execute: CREATE TABLE album_new (idAlbum integer primary key auto_increment , strAlbum varchar(256), strMusicBrainzAlbumID text, strArtists text, strGenres text, iYear integer, idThumb integer, bCompilation integer not null default '0', strMoods text, strStyles text, strThemes text, strReview text, strImage text, strLabel text, strType text, iRating integer, lastScraped varchar(20) default NULL, dateAdded varchar (20) default NULL) CHARACTER SET utf8 COLLATE utf8_general_ci
00:35:56 T:139637753341824 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE album_new (idAlbum integer primary key auto_increment , strAlbum varchar(256), strMusicBrainzAlbumID text, strArtists text, strGenres text, iYear integer, idThumb integer, bCompilation integer not null default '0', strMoods text, strStyles text, strThemes text, strReview text, strImage text, strLabel text, strType text, iRating integer, lastScraped varchar(20) default NULL, dateAdded varchar (20) default NULL) CHARACTER SET utf8 COLLATE utf8_general_ci
00:35:56 T:139637753341824 ERROR: Exception updating database MyMusic48 from version 37 to 48
00:35:56 T:139637753341824 ERROR: Error updating database MyMusic48 from version 37 to 48
00:35:56 T:139637753341824 DEBUG: Mysql rollback transaction

i already dropped the database MyMusic48 after the previous failed attemt.