Plex Media Server - Recently added stuck in front

So i had an issue where few movies were stuck in fromt of the recently added queue.

Tried removing and re-adding them to Plex with no luck.

As the metadata for all the items are stored in a sqlite3 database the following procedure were used to correct the instances.

Steps to follow:

1. Find the item you want to edit
2. Find the database to edit
3. Exit Plex and update the database file.

Item you want to edit:

Select the movie or episode in question and select "..." >  "Info" or "Get Info" > "View XML" Bottom left of the window.
The property "ratingKey" is the id you need to update in the database.
Note: The date/time is stored in Unix Time in the XML output.

Database location:

On Windows install a SQLite editor e.g. SqliteBrowser
The database is located at

%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db

by default or can be found from the web interface: Settings > Server > General > "The path where local application data is stored value" + \Plex Media Server\Plug-in Support\Databases\ 

Edit Database:

Make sure to Exit / Close Plex Media server.

Open the database and select the "metadata_items" table.

Browse or search for the id with the value of ratingKey.

Update the time to the correct date/time, easiest would be to make the added_at value same as the created_at value.

Write/Save the changes back to the sqlite3 database and restart plex.

Command line:

This can be done from the command line as well with a command like:

UPDATE metadata_items SET added_at = created_at WHERE id=[value of ratingKey]

Plex - Amazon Kindle HDX

Recently the Kindle Fire HD stopped playing videos from plex, transcoding was active on the Plex server but still only sound played on the kindle.

After some research the following DLNA settings fixed the playback.

Select the Plex Server settings and "show advanced"

Select DLNA > DLNA client preferences:

Add the following:

IP=[IP of Kindle],DirectPlay=true,DirectStream=true,LocalResolution=1920x1080,RemoteResolution=1280x720,OnlineResolution=1280x720,LocalVideoQuality=74,RemoteVideoQuality=49,OnlineVideoQuality=49,SubtitleSize=100,AudioBoost=100,MusicBitrate=64