Keywords: Concrete5 - Google Cloud Platform - Technical issue - Other
I've included a document library block on one of my pages. I configure the block information and click "Save". The block doesn't appear on the page. When I exit Edit Mode, I get the following error:
An unexpected error occurred.
An exception occurred while executing 'SELECT distinct n.treeNodeID, if(nt.treeNodeTypeHandle='file', fv.fvTitle, n.treeNodeName) as folderItemName, if(nt.treeNodeTypeHandle='file', fv.fvDateAdded, n.dateModified) as folderItemModified, case when nt.treeNodeTypeHandle='search_preset' then 1 when nt.treeNodeTypeHandle='file_folder' then 2 else (10 + fvType) end as folderItemType, fv.fvSize as folderItemSize FROM TreeNodes n INNER JOIN TreeNodeTypes nt ON nt.treeNodeTypeID = n.treeNodeTypeID LEFT JOIN TreeFileNodes tf ON tf.treeNodeID = n.treeNodeID LEFT JOIN FileVersions fv ON tf.fID = fv.fID and fv.fvIsApproved = 1 LEFT JOIN FileSearchIndexAttributes fis ON fv.fID = fis.fID WHERE n.treeNodeParentID = ? ORDER BY fv.fvTitle asc LIMIT 20 OFFSET 0' with params ["44"]: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'bitnami_concrete5.fv.fvTitle' which is not in SELECT list; this is incompatible with DISTINCT
It appears that "bitnami_concrete5" has been injected into the column name "fv.fvTitle" without the db reflecting that.
Any ideas on how to correct/deal with this?