Posts: 17
Joined: Sep 2015
Reputation:
0
2019-01-01, 05:10
(This post was last modified: 2019-01-01, 05:10 by Megalith.)
I modified Kodi so "Date Added" corresponds to the file date (<dateadded>1</dateadded>), but my oldest movies don't seem to sort correctly.
All of my files have been modified so their created/modified/accessed dates are set to when the movie was released, and my two oldest are the following:
2001: A Space Odyssey (May 12, 1968)
The Bridge on the Water Kwai (December 14, 1957)
For some reason, these two are sitting all the way near the top, next to movies that were just released. Seems like a bug?
Posts: 13,684
Joined: Mar 2010
Reputation:
507
PatK
Team-Kodi Member
Posts: 13,684
2019-01-01, 07:26
(This post was last modified: 2019-01-01, 07:27 by PatK.)
I'm a little unsure these movies have been scraped correctly, I note that "The Bridge on the Water Kwai (December 14, 1957)" should be River; and "2001: A Space Odyssey (May 12, 1968)" is best scraped as "2001 A Space Odyssey (1968)". I should note the release date might be different, depending on the country or time of the year (New Year films are always shifted around).
Check inside the .nfo of these listings checking that the dates are set. A full debug log posted to a public pastebin and that URL linked back to this thread might shine a light on this mystery. Check my signature for the wiki on logs.
Posts: 17
Joined: Sep 2015
Reputation:
0
Sorry, that was just a typo on my part...the movies did scrape correctly (although I don't think that is important nor relevant, as the dates I am sorting by are from the media file itself and not scrapped metadata).
I'm not aware of any .nfo files being used, but I'll look into making a debug log.
Posts: 17
Joined: Sep 2015
Reputation:
0
Alright, I downloaded SQLite Database Browser to get a look at the dates, and it seems Kodi interprets very old and future dates incorrectly. 2001 is showing 2018-12-31 23:23:48.
I can't figure out how to edit the "dateAdded" field using the program, though...
Posts: 17
Joined: Sep 2015
Reputation:
0
Many thanks; I had been messing about in the wrong table ("movie_view" instead of "files").
Posts: 17
Joined: Sep 2015
Reputation:
0
2019-01-02, 20:29
(This post was last modified: 2019-01-02, 20:29 by Megalith.)
I noticed something interesting as I was scrolling through the table: nearly all of my movies have a duplicate entry, with the only difference being the dateAdded field (one has the created/modified/accessed file date, while the other has the date the file was scanned by Kodi). Is this normal?