how to sort movies by file date and not by file added to database on plex qnap.
use at your own risk !!!
on your pc download and launch putty and logon your qnap nas and digit this four commands:
1 - (change to plex database directory) - (you need to replace with your own)
cd /share//.qpkg/PlexMediaServer/Library/Plex\ Media\ Server/Plug-in\ Support/Databases
example:
cd /share/CACHEDEV1_DATA/.qpkg/PlexMediaServer/Library/Plex\ Media\ Server/Plug-in\ Support/Databases
2 - (connect to plex database)
sqlite3 com.plexapp.plugins.library.db
3 - (change the sorting method) - (wait some seconds the process finish and the promt blink again) - (the command is one line)
update metadata_items set added_at=(select media_items.updated_at from media_items where media_items.metadata_item_id=metadata_items.id);
4 - (exit sqlite3 shell)
ctrl+D
notes:
the hack survive a library refresh
you need to apply again the hack if you create a new library or you update plex server
if your nas do not have sqlite3 command you need to install entware qkpg
intall splite3-cli package through "opkg install sqlite3-cli" command line
use at your own risk !!!
i have no sql or linux skill so i can't help you is something goes wrong
all credits to losangeles and SolarPlex from plex forum.
