Kodi Community Forum

Hi Everyone,

I attempted to try out one of the ver 16 BETA some time ago and had the same issue, I was hoping that now Jarvis is in RC I would have more luck. I installed 16RC1 over top of my 15.2 install, but it seems to be having trouble with the mysql database I have running off of a VM. Details from the log:


"
17:35:43 T:7808 NOTICE: Running database version Addons20
17:35:43 T:7808 NOTICE: Running database version ViewModes6
17:35:43 T:7808 NOTICE: Running database version Textures13
17:35:43 T:7808 NOTICE: Running database version MyMusic56
17:35:43 T:7808 NOTICE: Attempting to update the database MyVideos99 from version 93 to 99
17:35:43 T:7808 ERROR: SQL: [MyVideos99] Undefined MySQL error: Code (1060)
Query: ALTER TABLE movie ADD userrating integer
17:35:43 T:7808 ERROR: Exception updating database MyVideos99 from version 93 to 99
17:35:43 T:7808 ERROR: Error updating database MyVideos99 from version 93 to 99
17:35:43 T:7808 ERROR: Unable to open database: MyVideos98 [1049](Unknown database 'MyVideos98')
17:35:43 T:7808 ERROR: Unable to open database: MyVideos97 [1049](Unknown database 'MyVideos97')
17:35:44 T:7808 ERROR: Unable to open database: MyVideos96 [1049](Unknown database 'MyVideos96')
17:35:44 T:7808 ERROR: Unable to open database: MyVideos95 [1049](Unknown database 'MyVideos95')
17:35:44 T:7808 ERROR: Unable to open database: MyVideos94 [1049](Unknown database 'MyVideos94')
17:35:44 T:7808 NOTICE: Old database found - updating from version 93 to 99
17:35:44 T:7808 ERROR: SQL: Can't create database for copy: 'MyVideos93' (1007)
17:35:44 T:7808 ERROR: Unable to copy old database MyVideos93 to new version MyVideos99
"


As far as I can tell my permissions are correct within mysql. Any ideas?

-T.J.

Drop "MyVideos99" in MySQL, then start Jarvis again.
Just wait until the database is upgraded (you won't get any GUI so may look like it has crashed).

Great, worked a charm! Thanks for the prompt and helpful response. If any mods catch this you may flag as resolved.

It seems my "issue" in this case was a lack of patience. In case it helps anyone else: you may need to wait 10 or more minutes on first launch. Both my PC and server are quite beefy and I waited a lot longer than expected.

All the best,

T.J.

Thread marked solved.

Glad it worked.

(2016-01-22, 01:42)tjs4ever Wrote: [ -> ]It seems my "issue" in this case was a lack of patience.

We're very aware of this problem, at some point some "please wait while database is upgraded" dialog/splash will be implemented.

I ran into this on Beta, RC, and now Final... I wasted a few hours and just got "lucky" I just found this thread after many searches.

(2016-01-23, 06:08)menakite Wrote: [ -> ]We're very aware of this problem, at some point some "please wait while database is upgraded" dialog/splash will be implemented.

"at some point" should have been in Beta 1, or RC at the very latest... This is a pretty serious bug IMO... it can cause a ton of problems and really needs to be fixed asap to avoid others wasting a ton of time - at minimum there should be a huge, bold all caps warning to MySQL users when upgrading starts

It's not a bug. Maybe an incomplete feature, but MySQL in Kodi is basically that, an incomplete feature. Thats why it needs an advanced settings xml file to even be used. Something like that doesn't always have a high priority.

For someone who isn't savvy with SQL but is using the mysql feature to sync libraries, what do you mean drop MyVideos99 in MySQL? Can you spell that out for me? Thanks.

(2016-04-28, 22:52)ozpapa Wrote: [ -> ]For someone who isn't savvy with SQL but is using the mysql feature to sync libraries, what do you mean drop MyVideos99 in MySQL? Can you spell that out for me? Thanks.

#. Log into mysql command line and type (note semi colons)
show databases;

#it will show you something like this

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| MyVideos99 |
+--------------------+
1 rows in set (0.00 sec)

# you would type
drop database MyVideos99;