[thebodster]

I am having the same problem. Tried dropping the v63 and v62 databases but no joy. Log still full of page after page of

Code:

22:09:05 T:2895753920   ERROR: Error attempting to update the database version!
22:09:05 T:2895753920   DEBUG: Mysql rollback transaction
22:09:05 T:2895753920   ERROR: Can't update the database xbmc_video64 from version 61 to 64
22:09:05 T:2895753920   ERROR: Unable to open database: xbmc_video63 [1049](Unknown database 'xbmc_video63')
22:09:05 T:2895753920   ERROR: Unable to open database: xbmc_video62 [1049](Unknown database 'xbmc_video62')
22:09:05 T:2895753920  NOTICE: Old database found - updating from version 61 to 64
22:09:05 T:2895753920   ERROR: SQL: Can't create database for copy: 'xbmc_video61' (1007)
22:09:05 T:2895753920   ERROR: Unable to copy old database xbmc_video61 to new version xbmc_video64
22:09:05 T:2895753920  NOTICE: Attempting to update the database xbmc_video64 from version 61 to 64
22:09:05 T:2895753920   DEBUG: Mysql Start transaction
22:09:05 T:2895753920   DEBUG: Mysql execute: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci
22:09:05 T:2895753920   ERROR: SQL: Undefined MySQL error: Code (1050)
                                            Query: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci
22:09:05 T:2895753920   ERROR: Error attempting to update the database version!
22:09:05 T:2895753920   DEBUG: Mysql rollback transaction
22:09:05 T:2895753920   ERROR: Can't update the database xbmc_video64 from version 61 to 64
22:09:05 T:2895753920   ERROR: Unable to open database: xbmc_video63 [1049](Unknown database 'xbmc_video63')
22:09:05 T:2895753920   ERROR: Unable to open database: xbmc_video62 [1049](Unknown database 'xbmc_video62')
22:09:05 T:2895753920  NOTICE: Old database found - updating from version 61 to 64
22:09:06 T:2895753920   ERROR: SQL: Can't create database for copy: 'xbmc_video61' (1007)
22:09:06 T:2895753920   ERROR: Unable to copy old database xbmc_video61 to new version xbmc_video64
22:09:06 T:2895753920  NOTICE: Attempting to update the database xbmc_video64 from version 61 to 64
22:09:06 T:2895753920   DEBUG: Mysql Start transaction
22:09:06 T:2895753920   DEBUG: Mysql execute: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci
22:09:06 T:2895753920   ERROR: SQL: Undefined MySQL error: Code (1050)
                                            Query: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci

[/code]

[BLKMGK]

@BLKMGK: It's because your v63 database is actually v61 and/or a half updated db. You need to drop it down until a clean update can be done (eg delete you v63 db and try again, if that fails delete v62 etc.)

Are you sure? It looks liek I'm not the only one having this issue. I can drop the 63 database but I have already dropped all of the previous ones in an attempt to try and solve this as it had issues accessing all of them too. If I drop this one it will have to start from scratch and I'll lose any flags for shows I've seen. Certainly doable but since I'm not the only one having this issue I want to be sure that's the right course of action. I've renamed the 63 database for now and will delete the 64, we'll see what happens but I admit to being skeptical

[jmarshall]

If v63 doesn't update cleanly then yes, it's most likely due to having a table that it shouldn't have. The only way it gets there is from an update gone wrong pretty much. You may be able to manually update it though - check VideoDatabase.cpp::UpdateOldVersion and compare with what you have in whichever is the most up to date version.

[BLKMGK]

I will take a look and see. Dropping the database appears to have solved the issue for the moment, at least watched checkmarks appeared last night. WAY different database sizes though so I guess I'll be scanning. I keep my stuff in .NFO files using Ember so it's not a disaster. I need to get around to storing the icons and whatnot centrally too but with the SMB errors I'm getting it would probably be best I wait.

Appreciate the insight and especially the CPP file to check, was going crazy trying to find the right spot the other night.

[jmarshall]

You don't need to store (anything except music) art centrally with these changes.

[BLKMGK]

You don't need to store (anything except music) art centrally with these changes.

Wow, excellent! Can you point me somewhere to learn more about the changes? Art for my music is stored in the files themselves for the most part so hopefully no worries there. I don't think I've noticed a change in the Music database in awhile, I suppose it's a bit more straightforward than the movie one.

Appreciate the insight, love watching the new changes filter in but it can sure get rocky form time to time. Glad there's no WAF to sweat!

[grote002]

I compiled a new xbmc from git yesterday and the mysql version 61 now upgrades to 64 without problems. Also the 'freezing' after entering a tvseries-dir is fixed. Thanks