Useful Snippets


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

Are your smart devices spying on you? Make better purchasing choices and find products that respect your privacy at

RSS Latest posts from my personal blog

Most viewed posts

Subscribe to RSS feed

Fixing shows or movies that are stuck in the “Recently added” list on Plex

Stanislav KhromovStanislav Khromov

If you have TV shows or movies stuck at the top of the “Recently added list”, these steps will resolve your issue.

Now go to “Execute SQL” and execute the following query:

update metadata_items
set added_at = created_at
where added_at >= date("now")

You should see results similar to:

Execution finished without errors.
Result: query executed successfully. Took 0ms, 12 rows affected

Example of what the results should look like


Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
Twitter Profile
Visit my other blog

Comments 2