Trying to access File Manager leads to an error
Permalink
Hi!
My customer notified me about some issue on their site: when they are trying to access File Manager it gives the following error:
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'vanhaonk_crt.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
How can i fix this? Version 5.5.2.1. Thanks.
My customer notified me about some issue on their site: when they are trying to access File Manager it gives the following error:
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'vanhaonk_crt.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
How can i fix this? Version 5.5.2.1. Thanks.
I would have updated this long ago, but it seems unpossible, see this topic:https://www.concrete5.org/community/forums/installation/problems-upd... What im going to do now it to ask someone to fix it "paid" or quit using Concrete5 at all.
I have run into this also, it's the "ONLY_FULL_GROUP_BY" setting within mysql 5.7 that causes this issue, perhaps you can ask your host to turn that off?
I just ran that sql on one of my development sites using concrete5.6.4.0 and it ran successfully, so maybe an issue with mysql on your hosts server?
I would consider doing an incremental upgrade to 5.6.4.0 and maybe switch to PHP7...