|
Post Title |
Forum |
|
Windows - Cannot set file date top a date prior to 1980 ...
By Hans, 2 weeks ago
|
Delphi, Lazarus, Free Pascal |
|
So I ran into this little issue ... (thanks to user Granny646)Since Windows 8, it seems that Windows doesn't like file dates prior to 1980.This seems a mixed bag of certain functions (for example File... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By Hans, 3 weeks ago
|
Home Theatre |
|
No worries 😉
Maybe this explains it better ..
The "Latest Movies" or "Latest TV Show Episodes" are listed by the date they were added, which is understandable - this way we'd see the most rec... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By allanjoel, 3 weeks ago
|
Home Theatre |
|
Sorry for the delay, but yes my db its empty because im testing on a new installation.
Perhaps I did not understand very well how to do it and that it was necessary to have a library and So this mean... |
|
RE: iPhone - How to get your phone in "Field Test Mode"?
By Hans, 3 weeks ago
|
iOS Devices |
|
You could try using - and use the "Find iPhone" option.
Attachment : image.png
Caution: the "Find My iPhone" feature needs to be enabled on your phone to make this work.From what I read on the... |
|
RE: iPhone - How to get your phone in "Field Test Mode"?
By mharoonpir, 3 weeks ago
|
iOS Devices |
|
My iPhone was missing from my house how can I find my device online should I use Apple Id or something else? |
|
RE: Waking up a Mac with Wake On LAN
By Hans, 3 weeks ago
|
MacOS X Software |
|
Apple could have made this much easier on all of us - that's for sure 😉 |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By Hans, 3 weeks ago
|
Home Theatre |
|
p.s. you can find this OS and JellyFin version in JellyFin's Dashboard.
Should show something like this (name and version different of course on your system, shown on the leftside)
Server: MyQNAP
Ver... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By Hans, 3 weeks ago
|
Home Theatre |
|
Just checked your DB file, but there is no media content in it. Like totally nothing.I assume you picked the wrong library.db file or your version of JellyFin isn't storing its data there. 😳
... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By allanjoel, 3 weeks ago
|
Home Theatre |
|
im sorry bro ill try but when i run the code says that change some rows but when i go to jellyfin always shows latest added now the release date
could you please check or edit the db please 😉 ... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By Hans, 3 weeks ago
|
Home Theatre |
|
No problem:
Click the tab "Execute SQL", paste the SQL statement, and "Execute" (play) button.
Attachment : image.png
SQL:
UPDATE TypedBaseItems SET DateCreated=PremiereDate;
p.s. do not f... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By allanjoel, 3 weeks ago
|
Home Theatre |
|
@hans Bro im here but i dont know whats the next step, could you please help me
Attachment : image.png |
|
How to install Wireguard on an Amazon Fire TV stick
By Hans, 3 weeks ago
|
Android Devices |
|
I like to use repurpose my old Amazon Fire TV stick, by installing WireGuard on it so I can access my media at home (I have a Wireguard server running on my firewall).
For this I would need to do 2 st... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By Hans, 3 weeks ago
|
Home Theatre |
|
Depends on your JellyFin setup ... mine (QNAP) was located in the "DB/data/" directory found the install directory of JellyFin.The database file is called library.db.
Note that SQLite is a single user... |
|
RE: Jellyfin - How to make "Latest Movies" and "Latest TV Shows" show latest released, instead of latest added
By allanjoel, 3 weeks ago
|
Home Theatre |
|
@hans Hi, where is the db to change this:
UPDATE TypedBaseItems SET DateCreated=PremiereDate; |
|
Wordpress - SQL to remove inactive users
By Hans, 4 weeks ago
|
Web Development |
|
Be careful with this - as you may be tossing the wrong users ... so only do this if you understand what you're doing.
Here 3 queries to help you find and remove inactive users on a multisite Wordpress... |