Hello,

MBP installed on drupal running postgreqs 9.3.
Building folders tree produces nothing.
Looking at the browser view produces silent errors on postgreql logs:

2015-08-02 23:51:18 CEST ERROR: column reference "fid" is ambiguous at character 617
2015-08-02 23:51:18 CEST STATEMENT: SELECT COUNT(*) AS expression
FROM
(SELECT file_managed.fid AS fid, file_managed.timestamp AS file_managed_timestamp, 1 AS expression
FROM
file_managed file_managed
LEFT JOIN file_usage file_usage ON file_managed.fid = file_usage.fid
LEFT JOIN field_data_field_folder field_data_field_folder ON file_managed.fid = field_data_field_folder.entity_id AND (field_data_field_folder.entity_type = 'file' AND field_data_field_folder.deleted = '0')
WHERE (( (file_managed.status IN ('0', '1')) )AND( (field_data_field_folder.field_folder_tid IS NULL ) OR (field_data_field_folder.field_folder_tid IN ('40')) ))
GROUP BY fid, file_managed_timestamp) subquery...

Was this module tested againt pg database ?

Thx

Comments

Denes.Szabo’s picture

This error is the same with sqlite, casused by this line: GROUP BY fid, file_managed_timestamp

Fid is the alias of the file_managed table fid field, but the file_usage table has a field named fid too.

I have not found real solution, just disable aggregation. More info is there: https://www.drupal.org/node/2192225

Liam Morland’s picture

Title: MBP breaks on postgresql database » MBP breaks on PostgreSQL database
Issue tags: -MBP media browser postgresql +PostgreSQL