1.26.0.5715-8cf78dab3 has broken my media

[Volts]

@pablo17

hosed my Plex database’s ‘metadata_items.created_at’ field

Plex changed the datatype of the internal metadata_items.created_at field. If you’re changing it manually, here’s a hint:

Can no longer update library database with sqlite3

@ourcore, there are lots of examples above! What have you tried? What platform are you using? Note to others - Plex 1.26.x has changed the datatype of datetime columns. Plex is now storing a unix-style seconds-since-1970-epoch time. Here’s a web toy for converting this format: https://www.epochconverter.com/ The sqlite strftime() function can be used in UPDATE statements to convert to epoch seconds on the fly; modify the YYYY-MM-DD and ABC as you would have before. UPDATE metadata_items SET…