[bmac88]

@BigMong Thank you. It's working now

@all

New Setup:

create a file called advancedsettings.xml in .kodi/userdata/ and insert following content:

Code:

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.2.2</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>a</name>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.2.2</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    <name>a</name>
  </musicdatabase>
</advancedsettings>

-Replace user, pass and host whit your mysql settings.
-Restart kodi
-Kodi creates a new database called a90
-Use your favorite mysql editor and insert the code from link http://pastebin.com/0VNB9DmV
-Execute for each database the code provided from BigMong (first fix not needed)
-Done

Existing setup:
-Make a database backup for each profile(single file) in System->Video->Library->Export Library (You may need to change settings level to expert)
-Rename the database a78 to something like aa78 (because kodi will attempt to upgrade the a78 to a90 and that will fail)
-Update to kodi
-Follow instructions new setup
-For each profile import the backup (System->Video->Library->Import Library)
-Done

To change from a profile to b profile change
<name>a</name> to <name>b</name> in advancedsettings.xml

Enjoy

-I am going to attempt an upgrade from 13.2 to 14.2. So far I have backed up my libraries (I have 3 profiles: a b and c, originally set up using N4TH4N's 5 user script).
- I see that your script creates the 5 databases (Kodi compatible) as N4TH4N's 13.2 script did.

-I am unclear on which code exactly that I'm supposed to execute from BigMong. I assume just the one starting with CREATE VIEW `b90`.`tvshowview`?
You say to execute this code for each database, but it seems to be tailored for the b database. I assume I just change all instances of b90 to c90 and then execute it again in HeidiSQL? If that's the case I'd probably just carry on and do it with d90 and e90 as well.

Also, you say his two scripts following are not necessary? I'm wondering how many profiles you have being used and if you are getting any errors?

After the new SQL databases have been created and the fix applied to each, the importing of each library while logged on under each corresponding profile makes sense. I get that part.

The very last part of your post about changing profiles by changing a to b in advancedsettings.xml: is this because you aren't using a profiles.xml and separate advancedsettings.xml for each user?

I'd really appreciate if you'd clarify these few questions