(2018-05-25, 07:02)Yanta Wrote: So I want to maintain separate watched status for all TV Shows and movies in a MySQL environment.

(2018-05-26, 14:02)Gade Wrote: Regarding your watched movies disappearing from the home screen recently movies list:

Go to skin.rapier/extras/playlists/HomeRecentMoviesUnwatched.xsp
Remove line 5 + 6 + 7
Save the file

Note that you need to do this each time the skin is updated, as all content of the skin folder is overwritten.
And I always encourage everyone to keep the skin updated at all times.

(2018-05-27, 07:17)Yanta Wrote: No PC is used by more than one person. Each person has their own PC accessing a central Kodi Server where MYSQL is installed.

xml:
<advancedsettings>

  <videodatabase>

    <type>mysql</type>

    <host>***.***.***.***</host>

    <port>3306</port>

    <name>livingroomvideo</name>

    <user>kodi</user>

    <pass>kodi</pass>

  </videodatabase> 

  <musicdatabase>

    <type>mysql</type>

    <host>***.***.***.***</host>

    <port>3306</port>

    <name>livingroommusic</name>

    <user>kodi</user>

    <pass>kodi</pass>

  </musicdatabase>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

    <importresumepoint>true</importresumepoint>

  </videolibrary>

</advancedsettings>

(2018-05-27, 07:21)Yanta Wrote: These lines?
<rule field="playcount" operator="is">
        <value>0</value>
    </rule>

OK, I have removed them. I take it I need to do this on the Kodi server and every client?
So now, all recently added movies will stay on the list for everyone, until 20 new movies have been added. 

(2018-05-27, 07:32)Klojum Wrote:

(2018-05-27, 07:17)Yanta Wrote: No PC is used by more than one person. Each person has their own PC accessing a central Kodi Server where MYSQL is installed.

In that case, create a separate Kodi database per client, using the same video/music sources. You can name them via the advancedsettings.xml file.
Example of a client Kodi device in the living room, it should get you a livingroomvideo107 video database and livingroommusic60 music databases in the MySQL server. 

(2018-05-27, 12:10)trogggy Wrote: What's the point of using mysql if every pc has a (completely) separate database

(2018-05-27, 12:10)trogggy Wrote:

(2018-05-27, 07:32)Klojum Wrote:

(2018-05-27, 07:17)Yanta Wrote: No PC is used by more than one person. Each person has their own PC accessing a central Kodi Server where MYSQL is installed.

In that case, create a separate Kodi database per client, using the same video/music sources. You can name them via the advancedsettings.xml file.
Example of a client Kodi device in the living room, it should get you a livingroomvideo107 video database and livingroommusic60 music databases in the MySQL server.  

What's the point of using mysql if every pc has a (completely) separate database  You'd have to scan on every machine, so might as well use a local db.
Unless I've misunderstood the link in post #3 does what the op wants. 

(2018-05-27, 14:56)Yanta Wrote: Of course, "Stable and reliable" has not been my experience with Kodi so far. It's been incredibly fragile and temperamental for me.

(2018-05-27, 18:14)Klojum Wrote: To make matters 'worse': each profile can have a local database OR a link to a MySQL database. It's simply a choice you make. :-)

(2018-05-27, 14:56)Yanta Wrote: Of course, "Stable and reliable" has not been my experience with Kodi so far. It's been incredibly fragile and temperamental for me.

I have to say I have a very different experience with the last 6-7 stable releases, when it comes to storage, which was mostly with MySQL databases.
Perhaps your hardware components are coming of age lately, and getting unforeseen errors? 

(2018-05-28, 02:15)Yanta Wrote: Lol, no. The only part of my Kodi system which is not brand new is my case.