2014-10-04, 00:19
OK so I completely removed (purged, and manually deleted configuration files) mysql server, client, xbmc and started fresh as if I've never run any of the applications before
I ran the scripts step by step in order of the guide, which included starting with the Master Server Tutorial in step 2. After running the xbmc-server.setup.sh, this time I ran the query using HeidiSQL Portable 8.3.0.4694. This seemed to have a different effect than running the query through the terminal SQL client (mysql -uroot -p). Using terminal, there were 0 affected rows, but running the query through HeidiSQL, the result was this:
/* Affected rows: 8 Found rows: 0 Warnings: 0 Duration for 284 queries: 3.791 sec. */
Other than the different SQL client, I ran the SQL query while logged in as the xbmc/xbmc user because I couldn't log in as root with HeidiSQL.
I finished off with the xbmc-client-setup.sh script, creating three users again. I then went into XBMC and added one TV show as a new source on its own (Firefly). I added it through a SMB share as I usually do (entering the password and telling XBMC to remember the password). I refreshed and it scraped the info from TVDB...
The TV Show shows up under all of the profiles as expected, but when marking it as watched in one profile, the status is replicated over all the profiles. I suspect it's something to do with the SQL part of it, or maybe the profiles.xml? I've done this several times now but always the same result of shared watched statuses.
I have tried adding the source as a local path (instead of SMB share w/ password) and it produced the same result.
N4TH4N, do you have some input on this?
I ran the scripts step by step in order of the guide, which included starting with the Master Server Tutorial in step 2. After running the xbmc-server.setup.sh, this time I ran the query using HeidiSQL Portable 8.3.0.4694. This seemed to have a different effect than running the query through the terminal SQL client (mysql -uroot -p). Using terminal, there were 0 affected rows, but running the query through HeidiSQL, the result was this:
/* Affected rows: 8 Found rows: 0 Warnings: 0 Duration for 284 queries: 3.791 sec. */
Other than the different SQL client, I ran the SQL query while logged in as the xbmc/xbmc user because I couldn't log in as root with HeidiSQL.
I finished off with the xbmc-client-setup.sh script, creating three users again. I then went into XBMC and added one TV show as a new source on its own (Firefly). I added it through a SMB share as I usually do (entering the password and telling XBMC to remember the password). I refreshed and it scraped the info from TVDB...
The TV Show shows up under all of the profiles as expected, but when marking it as watched in one profile, the status is replicated over all the profiles. I suspect it's something to do with the SQL part of it, or maybe the profiles.xml? I've done this several times now but always the same result of shared watched statuses.
I have tried adding the source as a local path (instead of SMB share w/ password) and it produced the same result.
N4TH4N, do you have some input on this?
