Hi guys,
first off massive thanks for this new fork!
I will be getting involved however i can later in the year when my day job has calmed a little.
For now - ive upgraded one rPI2 and all went smooth except its having issues talking ot my MariaDB back end on a Synology NAS
Logs:
pyki635za
Any ideas?
[hr]
Can't explain it but all seems to be working.
Kodi crashed and when it came back up, library had returned.
Odd.
I upgraded from oe to le as well, had the same issue. Just go into the le settings addon and tick the box wait for network.
The problem is, that option is off by default and kodi may start before the network is up and can't reach the mysql server
I upgraded from oe to le as well, had the same issue. Just go into the le settings addon and tick the box wait for network.The problem is, that option is off by default and kodi may start before the network is up and can't reach the mysql server
Yes found that one as after another restart it failed agai. Think I've restored most of my config now and all is well.
Cheers!
Just did a manual update from OE to LE, with the same problem. However, I have also set my "wait for network" option, rebooted and I still don't have access to the database.
Upon further troubleshooting, I find this in the log:
11:23:36 T:140417216354432 NOTICE: Running database version Addons20
11:23:36 T:140417216354432 NOTICE: Running database version ViewModes6
11:23:36 T:140417216354432 NOTICE: Running database version Textures13
11:23:36 T:140417216354432 NOTICE: Running database version MyMusic56
11:23:36 T:140417216354432 NOTICE: Attempting to update the database MyVideos99 from version 93 to 99
11:23:36 T:140417216354432 ERROR: SQL: [MyVideos99] Undefined MySQL error: Code (1060)
Query: ALTER TABLE movie ADD userrating integer
11:23:36 T:140417216354432 ERROR: Exception updating database MyVideos99 from version 93 to 99
11:23:36 T:140417216354432 ERROR: Error updating database MyVideos99 from version 93 to 99
11:23:36 T:140417216354432 ERROR: Unable to open database: MyVideos98 [1049](Unknown database 'MyVideos98')
11:23:36 T:140417216354432 ERROR: Unable to open database: MyVideos97 [1049](Unknown database 'MyVideos97')
11:23:36 T:140417216354432 ERROR: Unable to open database: MyVideos96 [1049](Unknown database 'MyVideos96')
11:23:36 T:140417216354432 ERROR: Unable to open database: MyVideos95 [1049](Unknown database 'MyVideos95')
11:23:36 T:140417216354432 ERROR: Unable to open database: MyVideos94 [1049](Unknown database 'MyVideos94')
11:23:36 T:140417216354432 NOTICE: Old database found - updating from version 93 to 99
11:23:36 T:140417216354432 ERROR: SQL: Can't create database for copy: 'MyVideos93' (1007)
11:23:36 T:140417216354432 ERROR: Unable to copy old database MyVideos93 to new version MyVideos99
11:23:36 T:140417216354432 NOTICE: Running database version TV29
11:23:36 T:140417216354432 NOTICE: Running database version Epg11My database is MariaDB on CentOS 7.
Anything I could do to fix this?
[hr]
Found the fix: kodi forum thread
I dropped the MyVideos99 database, then restarted my LE system (with all of my other ones shut off). The process took about 45 minutes, but it worked after it completed.