+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: SQL Database, all useres share the same "viewed" data (/showthread.php?tid=367072)
SQL Database, all useres share the same "viewed" data - huibu - 2022-02-16
Hey there,
I'm trying to setup a SQL server for the video Database. I basically followed this guide:
https://kodi.wiki/view/MySQL/Setting_up_MySQL#tab=Windows
For the first user it works just fine, but then I added a second user to the SQL databse.
If I connect from a second device with the new user, Kodi shows all the movies and episodes as watched, which were watched by the first user.
I thought one could have multiple users that have independent "watched" entries.
Was I wrong considering this, or did I do something wrong?
Kind reagrds,
Tobi
RE: SQL Database, all useres share the same "viewed" data - Klojum - 2022-02-16
(2022-02-16, 16:25)huibu Wrote: If I connect from a second device with the new user, Kodi shows all the movies and episodes as watched, which were watched by the first user.
Well, isn't that the purpose of a shared database? If a video is watched on one Kodi client, it is also shown as watched on the other client(s) ?
RE: SQL Database, all useres share the same "viewed" data - huibu - 2022-02-16
Basically yes. But we have different users with different devices.
So my thought was, that user A has his watched state on all his devices, and user B has his watched state on all his devices.
RE: SQL Database, all useres share the same "viewed" data - ponkotsu - 2022-02-16
Assuming you're using v19 Matrix, this might be relevant to your interests.
If you're using v18 Leia (or a previous release), there's other info in that same thread.
RE: SQL Database, all useres share the same "viewed" data - huibu - 2022-02-17
that looks very promising! Thank you very much!