Thanks for the replies. The problem started when I "fixed" an error that I noticed in the advancedsettings file. Everything was fine so I should have left it alone. I had a generic one in the userdata folder that was:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.***.*</host>
<port>3306</port>
<user>****</user>
<pass>****</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.***.*/host>
<port>3306</port>
<user>****</user>
<pass>****</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
I also had one in the Nick profile that was:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.***.*</host>
<port>3306</port>
<user>****</user>
<pass>****</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.***.*/host>
<port>3306</port>
<user>****</user>
<pass>****</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
And finally, one in the Tara profile folder tat was:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.***.*</host>
<port>3306</port>
<user>****</user>
<pass>****</pass>
<name>tara</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.***.*/host>
<port>3306</port>
<user>****</user>
<pass>****</pass>
<name>tara</name>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
I had messed around with the name tag and realized that I had left it in the Tara profile one the other day so I removed that line so they all looked the same. Then, last night, I looked at the shows under her profile and now her's mimic mine. As I mentioned, her shows are still correct for her table in the db but it's just not pulling them after removing that line. My db has the following tables:
myvideos107
mymusic60
tara107
tara60
It got me thinking, how does kodi know to use the tara107 for her profile? Does it look for a table name that contains the profile name in it? That's all I can think of. I tried adding the <name> tag back but figured I would need to put the exact table name so I put <name>tara107</name> but that didn't work. I don't see any mention in the wiki about putting a separate advancedsettings file in each profile folder so I tried deleting both of them and just leaving the one advancedsettings file in the userdata folder but got the same results. Both profile have my shows in them. I've been told on other posts that the Name tag is not supported anymore but it's still in the wiki guide:
Quote:6 Name tag
An additional
<name>
tag can be used for both the
<videodatabase>
and
<musicdatabase>
entries in advancedsettings.xml file, if you want to change the name of the database. The
<name>
tag is not required. Kodi will use "MyVideos" and "MyMusic" as database names if the
<name>
tag is not specified.
You may want to do this if you want to have multiple separate libraries (with different content) on the same MySQL server. For example, if you want to create multiple profiles, each with their own shared library, so that each Kodi device can "log-into" that library. (a kids library, a guest library, etc)
Note: Don't try to merge the video and music databases! You need to use different values in the
<name>
tag or you'll end up confusing Kodi leading to the library functionality not working at all. In other words, don't use
<name>Kids</name>
for both music and videos, but instead use something like
<name>Kids-music</name>
and
<name>Kids-video</name>
So I figured that it might be. What am I missing here? Thanks.