Kodi Community Forum

Having a problem with the update to Frodo beta and mysql database. Can see all my media in file view but none of them are scanned in. Using the same advanced settings from my eden install. here is a snippet from my debug log with the DB errors:

Quote:12:10:51 T:9160 NOTICE: Running database version Addons15
12:10:51 T:9160 DEBUG: CDatabaseManager::Initialize, updating databases...
12:10:51 T:9160 NOTICE: Running database version ViewModes4
12:10:51 T:9160 NOTICE: Running database version Textures13
12:10:51 T:9160 NOTICE: Running database version MyMusic30
12:10:51 T:9160 NOTICE: Attempting to update the database MyVideos72 from version 60 to 72
12:10:51 T:9160 DEBUG: Mysql Start transaction
12:10:51 T:9160 DEBUG: Mysql execute: ALTER TABLE path ADD dateAdded text
12:10:51 T:9160 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE path ADD dateAdded text
12:10:51 T:9160 ERROR: Exception updating database MyVideos72 from version 60 to 72
12:10:51 T:9160 ERROR: Error updating database MyVideos72 from version 60 to 72
12:10:51 T:9160 DEBUG: Mysql rollback transaction
12:10:51 T:9160 ERROR: Unable to open database: MyVideos71 [1049](Unknown database 'myvideos71')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos70 [1049](Unknown database 'myvideos70')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos69 [1049](Unknown database 'myvideos69')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'myvideos68')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos67 [1049](Unknown database 'myvideos67')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos66 [1049](Unknown database 'myvideos66')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos65 [1049](Unknown database 'myvideos65')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos64 [1049](Unknown database 'myvideos64')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'myvideos63')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'myvideos62')
12:10:51 T:9160 ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'myvideos61')
12:10:51 T:9160 NOTICE: Old database found - updating from version 60 to 72
12:10:51 T:9160 ERROR: SQL: Can't create database for copy: 'MyVideos60' (1007)
12:10:51 T:9160 ERROR: Unable to copy old database MyVideos60 to new version MyVideos72
12:10:51 T:9160 NOTICE: Running database version TV22
12:10:51 T:9160 NOTICE: Running database version Epg7
12:10:51 T:9160 DEBUG: CDatabaseManager::Initialize, updating databases... DONE

can post full debug log if needed
hoping for a quick fix

thanks

Would you mind making a dump of the structure of your MyVideos60 database, please, I. e. mysqldump -d, and attach it.

lol shit man sorry just dumped db and rebuilt. sorry

Yeah, that was probably the thing to do anyway. I rerun an update from 60 to 72 on mysql and it worked flawlessy.
Code (1060) means duplicate column, so your db was probably corrupted.

hi, I am about to upgrade my set up (2 X win 7, 2 x OPenelec, 1 x ATV2 and 1 x Raspberry pi with openelec) is there any steps I should do in advance to ensure mysql database works post upgrade?

Be sure that the XBMC version you upgrade to on each platform is using the same version of the database, or else you are going to end up with multiple databases. Personally, I would wait until the Frodo final build is released for all of those platforms.