Upgraded from OE - No SQL?

DoubleT · April 8, 2016 at 7:59 PM

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.

**aptalca** · April 8, 2016 at 11:48 PM

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

DoubleT · April 8, 2016 at 11:57 PM

Quote from aptalca

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!

riothamus · April 12, 2016 at 4:27 PM

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:

Code

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 Epg11

Display More

My 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.