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

Get Help
1

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.

2

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.