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'

CommentFileSizeAuthor
#1 track_da_files-views-file-relationship-fix-2543642--1.patch965 bytesarlina

Comments

arlina’s picture

arlina commented
Assigned: arlina » Unassigned
Status: Active » Needs review
StatusFileSize
new track_da_files-views-file-relationship-fix-2543642--1.patch965 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

federiko_ commented
Status: Needs review » Fixed
federiko_’s picture

federiko_ commented

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

federiko_’s picture

federiko_ commented
Status: Fixed » Closed (fixed)