[BUG] Clicking "Revised" column header in Media Library breaks Media Library

If “Revised” column header is clicked on in the Media Library, it stops showing any media until you click another column header (ID, Name,Type, etc).
“Showing 0 to 0 of 0 entries (filtered from NaN total entries)”

To Reproduce:

  • Go to Media Library and then click the column header: “Revised”

This happens in my custom install (1.8.9) and fresh docker image (1.8.11) with default settings.

Debug log from fresh docker image shows the following:
",WEB,/library,GET,“SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘revised’ in ‘order clause’ Exception Type: PDOException”,ERROR

I was scratching my head with this for a while and thinking “I broke the thing!” until I accidently clicked on another column header which fixed it.

What’s the purpose of the Revised property and how it’s used? Can’t seem find any documentation/options for it.

Thanks for your report.

I’ve logged a bug here:

Revised means that a new version of that media item was uploaded without deleting the old version. In that case, the CMS maintains old and new versions - so layouts that already exist use the old version and new layouts will use a new version.

It’s unlikely you’d want to sort by that, but we’ll address it anyway.