A long time later, but I've finally got around to playing around with this to test different versions, because I wanted to replace a bunch of media but keep them in the same list position.
I've reinstalled Kodi v19.5 on my Pi (headless, manages my media mounted on the Pi), and my PC (windows 10, accesses via nfs, with path subtitution).
With Kodi V19.5 I can "touch -m" on the file on my Pi, and refresh on Windows Kodi, and the "dateAdded" changes based on the modified date I used with my touch command.
In the below screenshot of my V19 database, you can see date added was 2024-02-20, I then touched it to be 19th Feb and you can see it was then 2024-01-19 in the database after refresh, then touched again to be 28th Feb, and you can see that too.
Between each "touch", I used Kodi for Windows, brought up the context menu for the movie and selected "Information", then scrolled the buttons to the right and selected "Refresh" - it re-added to the the movie with an updated "date added" each time, moving the movie in my list (ordered by date added).
Code:
MariaDB [MyVideos119]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5368 | 9608 | 2024-02-20 15:42:00 | 32421 | 18039 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.011 sec)
MariaDB [MyVideos119]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5369 | 9608 | 2024-01-19 15:00:00 | 32423 | 18041 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.011 sec)
MariaDB [MyVideos119]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5370 | 9608 | 2024-02-28 11:00:00 | 32425 | 18043 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.010 sec)
I've then repeated this on Kodi 20.4, and the dateAdded is always the creation date. It's added to the database with the creation date, and doing a "touch" on the file to change the modified date doesn't change it (however you can see that some IDs changed, so it has re-scanned the file).
Following the steps as above with 19.5 but on 20.4, the dateAdded stays the same in the database, and on my movie list it doesn't move and stays as "26/02/2024":
Code:
MariaDB [MyVideos121]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' AND votes <> 14441 order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5547 | 10574 | 2024-02-26 13:36:58 | 32760 | 19896 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.011 sec)
MariaDB [MyVideos121]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' AND votes <> 14441 order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5549 | 10574 | 2024-02-26 13:36:58 | 32764 | 19900 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.009 sec)
and for completeness, tried on V21 Beta too, giving the same result as V20.4:
Code:
Database changed
MariaDB [MyVideos131]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' AND votes <> 14441 order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5546 | 10574 | 2024-02-26 13:36:58 | 32758 | 19892 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.007 sec)
MariaDB [MyVideos131]> select c00, idMovie, idFile, dateAdded, c05, c09, premiered, rating, votes from movie_view where c00 like 'Test%' AND votes <> 14441 order by dateAdded DESC limit 5;
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| c00 | idMovie | idFile | dateAdded | c05 | c09 | premiered | rating | votes |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
| Test | 5548 | 10574 | 2024-02-26 13:36:58 | 32762 | 19898 | 2023-11-13 | 5.7 | 20350 |
+------+---------+--------+---------------------+-------+-------+------------+--------+-------+
1 row in set (0.005 sec)
I've also tried Kodi for Mac to do the re-add or refresh, and also tried removing from library and re-scanning to the library using Kodi on the Pi.
On both, again only V19 adds it with the updated modified date as the dateAdded, V20 and V21 add it with the creation date.
I'll gather logs to see if that shows anything, but I briefly checked last night and didn't spot anything that seemed relevant.
