When using a "Track da files" view and adding a field from the file entity (eg: "File:name"), or trying to add a relationship that uses the file, the following error is returned by views:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'file_managed.pid' in 'on clause'

Comments

arlina’s picture

Assigned: arlina » Unassigned
Status: Active » Needs review
StatusFileSize
new965 bytes

Attached is a patch to current ""7.x-1.4" that fixes this. Error was the relationship with the "file_managed" table was trying to join on a non-existing column.

  • federiko_ committed 828db2e on 7.x-1.x authored by Arlina
    Issue #2543642 by Arlina: Views: using file relationship gives "Column...
federiko_’s picture

Status: Needs review » Fixed
federiko_’s picture

Thanks Arlina for submitting this patch. I've added in 7.x-1.5 version

federiko_’s picture

Status: Fixed » Closed (fixed)