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

jneubert’s picture

Status: Active » Closed (duplicate)

Just 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.