Closed (duplicate)
Project:
D7 Media
Version:
7.x-2.x-dev
Component:
Media Browser
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Feb 2013 at 13:54 UTC
Updated:
15 Feb 2013 at 08:31 UTC
After installing Media 7.x-2.0-unstable7+25-dev (+ file_entity -dev), I can't see the media types in the field configuration screen, nor anything about the Media Browser.
When I open the Media Browser view with "edit", I get the above SQL error. This makes sense, because Postgres (at least 8.4) is picky about ambiguous field names, even if they are guaranteed to have the identical value, as in the displayed query:
SELECT file_managed.timestamp AS file_managed_timestamp, file_managed.fid AS fid, SUM(file_usage.count) AS file_usage_count
FROM
{file_managed} file_managed
LEFT JOIN {file_usage} file_usage ON file_managed.fid = file_usage.fid
WHERE (( (file_managed.status IN ('1')) ))
GROUP BY file_managed_timestamp, fid
ORDER BY file_managed_timestamp DESC
Unfortunatly I don't know enough about Views to figure out how this should be handled properly (nor to verify that the missing media types in the field configuration are really caused by the sql error).
Comments
Comment #1
jneubert commentedJust found out that this is a duplicate of #1400988: PostgreSQL 'Exception: SQLSTATE[42702]: Ambiguous column: 7 ERROR: column reference "fid" is ambiguous in the Views issue queue. The patch mentioned there fixed the sql error for me.